When tried to sarted oracle, I got the following error:
ERROR: ORA-01031: insufficient privileges
Following were the steps that I used to start the database instance:
1) Start sqlplus with nolog
# > sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 12 14:40:02 2010
(c) 1982, 2005, Oracle. All rights reserved.
SQL>
2) Connect to oracle as sysdba
SQL> connect sys/password as sysdba;
ERROR:
ORA-01031: insufficient privileges
I hecked around and it turned out the problem was the parameter setting in the sqlnet.ora file.
In my case, the sqlnet.ora file (stored in the $ORACLE_HOME/network/admin directory) contained the following line:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
I changed it to:
SQLNET.AUTHENTICATION_SERVICES= (ALL)
And, I was able to connect to oracle using "connect sys/password as sysdba" and stated the database instance and open the database.
This pointed me to look at the SQLNET.AUTHENTICATION_SERVICES again.
The parameter can set to :
• NONE : cannot connect to database without a password as sysdba (sqlplus /as sysdba)
• NTS: set for using windows NT native authentication
• ALL: ALL for all authentication methods
Authentication Methods Available with Oracle Advanced Security:
• kerberos5 for Kerberos authentication
• cybersafe for Cybersafe authentication
• radius for RADIUS authentication
• dcegssapi for DCE GSSAPI authentication
If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
References:
Posts
No comments:
Post a Comment