Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center