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.

Error:

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;
ERROR:
ORA-65011: Pluggable database PBEE does not exist


Solution:


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.


NOTE:

====

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