In my case PDB_NAME = TESTPDB
CDB_NAME=TESTCDB
CDB_NAME=TESTCDB
While starting the listerner file, ebs_TESTDB was missing.
Following the below steps, it got resolved
a. Set the database service_name parameter container name as
$ sqlplus "/as sysdba"
SQL> alter System Set SERVICE_NAMES='TESTCDB' SCOPE=BOTH;
SQL> alter System Register;
SQL> alter System Register;
b. Shutdown application services
adstpall.sh
adstpall.sh
c. Shutdown database listener
lsnrctl stop TESTCDB
lsnrctl stop TESTCDB
d. Start database listener
lsnrctl start TESTCDB
lsnrctl start TESTCDB
e. lsnrctl status TESTCDB
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-AUG-2022 15:35:02
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apdb001.myorg.com)(PORT=1521)))
STATUS of the LISTENER------------------------Alias TESTCDBVersion TNSLSNR for Linux: Version 19.0.0.0.0 - ProductionStart Date 22-AUG-2022 16:55:18Uptime 1 days 22 hr. 39 min. 43 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /d00/oracle/db/tech_st/19c/network/admin/listener.oraListener Log File /d00/oracle/db/tech_st/19c/network/admin/testcdb.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apdb001.myorg.com)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=apdb001.myorg.com)(PORT=5500))(Security=(my_wallet_directory=/d00/oracle/db/tech_st/admin/TESTCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))Services Summary...Service "TESTCDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTCDBXDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTPDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTPDB_ebs_patch" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "ebs_TESTPDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "f469d0a189c77322e04377baa8c0a71f" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...The command completed successfully
f. Check the services in PDB (TESTPDB) as
$ sqlplus "/as sysdba"
SQL> select name from v$active_services;
NAMEebs_TRESTPDBTESTPDBTESTPDB_ebs_patch
No comments:
Post a Comment