Hi ,
I am on oracle 11.2.0.2.0
i have a dataguard setup. Although the archives are getting applied manually but when i set it to automatic , i see that the logs are not getting copied and the follow error comes in the alert log of production :
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
I checked on the metalink note [ID 1368170.1] but its not helping.
1. Changed the password for sys on prod.
2. Could not change on BCP since it was mounted.
3. No password file exist on prod but created one on the BCP with sys password same as in prod.
4. Parameter remote_login_passwordfile is set for both :
sqlplus sys/pwd as sysdba
Prod :
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
BCP:
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
5.select * from v$pwfile_users; gives the below output:
Prod :
SQL> select * from v$pwfile_users;
no rows selected
BCP :
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
Now how do i make sure the logs are getting copied becuase till then i need to apply manually :(
Regards
KK