Thursday, 8 September 2022

ebs_ service name was missing in listener file

 In my case PDB_NAME = TESTPDB
                   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;

  b. Shutdown application services 
         adstpall.sh

  c. Shutdown database listener
         lsnrctl stop TESTCDB

  d. Start database listener
         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                     TESTCDB
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                22-AUG-2022 16:55:18
Uptime                    1 days 22 hr. 39 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /d00/oracle/db/tech_st/19c/network/admin/listener.ora
Listener Log File         /d00/oracle/db/tech_st/19c/network/admin/testcdb.log
Listening 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;
         NAME
         ebs_TRESTPDB
  TESTPDB
  TESTPDB_ebs_patch


No comments:

Post a Comment