Introduction: – We all know that The Oracle Listener is a process listening for incoming database connections. This process is only needed on the database server side. The listener is controlled via the lsnrctl utility. Configuration is done via the listener.ora file.In this article, we are going to setup listener for PDBS in Multitenant Database.

If you wish to setup listener for a particular PDB in the multi-tenant database, then follow as below.

Create a listener and start it.

Now connect to the PDB for which you are setting up the listener.

Set listener_networks:

use the listener port and the hostname

 

Check the status of the listener:

 

ADD THE BELOW TNS ENTRY:

 

Test the connectivity using tns service:

With help of an article, you can know about Oracle 12c and connect to the database by using the listener. I would like to say thank you for your attention to the article.

About The Author

Leave a Reply