How to Register Pluggable Database(PDB) with new created LISTENER

Connect to an idle instance and startup the instance

[oracle@ol8-19 ~]$ sqlplus / as sysdba

SQL> startup;

change container to that pluggable database

SQL> alter session set container=pdb;
Session altered.

and open it

SQL> alter pluggable database pdb open;

Now, you set local_listener

SQL> alter system set local_listener="(address=(protocol=tcp)(host=ol8-19.localdomain)
(port=1522))" scope=spfile;

System altered.

and issue the following command in order to register the service immediately

SQL> alter system register;

System altered.

and restart pluggable database

SQL> alter pluggable database pdb close immediate;

SQL> alter pluggable database pdb open;

SQL> exit;

then start listener

[oracle@ol8-19 ~]$ lsnrctl start

and recheck listener’s current status

[oracle@ol8-19 ~]$ lsnrctl status

which should start within a half minute.

Leave a Comment