FAL[server, ARC3]: Error 12541 creating remote archivelog file ‘dbx01’ – PING[ARC2]: Heartbeat failed to connect to standby ‘dbx01’. Error is 12541.

Cause:

MRP is not applying logs to standby database due to heartbeat issue

MESSAGE
--------------------------------------------------------------------------------
ARC1: Completed archiving thread 1 sequence 75 (3766426-3767787)
Error 12541 received logging on to the standby
Check whether the listener is up and running.
FAL[server, ARC3]: Error 12541 creating remote archivelog file 'dbx01'
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Error 12541 for archive log file 4 to 'dbx01'
Error 12541 received logging on to the standby
Check whether the listener is up and running.

MESSAGE
--------------------------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'dbx01'. Error is 12541.
Error 12541 received logging on to the standby
Check whether the listener is up and running.
FAL[server, ARC3]: Error 12541 creating remote archivelog file 'dbx01'
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Error 12541 for archive log file 1 to 'dbx01'
ARC1: Beginning to archive thread 1 sequence 76 (3767787-3770055)
ARC1: Completed archiving thread 1 sequence 76 (3767787-3770055)
Error 12541 received logging on to the standby
Check whether the listener is up and running.

Workaround:

If tnsping is not working, then check for your tns entries correction

kish@PRIM>!tnsping dbx01

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 02-OCT-2021 12:23:30

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.197)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbx01)(UR = A)))
OK (0 msec)


-bash-4.2$ tnsping dbx00

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 02-OCT-2021 12:23:36

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
/apps01/product/12.1.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.41)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbx00)))
OK (0 msec)

Check if listener is up and running

-bash-4.2$ lsnrctl start

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 02-OCT-2021 12:21:39

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /apps01/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /apps01/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /apps01/base/diag/tnslsnr/orcl19x/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.197)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.197)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                02-OCT-2021 12:21:40
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /apps01/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /apps01/base/diag/tnslsnr/orcl19x/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.197)(PORT=1521)))
Services Summary...
Service "dbx01" has 1 instance(s).
  Instance "dbx01", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl19x1" has 1 instance(s).
  Instance "orcl19x1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s