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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment