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:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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 |