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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01031: insufficient privileges While trying / as sysdba

534640Apr 9 2008 — edited Aug 13 2013
Hi 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???

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 10 2013
Added on Apr 9 2008
26 comments
265,860 views