User Tools

Site Tools


database:oracle:pluggable-database

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
database:oracle:pluggable-database [2019/01/09 12:46]
odefta
database:oracle:pluggable-database [2019/01/09 12:48] (current)
odefta
Line 3: Line 3:
 ===== Auto start a pluggable database when Oracle starts ===== ===== 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: 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: 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: To keep the PDBs opened after Oracle restart, we need to save their actual opened state:
Line 21: Line 27:
 For just one PDB: For just one PDB:
  
-  ​alter pluggable database PDB_NAME save state;+<code sql> 
 +alter pluggable database PDB_NAME save state; 
 +</​code>​
  
 For more PDBs: 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: For all PDBs:
  
-  ​alter pluggable database all save state;+<code sql> 
 +alter pluggable database all save state; 
 +</​code>​
   ​   ​
 ===== Show all pluggable databases status ===== ===== Show all pluggable databases status =====
Line 44: Line 56:
  
 </​code>​ </​code>​
- 
- 
- 
database/oracle/pluggable-database.txt · Last modified: 2019/01/09 12:48 by odefta