Heartbeat failed to connect to standby

Error on shipping log to standby

Error 12504 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uatdb01)(PORT=1529))(CONNECT_DATA=(SERVER=DEDICATED)(SID_NAME=TABS2)))'. Error is 12504.

Error 1033 received logging on to the standby

Solution

There are many reasons but, mainly check DG_CONFIG, LOG_ARCHIVE_DEST_2 and TNS entries, if all okey then check password file, if possible recreate password file on primary and copy it to standby.

RMAN-04006: error from auxiliary database: ORA-12514

Error:

Got error while creating DUPLICATE TARGET DATABASE from auxiliary after create spfile from memory

sql statement: create spfile from memory

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/13/2018 13:08:27
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

Solution:

Create separate listener for RMAN duplication in Target,Update the Tnsnames.ora and try.

Create a static entry in listener configuration for auxiliary database.

RMAN-04006 And ORA-12514 During RMAN Duplicate [ID 883490.1]
Connection to Auxilary using connect string failed with ORA-12528 [ID 419440.1]
How to resolve ORA-16792 [ID 966472.1]

RMAN-04006 from auxiliary database

Error:

Getting below error while "DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE"

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Cause:

Service handler is blocking connections.

Solution:

Append (UR=A) clause in "CONNECT_DATA=" section of TNS to allow a privileged or administrative user to connect via listener

Example:

UAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = uatdb01)(PORT = 1529))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = UAT)
  (UR = A)
    )