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.