Oracle Study Notes: Dynamic and Static listeners

Dynamic listening:

After the Oracle listener runs, the Oracle instance dynamically listens to the listener when it is open.ProgramRegister service_names and instance_name.

The default instance_name is:Db_name

The default value of service_names is:Db_name.db_domain

 

Static listening:

After the Oracle instance runs, when the listener starts, the corresponding service is registered according to the configuration of listener. ora.

Global_dbname corresponds to the external service name of Oracle, that is, service_names in the initialization parameter

The sid_name corresponds to the name of the oralce instance, that is, the instance_name in the initialization parameter.

 

Why do I need static listeners for dynamic listeners? The reason is as follows:

1. The Listener is not started earliest. The Oracle instance is started first.

2. Listener restart

3. Oracle instance does not have open