ORA-65011: Pluggable Database (PDB name) Does Not Exist When Doing Alter Session Set Container=pdbname (Doc ID 2656138.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 19.3.0.0.0 version,

ORA-65011: Pluggable database (pdb name) does not exist when doing alter session set container=pdb name


You recently upgraded your 12.1.0.2 database to 19c (this is ebs 12.2 database) The upgrade went successfully and the application services are up and you are able to log in to the application. You can also connect to the PDB from the application server and db server using sqlplus apps/@.

But from cdb as sysdba, connection to pdb as alter session set container=, its giving the ora-65011 error.

SQL> show pdbs

  CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
  2 PDB$SEED READ ONLY NO
  3 ebsdxx READ WRITE NO
SQL> alter session set container=ebsdxx;
ERROR:
ORA-65011: Pluggable database (pdb name) does not exist.

 

ERROR
-----------------------
ora-65011

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.