Forum Stats

  • 3,758,248 Users
  • 2,251,359 Discussions
  • 7,870,124 Comments

Discussions

ORA-01031: insufficient privileges While trying / as sysdba

534640
534640 Member Posts: 236
edited Aug 13, 2013 6:19PM in General Database Discussions
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
-----------------------------------------------------------------------
[[email protected] 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???
Alvarouser4879448user101314363230652User_96XBT
«13

Comments

This discussion has been closed.