Pluggable database does not exist

Question

I have Been Working with Oracle sql developer almost for a year now, I have many users created including HR. Earlier today I've connected to my pluggable database and things went fine. Now when I write in the CMD:

ALTER SESSION SET CONTAINER = PDBORCL;

It says: ORA-65011: Pluggable database PDBORCL does not exist. But it absolutely exists! Because I've been working with it so many times. Any thoughts are appreciated.

Answer 1

A few possibilities:

1. you or someone unplugged pdborcl
2. you or someone renamed pdborcl
3. you are not connected to the database you think you are

This will show the PDBs you have:

SELECT pdb_name, status
  FROM cdb_pdbs

And since you're in SQL Developer, you can use the CDB interface on the DBA panel to see what you have and make changes.

And finally, I would generally recommend users to connect directly to their PDB in SQL Developer. Have a connection defined for the PDB Listener Service, and connect to that, vs connecting to a Container and switching over in a worksheet via the ALTER SESSION SET CONTAINER command like you are doing.