Differences

This shows you the differences between two versions of the page.

--- database:oracle:pluggable-database [2019/01/09 12:31] – created odefta
+++ database:oracle:pluggable-database [2019/01/09 12:48] – odefta
@@ Line 3: / Line 3: @@
 ===== Auto start a pluggable database when Oracle starts =====
-  export ORACLE_HOME=/path/to/db_home
+<code>
-  export PATH=$PATH:$ORACLE_HOME/bin
+export ORACLE_HOME=/path/to/db_home
-  export ORACLE_SID=GDB_SID - SID of the global database name to connect to the main database - CDB (not pluggable - PDB)
+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
+sqlplus / as sysdba
+</code>
 Next, to open a single PDB:
-  alter pluggable database PDB_NAME open;
+<code sql>
+alter pluggable database PDB_NAME open;
+</code>
 To open all PDBs:
-  alter pluggable database all open;
+<code sql>
+alter pluggable database all open;
+</code>
 To keep the PDBs opened after Oracle restart, we need to save their actual opened state:
@@ Line 21: / Line 27: @@
 For just one PDB:
-  alter pluggable database PDB_NAME save state;
+<code sql>
+alter pluggable database PDB_NAME save state;
+</code>
 For more PDBs:
-  alter pluggable database all except PDB_NAME1, PDB_NAME2 save state;
+<code sql>
+alter pluggable database all except PDB_NAME1, PDB_NAME2 save state;
+</code>
 For all PDBs:
-  alter pluggable database all save state;
+<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>