This content has been marked as final. Show 1 reply
Its probably a missing password file
scp the password from the primary to the standby and rename.
Password on source is: /u01/app/oracle/product/126.96.36.199/orapwRECOVER2 SCP to remote host scp /u01/app/oracle/product/188.8.131.52/dbs/orapwRECOVER2 email@example.com:/u01/app/oracle/product/184.108.40.206/dbs/ Then rename the file to : /u01/app/oracle/product/220.127.116.11/dbs/orapwRECLONE
select * from v$pwfile_users;
User running must have sysdba role granted.
A user from a remote machine can connect to the database as sysdba using password file authentication.
There are generally two method through which a user can connect to oracle database AS SYSDBA :
Password file authentication