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