Dynamic listening:
When an Oracle instance is started, or the command alter system register is used, or every minute, the PMON process dynamically registers with the listener. the instance_name and service_names parameters in ora dynamically register instances and services to listener. After the oracle listener runs, the oracle instance dynamically registers service_names and instance_name with the listener when it is open. You can use show parameter instance_name and show parameter service_names to view the Instance name and service name. There can be multiple service names;
The default instance_name is db_name.
The default value of service_names is db_name.db_domain.
If the service_names and instance_name values are not explicitly set, dynamic registration only occurs when the database is started after the listener is running. In this case, dynamic registration information will be lost if the listener is restarted later.
[Content navigation] |
Page 1: Dynamic listening |
Page 1: static listeners |