| Ora-01031: insufficient privileges on 10.2.0.4 version for single Instance DB [message #342687] |
Sun, 24 August 2008 02:08  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi experts,
Hope you are doing good.
I am running Oracle 10.2.0.4 on RHEL 3.0 using vmware on Testing environment. I have one RAC DB(Name: btito) and one single instance DB(Name: testdb)
Both databases sharing the same Oracle Home.
When i am trying to connect to the single instance DB(testdb) using "sys/<passwd>@testdb as sysdba", It throws Ora-01031: insufficient privileges. But it allows to connect another user(let say sqlplus nnn/nnn@testdb). The parameter remote_login_passwordfile is set to exclusive.
I recreated the password file and rebounce the DB but the problem still there.
But when i try to connect my RAC DB using "sys/<passwd>@btito1 as sysdba" it works fine.
I tried the same after creating sqlnet.ora file in $ORACLE_HOME/network/admin with
SQLNET.AUTHENTICATION_SERVICES = (NTS)
but it doesn't make any difference.
Thanks in advance for your help.
Regards
Lalit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
