This discussion is archived
1 2 3 Previous Next 35 Replies Latest reply: Sep 12, 2012 4:36 AM by Sunny kichloo RSS

PING[ARC1] Heartbeat failed to connect to standby 'xxxxx'.Error is 12154

961013 Newbie
Currently Being Moderated
Hi Guru's

I am facing common error in dataguard while setting up the physical standby database.

Error:*

PING[ARC1] Heartbeat failed to connect to standby 'std-prm'.Error is 12154.



I am able to connect from standby to primary and vice versa using corresponding tns entry names.but even am getting above error.


Here am jsut pasting few lines of the primary alert log file.

Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Fri Sep 07 17:13:34 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Fri Sep 07 17:19:34 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Fri Sep 07 17:31:55 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Fri Sep 07 17:32:31 2012
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_m001_18403.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
Fri Sep 07 17:37:58 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Mon Sep 10 11:50:45 2012
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_j000_18920.trc:
ORA-25153: Temporary Tablespace is Empty
Mon Sep 10 11:50:48 2012
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_j001_18924.trc:
ORA-25153: Temporary Tablespace is Empty
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_j001_18924.trc:
ORA-12012: error on auto execute of job 11689
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
Mon Sep 10 11:51:06 2012
Suspending MMON slave action kehslave_ for 82800 seconds
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_m002_19082.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
Mon Sep 10 11:51:34 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.
Mon Sep 10 11:57:35 2012
Error 12154 received logging on to the standby
Errors in file /u01/diag/rdbms/orcldb/orcldb/trace/orcldb_arc1_13741.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC1]: Heartbeat failed to connect to standby 'stdb-prim'. Error is 12154.


please anyone help me in resolve this error ASAP.

kind Regards,
poonra.
1 2 3 Previous Next

Legend

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