Thursday, December 9, 2021

EBS PDB service name disappear from listener in 19c

 EBS 19c service name issue

Cause: 

1. Misconfiguration with the listener and registration of services:

2. Adop patching cycle will not work.


Solution:-

1. In 19c database service_name parameter should be set to container name   

2. Source CBD ENV.

3. Close PDB instance.

SQL>  alter pluggable database all close instances=all;

Pluggable database altered.

SQL>  alter system set service_names='CDBSID' scope=both sid='*';

System altered.

4.  Stop database.

5. Start database.









No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts