LISTENER STATUS “BLOCKED”
When setup of dataguard , the standby database listener status display ‘blocked’ status . This is due to configuration of dynamic listener.
[grid@orcldg ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-JUN-2021 19:55:47
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 06-JUN-2021 18:11:15
Uptime 0 days 1 hr. 44 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/base/product/12.1.0/grid/network/admin/listener.ora
Listener Log File /grid/base/diag/tnslsnr/orcldg/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Services Summary...
Service "ORCLDGP" has 1 instance(s).
Instance "orcldgp", status BLOCKED, has 1 handler(s) for this service...
The listener entry should look like following with static connection
[grid@orcldg ~]$ cat /grid/base/product/12.1.0/grid/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora Network Configuration File: /grid/base/product/12.1.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=ORCL)
(SID_NAME = orcldg)
(ORACLE_HOME = /grid/base/product/12.1.0/grid)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME=ORCL)
(SID_NAME = orcldgp)
(ORACLE_HOME = /grid/base/product/12.1.0/grid)
(PROGRAM = extproc)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
TNS entry should look like this if you connect to auxiliary instance in dataguard
[grid@orcldg ~]$ cat /grid/base/product/12.1.0/grid/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/base/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCLDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcldg)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcldg)(UR = A)
)
)
ORCLDGP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.200)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcldgp)(UR = A)
)
)
Now you should bounce the listener
[grid@orcldg ~]$ lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-JUN-2021 20:12:56
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
[grid@orcldg ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-JUN-2021 20:13:01
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /grid/base/product/12.1.0/grid/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /grid/base/product/12.1.0/grid/network/admin/listener.ora
Log messages written to /grid/base/diag/tnslsnr/orcldg/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 06-JUN-2021 20:13:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/base/product/12.1.0/grid/network/admin/listener.ora
Listener Log File /grid/base/diag/tnslsnr/orcldg/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
Services Summary...
Service "orcldgp" has 1 instance(s).
Instance "orcldgp", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
(or)
[grid@orcldg ~]$ lsnrctl reload
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-JUN-2021 21:00:08
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
Perform a tnsping from primary dataguard
[grid@orcl ~]$ tnsping orcldgp
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 06-JUN-2021 21:00:55
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/grid/base/product/12.1.0/grid/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.212)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcldgp)(UR = A)))
OK (0 msec)