Listener supports no services database upgrade
Dear Experts,
We have upgraded our noncdb database to 19c cdb with single pdb. UATDB is pdb and uatcdb is CDB. Can you please let us know what might be the reasons that pdb is not registed with cdb listener.
[orauat@erpuatdb2 u02]$ cat 19c.env export ORACLE_HOME=/u02/UAT19CBASE/19chome #export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH export ORACLE_BASE=/u02/UAT19CBASE export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/lib/site_perl/5.28.1 export ORA_NLS10=/u02/UAT19CBASE/19chome/nls/data [orauat@erpuatdb2 u02]$ . ./19c.env [orauat@erpuatdb2 u02]$ lsnrctl status uatcdb LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-JAN-2023 17:42:57 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erpuatdb2-vip.ttd.com)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias uatcdb Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 27-JAN-2023 16:51:04 Uptime 0 days 0 hr. 51 min. 53 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u02/UAT19CBASE/19chome/network/admin/listener.ora Listener Log File /u02/UAT19CBASE/diag/tnslsnr/erpuatdb2/uatcdb/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=********)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=********)(PORT=1522))) The listener supports no services The command completed successfully [orauat@erpuatdb2 u02]$ export ORACLE_SID=uatcdb2 [orauat@erpuatdb2 u02]$ sqlplus "/as sysdba" SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 27 17:43:27 2023 Version 19.17.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release
0