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/18.104.22.168/orapwRECOVER2 SCP to remote host scp /u01/app/oracle/product/22.214.171.124/dbs/orapwRECOVER2 email@example.com:/u01/app/oracle/product/126.96.36.199/dbs/ Then rename the file to : /u01/app/oracle/product/188.8.131.52/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