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.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…