Med Java

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Oracle 12 Pluggable database ======

===== Auto start a pluggable database when Oracle starts =====

<code>
export ORACLE_HOME=/path/to/db_home
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=GDB_SID - SID of the global database name to connect to the main database - CDB (not pluggable - PDB)

sqlplus / as sysdba
</code>

Next, to open a single PDB:

<code sql>
alter pluggable database PDB_NAME open;
</code>

To open all PDBs:

<code sql>
alter pluggable database all open;
</code>

To keep the PDBs opened after Oracle restart, we need to save their actual opened state:

For just one PDB:

<code sql>
alter pluggable database PDB_NAME save state;
</code>

For more PDBs:

<code sql>
alter pluggable database all except PDB_NAME1, PDB_NAME2 save state;
</code>

For all PDBs:

<code sql>
alter pluggable database all save state;
</code>
  
===== Show all pluggable databases status =====

<code sql>

col NAME for a10
select name, open_mode from v$pdbs;

NAME       OPEN_MODE
---------- ----------
PDB$SEED   READ ONLY
FLPDB      READ WRITE

</code>