Service registration 19c database
Dear Experts,
We have upgraded database 12c(noncdb) to 19c(cdb with one pluggable database).SUPPDB is pdb and suppcdb is cdb.
I have a general question. Can you please clarify, how the services (suppdb,ebs_suppdb,SUPPDB_ebs_patch) are registered with the cdb listener. Service_names parameter doesn't shows these services.
SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 SUPPDB READ WRITE NO SQL> sho parameter service NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string suppcdb SQL> alter session set container=SUPPDB; Session altered. SQL> sho parameter service NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string suppcdb [orasupp@erpsupportdb 19.3.0]$ lsnrctl status suppcdb LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-JAN-2023 09:28:51 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erpsupportdb.ttd.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias suppcdb Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 13-DEC-2022 17:17:07 Uptime 44 days 16 hr. 11 min. 43 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/SUPPDB/19.3.0/network/admin/listener.ora Listener Log File /u01/SUPPDB/19.3.0/log/diag/tnslsnr/erpsupportdb/suppcdb/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpsupportdb.ttd.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpsupportdb.ttd.com)(PORT=5510))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "28182bc4cf6c4887e053b340d20a8b55" has 1 instance(s). Instance "suppcdb", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "suppcdb", status READY, has 1
0