Tuesday, November 25, 2008

ORA-01031: insufficient privileges

solution 1.
SQL> conn sys/sys123@orat32 as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
Recreated the service using ORDIM

solution 2.
I changed the permission of passwordfile in dbs path and recreated the password file.
In windows I am getting this error I made remote_passwordfile=exclusive to NONE

solution 3.
Changed the owner of the passwordfile in dbs path from oraguest to oracle.
#cd $ORACLE_HOME/dbs
# chown oracle:oinstall orapwORAT33

solution 4.
Solution:In TNSNAMES.ORA (SERVICE_NAME=SID) given wrong.

Now it is working fine.

No comments: