This discussion is archived
6 Replies Latest reply: Dec 16, 2013 7:30 PM by Alvaro RSS

Synchronization errors between Primary and Standby - Cause of Performance Issue

user7202581 Newbie
Currently Being Moderated

Hi,

 

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.

 

Regards,

Narayan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points