OracleMultitenant

Open PDBs and keep them open after restart

Opens every PDB, then saves the state so they reopen automatically when the CDB restarts. The first query shows what's currently saved.

Changes data12c+Run on CDB root

This script changes the database. Check the names and values before you run it.

ora-pdb-open.sql

1SELECT con_name, instance_name, state2FROM dba_pdb_saved_states;3 4ALTER PLUGGABLE DATABASE ALL OPEN;5ALTER PLUGGABLE DATABASE ALL SAVE STATE;

Save it as ora-pdb-open.sql and run it with SQL> @ora-pdb-open.

More Oracle scripts: Multitenant

Pluggable databases and their stateEvery PDB with its open mode, whether it's restricted, when it opened and its size. RESTRICTED = YES usually means a plug-in violation.
Tablespace usage across all PDBsThe tablespace report for every container at once, fullest first, so you don't have to switch into each PDB.
Unresolved plug-in violationsWhy a PDB opened in restricted mode: patch mismatches, parameter conflicts and missing options, with Oracle's suggested fix in the message.