What should I do when listening to BLOCKED in duplicate causes listening to be turned off automatically?
This article introduces what to do when listening to BLOCKED in duplicate leads to automatic shutdown. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.
Pay attention to setting listener.ora under grid user
Su-grid
Cd / u01/app/grid/product/11.2.0/grid
Vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = db-dg) (PORT = 1521)-- you can also enter the host name or IP address of the host.
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcldb)-enter the instance name
(ORACLE_HOME = / u01/app/oracle/product/11.2.0/dbhome_1)
(GLOBAL_DBNAME=orcldb_dg)-fill in the service name
)
)
The yellow word is the modified part. Note that the green part is filled in the $ORACLE_HOME path under oracle users.
It should be noted here that after modifying the listener.ora file, you need to restart listening.
Under grid users
Srvctl stop listener
Srvctl start listener
About what to do about what to do when listening to BLOCKED is automatically turned off in duplicate. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.
