Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLNET.AUTHENTICATION_SERVICES = (NONE) and ASM

Fahd.MirzaMay 19 2010 — edited May 19 2010
Hi,
I am running Oracle 10gR2 on Solaris 5.10.

I am using ASM. My ASM instance is +ASM and my database instance orcl.

Initially there was no sqlnet.ora file on my sever and I was able to log in to my database instance and ASM instance without giving password of sysdba by doing
$ export ORACLE_SID=orcl
$ sqlplus /nolog
$ conn / as sysdba
connected.
Then I created sqlnet.ora file and made following entry in it:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
Then on log in time, it started asking for the sysdba password.

But then my archiver process stopped and database halted and except sysdba no one was able to login, and in alert log file there was message saying:
ORA-01031: insufficient privileges
Tue Apr 13 10:40:39 2010
Unexpected communication failure with ASM instance:
Then I deleted the sqlnet.ora file and the error was gone and everything worked fine.

Please shed light on this

regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on May 19 2010
9 comments
10,823 views