ORA-01031: insufficient privileges While trying / as sysdba
534640Apr 9 2008 — edited Aug 13 2013Hi All,
We have oracle database 10.2.0.3 on Linux x86 32 bit Server.
We are trying to connect our database with sysdba and getting [ORA-01031: insufficient privileges ] error.
I have recreated the password file:
orapwd file=orapwdPRODT password=mypassword
But still we are unable to login
-------------------------------------------------------------------------
sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:22:27 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
[oracle@dev1 PRODT_dev1]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:33:30 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
Please note that we are able to login if we supply exact password which is in password file. But / as sysdba command is giving above errors.
My sqlnet.ora file is having entries:
SQLNET.AUTHENTICATION_SERVICES=(NTS)
I have also tried by removing this line but same error exist.
MY initPRODT.ora file is having this entry:
remote_login_passwordfile='EXCLUSIVE'
I have searched through metalink and google and normally this kind of errors resolved by recreating the password file. I have tried these solutions but unable to resolve this issue.
I have also followed Note:435947.1 and tried to relink the config files but again same problem exist.
Can any one help me in this regard???