Search code examples
oracle-sqldeveloperoracle12c

Pluggable database does not exist

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.

Solution

  • 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.

    enter image description here

    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.