6 Replies Latest reply: Dec 16, 2013 9:30 PM by Alvaro RSS

    Synchronization errors between Primary and Standby - Cause of Performance Issue




      We have one Informatica Repository Database which also has a standby Database configured.

      One one of the days we had synchronization errors as mentioned below.


      Sun Dec 15 05:07:19 2013

      Errors in file /opt/oracle/admin/ROSINP/bdump/rosinp_arc0_802.trc:

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

      PING[ARC0]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=uora115r)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=rosinr_XPT

      .bsca.eds.com)(INSTANCE_NAME=rosinr)(SERVER=dedicated)))'. Error is 16191.

      Sun Dec 15 05:12:19 2013

      Error 1017 received logging on to the standby


      Can this alone be a cause of the Informatica service going down?Also can this synchronization error result in performance issues?

      There are no DB related errors on the Database other than this.