Visit Counter

Tuesday, February 4, 2014

ORA-01031: Insufficient Privileges



When I try to connect standby database (orastd) from primary database (orapri) getting error.


SQL> conn sys/pwd@orastd as sysdba
Error: ORA-01031: insufficient privileges

Solution:

Standby Server
-----------------

/ora/oracle/ora11g/dbs

(Just change the permission of password file)

$ chmod 777 orapworastd
$ chgrp oinstall orapworastd


SQL> conn sys/pwd@orastd as sysdba
connected.