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 revisionPrevious revision
Next revision
Previous revision
database:oracle:pluggable-database [2019/01/09 12:46] odeftadatabase:oracle:pluggable-database [2023/07/04 19:36] (current) – external edit 127.0.0.1
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.1547030817.txt.gz · Last modified: 2023/07/04 19:36 (external edit)