Oracle Database Listener Configuration

Since Listener is s Program to establish connection with the Database from other applications. Hence to establish a connection it must have a Database Service to Bind

If no Service is binded then it listener will be working but showing no service in the LOG

There are two type of  Service Binding in TCP/IP

1. Dynamic Service Registration Through Database .

2. Static Service Registration Through Listenr.ora .

 

1. Dynamic Service Registration

In this type of Registration,  service name is mapped in database in a way that, we either map listener description in the LOCAL_LISTENER parameter of the database or just add alisas in this parameter.

Here I have just added the alias LOCAL_ORCLP
and its detail string in mentioned in TNSNAME.ORA.

You could also directly mention the string into the LOCAL_LISTENER PARAMETER

Anyway, once this all is setup then we have two options to initiate the service,

    1. execute the command Alter System Register

    2. restart the DB.

Once performed,  then service binding status could be reviewed from the listener 

2. Static Service Registration

In this way, we mention SERVICE details in LISTENER.ORA FILE.

To see the Variable Value for

1. GLOBAL_DBNAME: 

    1. Connect to the main database and execute 

        select * from global_name

    2. connect to the plugable database if you have and then repeat step 1 command to find out its value.

2. SID_NAME : execute select ora_database_name from dual;

ONCE DONE with it , just restart the listener.