Friday, July 6, 2018

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

Password file difference is one of the biggest causes of log shipping failure from primary database to the standby. Follow this document to resolve ORA-1619. Following is what would appear in the alert log file if log shipping fails because of password file differences between primary site and standby site.

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
------------------------------------------------------------
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance MYDB - Archival Error. Archiver continuing.
Wed Jul 04 22:43:58 2018
Archived Log entry 1282972 added for thread 1 sequence 225290 ID 0xbfe6d35e dest 1:
Wed Jul 04 22:44:11 2018
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
------------------------------------------------------------
FAL[server, ARC1]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance MYDB - Archival Error. Archiver continuing.
Wed Jul 04 22:49:37 2018
Thread 1 advanced to log sequence 225292 (LGWR switch)
  Current log# 4 seq# 225292 mem# 0: +REDO1/mydb/onlinelog/group_4.260.814774489
  Current log# 4 seq# 225292 mem# 1: +REDO2/mydb/onlinelog/group_4.259.814774513
Wed Jul 04 22:49:38 2018
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Wed Jul 04 22:49:38 2018
Archived Log entry 1282987 added for thread 1 sequence 225291 ID 0xbfe6d35e dest 1:
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
------------------------------------------------------------
Errors in file /u01/oracle/base/diag/rdbms/mydb/MYDB/trace/MYDB_nsa2_51031.trc:
ORA-16191: Primary log shipping client not logged on standby
Wed Jul 04 22:50:40 2018
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
------------------------------------------------------------
Wed Jul 04 22:56:42 2018
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
------------------------------------------------------------
Wed Jul 04 22:57:44 2018
Thread 1 advanced to log sequence 225293 (LGWR switch)
  Current log# 5 seq# 225293 mem# 0: +REDO1/mydb/onlinelog/group_5.261.814774529
  Current log# 5 seq# 225293 mem# 1: +REDO2/mydb/onlinelog/group_5.260.814774545

No comments:

Post a Comment

Popular Posts - All Times