1 2 3 Previous Next 35 Replies Latest reply: Sep 12, 2012 6:36 AM by Sunny kichloo RSS

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

    961013
      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