Disable the Automatic registration of database in Listener

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.