Thursday, January 25, 2018

Oracle Standby Database Issue - ORA-16191: Primary log shipping client not logged on standby

Error : ORA-16191: Primary log shipping client not logged on standby

Resolution:

Issue can be resolved after creating password files in both primary and standby databases.

orapwd file=orapwPROD password=oracle entries=10 ignorecase=Y

Then start the synchronization again with below.
SQL> alter database recover managed standby database disconnect from session;