Home » RDBMS Server » Security » Ora-01031: insufficient privileges on 10.2.0.4 version for single Instance DB (10.2.0.4 on RHEL 3.0)
Ora-01031: insufficient privileges on 10.2.0.4 version for single Instance DB [message #342687] Sun, 24 August 2008 02:08 Go to next message
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
Re: Ora-01031: insufficient privileges on 10.2.0.4 version for single Instance DB [message #344022 is a reply to message #342687] Thu, 28 August 2008 10:53 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
There is a NOTE on Metalink which is a checklist to resolve this situation. It works.
Previous Topic: Execution plan privileges
Next Topic: migrate oracle 8i to 10g
Goto Forum:
  


Current Time: Thu Mar 28 18:28:37 CDT 2024