Translate

Search This Blog

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


On primary:

SQL> alter system switch logfile;
System altered.

SQL>select status,error from v$archive_dest where dest_id=2;
STATUS    ERROR
--------- -----------------------------------------------------------------
ERROR     ORA-16191: Primary log shipping client not logged on standby

There was password file and both primary and standby databases and they had same passwords still I received above error and I noticed primary database was not shipping archive log files to standby nodes.

I took below steps at both nodes:

1. deleted cureent password files of both primary and standby database

2. created password files for both databases with same option as below:
orapwd file=orapwtestdb password=sys entries=100 ignorecase=Y
orapwd file=orapwstdby password=sys entries=100 ignorecase=Y

3. chang init parameter on both databases to make passwords case insensitive:

alter system set sec_case_sensitive_logon=false;
Earlier I received below obvious error as I forgot to create password file for standby database and password is a must for log shipping from 10g.

SQL> alter system switch logfile;
System altered.
SQL> select status,error from v$archive_dest where dest_id=2;
STATUS    ERROR
--------- -----------------------------------------------------------------
ERROR     ORA-01031: insufficient privileges