ORA-65011: Pluggable Database Does Not Exist in Oracle EBS Database after 19c upgrade

After upgrading EBS database to 19c see we can see issue when setting the Pluggable database session.


SQL> show pdbs

   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        2 PDB$SEED                       READ ONLY  NO
        3 PBEE                       READ WRITE NO
SQL> alter session set container=PBEE;
ORA-65011: Pluggable database PBEE does not exist


This is due to _pdb_name_case_sensitive set to true

SQL> show parameter case

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_pdb_name_case_sensitive             boolean     TRUE
sec_case_sensitive_logon             boolean     FALSE

Set session like below

SQL> alter session set container="PBEE";
Session altered.



When this parameter is set to TRUE during the PDB creation, then do NOT manually change it back to FALSE.

If you like please follow and comment