Disable the Automatic registration of database in Listener
PMON process is used to do the automatic registration of Database with the Default Listener on default port number 1521.
If you create a new database then it automatically register with the Default Listener. To avoid it we need to disable the Automatic listener registration.
Following are the few methods for the Disable Automatic Registration:
1. Update the Listener.ora file of database with following parameter and reload the listener.
DYNAMIC_REGISTRATION_listener_name=off
Example:
Default Listener name: LISTENER
DYNAMIC_REGISTRATION_LISTENER = off
2. You can define the parameter local_listener at Database level for defining the listener.
Then database will registered with only that database. you need to reboot Database for effects.
local_listener="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1522)))"
OR use tnsnames entry
ORCL=
(description=
(address=(protocol=tcp)(host=hostname)(port=1522)))
local_listener=ORCL
3. Last method, you donot use the default port 1521 for listener, it automatically stop the dynamic registration of databases with listener.
Smart way of Technology 