My Oracle Support Banner

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

Last updated on APRIL 13, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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