How to open or close a PDB in Oracle Multitenant

Open or close a pluggable database. Run these from the root container.

Closing a PDB disconnects its sessions and makes it unavailable. Open READ WRITE for normal use.

-- Open read write
ALTER PLUGGABLE DATABASE &&pdb_name OPEN READ WRITE;

-- Open every PDB at once:
-- ALTER PLUGGABLE DATABASE ALL OPEN;

-- Close (immediate):
-- ALTER PLUGGABLE DATABASE &pdb_name CLOSE IMMEDIATE;

-- Verify (read-only)
SELECT name, open_mode FROM v$pdbs WHERE name = UPPER('&pdb_name');