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