Oraclelistener static registration and Dynamic Registration Summary

Welcome to the Oracle community forum and interact with the 2 million technical staff. 1. What is registration? Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users and can apply to connect to the database. This service name may be the same as the Instance name

Welcome to the Oracle community forum and interact with 2 million technicians> 1. What is registration? Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users and can apply to connect to the database. This service name may be the same as the Instance name

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

1. What is registration?

Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users and can apply to connect to the database. The service name may be the same or different from the instance name.

When the database server is started, the database server registers the corresponding service with the listener (whenever a database is started, two messages are registered to the listener by default: the instance and service corresponding to the database server .)

As a result, there is a Listener (Listener) between the database server and the client. In the Listener, the service name corresponding to the database is recorded (one database may have multiple service names). When the client needs to connect to the database, only the service name is required, you can establish a connection between the client and the server.

Ii. Static Registration

Static registration is to read the configuration of the listener. ora file when the instance starts, and register the instance and service to the listener. Whenever a database is started, two messages are registered to the listener by default: The instance and service corresponding to the database server.

During static registration, GLOBAL_DBNAME in listener. ora provides the service name externally, and SID_NAME in listener. ora provides the registered Instance name.

When static registration is adopted, the content in listener. ora is as follows:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)

(SID_NAME = orcl)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl1)

(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)

(SID_NAME = orcl)

)

)

This file indicates that the database is a single instance and the Instance name is orcl. It provides two external services: orcl and orcl1.

[1] [2]