Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.