ora-01031 insufficient privilege error
Oracle 9.2.0
Windows 2000
Trying to connect to Oracle server (from the server itself).
Windows user is a member of ora_dba group, and also in local admin group. Plus in sqlnet.ora file, the authentication is set to NTS.
However, I can't connect to Oracle server when login as windows user w/o providing a password. What I did was:
c:> sqlplus /nolog
sql> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges.
So what went wrong here? I feel I've set everything the way it needs to be, but just can't get it work.
FYI -- the Oracle was installed when I logged in as administrator to the local machine. And now I'm log in as a domain user. Of course, both local admin and the domain user are member of ora_dba and local admin group.
Any hint is greatly appreciated!
Re: ora-01031 insufficient privilege error
Quote:
Originally posted by elaine3839
Oracle 9.2.0
Windows 2000
Trying to connect to Oracle server (from the server itself).
Windows user is a member of ora_dba group, and also in local admin group. Plus in sqlnet.ora file, the authentication is set to NTS.
However, I can't connect to Oracle server when login as windows user w/o providing a password. What I did was:
c:> sqlplus /nolog
sql> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges.
So what went wrong here? I feel I've set everything the way it needs to be, but just can't get it work.
FYI -- the Oracle was installed when I logged in as administrator to the local machine. And now I'm log in as a domain user. Of course, both local admin and the domain user are member of ora_dba and local admin group.
Any hint is greatly appreciated!
Try this may help you:
From Metalink Note:50507.1
OSDBA & OSOPER Groups on NT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The 'OSDBA' and 'OSOPER' groups on NT are simply groups with the name "ORA_DBA", "ORA_OPER", "ORA_sid_DBA" or "ORA_sid_OPER", where 'sid' is the instance name.
Eg: To make a user an administrative user simply:
a) Ensure there is a line in the SQLNET.ORA file which reads: SQLNET.AUTHENTICATION_SERVICES = (NTS)
b) Create a LOCAL user
c) Create a local NT group ORA_DBA or ORA_sid_DBA where 'sid' is in upper case
d) Add the user to the ORA_DBA or ORA_sid_DBA group
e) That user should now be able to "connect / as sysdba"
Hope this helps.
Re: Re: ora-01031 insufficient privilege error
Thanks! I think I have everything mentioned in this KB note(see my original post), but it still doesn't work. Actually, you don't have to create ORA_DBA group manually (at least to me). It got created by installer when you install Oracle.
Quote:
Originally posted by gnagesh
Try this may help you:
From Metalink Note:50507.1
OSDBA & OSOPER Groups on NT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The 'OSDBA' and 'OSOPER' groups on NT are simply groups with the name "ORA_DBA", "ORA_OPER", "ORA_sid_DBA" or "ORA_sid_OPER", where 'sid' is the instance name.
Eg: To make a user an administrative user simply:
a) Ensure there is a line in the SQLNET.ORA file which reads: SQLNET.AUTHENTICATION_SERVICES = (NTS)
b) Create a LOCAL user
c) Create a local NT group ORA_DBA or ORA_sid_DBA where 'sid' is in upper case
d) Add the user to the ORA_DBA or ORA_sid_DBA group
e) That user should now be able to "connect / as sysdba"
Hope this helps.