ERROR ORA-16191: Primary log shipping client not logged on standby
Problem:
standby database throws error
select dest_name, status, error from gv$archive_dest;
SQL>
DEST_NAME STATUS ERROR
————————————————– ——— —————————————————————–
LOG_ARCHIVE_DEST_1 ERROR ORA-16191: Primary log shipping client not logged on standby
Discovery: Problem with password file. Primary and standby does not have same password file.
Solution:
create same password file either on standby or primary database
srvctl modify database -d prm -pwfile
orapwd file=’+ORADATA1′ dbuniquename=prm password=abc format=12
srvctl modify database -d prmyc -pwfile
orapwd file=’+ORADATA1′ dbuniquename=stby password=abc format=12
No comments yet