1. In 19c database service_name parameter should be set to container name
Connect to the CDB and run the following commands:
alter System set SERVICE_NAMES='<CDBNAME>' SCOPE=BOTH;
alter system register;
Note :- Need to wait ensuring the ebs_<PDB_NAME> and <PDB_NAME>_ebs_patch running automatically
2. Verify that the PDB database is registered with the listener
Connect to PDB and check value of local_listener parameter. It should be not be set at PDB level and should be same as CDB value.
3. PDB should have at a minimum of these services in 12.1 and 12.2.
select name from v$active_services;
12.2:
ebs_<PDB NAME>
<PDB NAME>
<PDB_NAME>_ebs_patch
4. Listener should be started using CDB environment file
cd $ORACLE_HOME
CDB_HOSTNAME.env
lsnrcrt stop CDBNAME
lsnrctl start CDBNAME
5. Verify status of listner using below mentioned command :
$ lsnrctl status
