Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i/W2K, starting db under different user account
Hi,
I am trying to get full admin functionality on my Oracle instance with a local admin account.
When I logon as a domain user with local admin rights (ACCOUNTA) on that W2K box, I get "insufficient privileges".
Oracle was installed using a domain admin account (ACCOUNTB) and I can start it fine whe I am logged on with that.
Basically, I am running "SQLPLUS /nolog", the entering the following:
connect sys/database1 as sysdba
startup
at which point it returns "insufficient privileges".
The "domain user/local admin" account (ACCOUNTA) is a member of the ORA_DBA group on the local server, and in fact, I have created a domain group called "Oracle admins", added the "domain user/local admin" account to it, and added the group to the ORA_DBA group.
I have also looked in SQLNET.ORA and the line says:
SQLNET.AUTHENTICATION_SERVICES = (NTS) So, not sure what else I need to change to get that W2KAD account to be able to start the database.
BTW, the Oracle services are running using the localsystem account...
Cheers Received on Mon Jun 28 2004 - 03:25:04 CDT