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. www.2cto.com where instance_name is db_name and service_names is: db_name.db_domain if the values of service_names and instance_name are not explicitly set, dynamic registration only occurs when the database is started after the listening is run. In this case, dynamic registration information will be lost if the listener is restarted later.
Static listening: static registration refers to reading the configuration of the listener. ora file when the instance is started, and registering 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. Under www.2cto.com is the configured listener. ora
After the configuration is complete, reload in the listener management to ps: view the database sid can be: SELECT * from v $ INSTANCE; this can be configured in tnsnames. ora: