dba:oracle:docs:12c_pluggable
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
dba:oracle:12c_pluggable [2022/02/11 11:12] – ↷ Page moved from oracle:12c_pluggable to dba:oracle:12c_pluggable dodger | dba:oracle:docs:12c_pluggable [2023/01/31 08:23] – removed - external edit (Unknown date) 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== [DOC] Working with pluggable databases ====== | ||
- | |||
- | ====== Mangement ====== | ||
- | ===== Create a pluggable database ===== | ||
- | <code sql> | ||
- | </ | ||
- | |||
- | ===== Startup pluggable database ===== | ||
- | <code sql> | ||
- | ALTER PLUGGABLE DATABASE PDB01 OPEN ; | ||
- | </ | ||
- | |||
- | ===== tnsnames.ora ===== | ||
- | Tnsnames is necessary for connecting to the pluggable databases with cli tools (sql*, expdp...) | ||
- | <code bash> | ||
- | vim $ORACLE_HOME/ | ||
- | </ | ||
- | < | ||
- | PDB01 = | ||
- | (DESCRIPTION = | ||
- | (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) | ||
- | (CONNECT_DATA = | ||
- | (SERVER = DEDICATED) | ||
- | (SERVICE_NAME = PDB01) | ||
- | ) | ||
- | ) | ||
- | </ | ||
- | |||
- | ====== Working with PDB's ====== | ||
- | ===== List of Services (pdbs+cdbs) ===== | ||
- | <code sql> | ||
- | </ | ||
- | |||
- | ===== Info about currently connected instance ===== | ||
- | <code sql> | ||
- | SET LINESIZE 200 | ||
- | SET PAGESIZE 10000 | ||
- | SET SERVEROUTPUT ON | ||
- | COLUMN "DB DETAILS" | ||
- | SELECT | ||
- | ' | ||
- | ' | ||
- | ' | ||
- | ' | ||
- | ' | ||
- | " | ||
- | FROM DUAL | ||
- | / | ||
- | </ | ||
- | [[http:// | ||
- | |||
- | |||
- | |||
- | ===== List PDBS from current container ===== | ||
- | <code sql> | ||
- | COLUMN " | ||
- | select | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | from | ||
- | | ||
- | inner join | ||
- | | ||
- | using (GUID) | ||
- | order by v.create_scn; | ||
- | </ | ||
- | [[http:// | ||
- | |||
- | ===== Connect from CDB ===== | ||
- | <code sql> | ||
- | ALTER SESSION SET CONTAINER=PDB01 ; | ||
- | </ | ||
- | |||
- | ===== With sql* ===== | ||
- | <code bash> | ||
- | sqlplus ' | ||
- | </ | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | <code sql> | ||
- | SELECT | ||
- | ' | ||
- | ' / CDB?: ' | ||
- | ' / AUTH_ID: ' | ||
- | ' / USER: ' | ||
- | ' / CONTAINER: ' | ||
- | " | ||
- | FROM DUAL | ||
- | / | ||
- | |||
- | |||
- | COLUMN " | ||
- | select v.name, v.open_mode, | ||
- | from v$PDBs v inner join dba_pdbs d | ||
- | using (GUID) | ||
- | order by v.create_scn | ||
- | / | ||
- | |||
- | </ | ||
- | <code sql> | ||
- | |||
- | </ | ||
- | <code sql> | ||
- | |||
- | </ | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | ====== External doc ====== | ||
- | * [[http:// | ||
dba/oracle/docs/12c_pluggable.txt · Last modified: 2023/01/31 08:23 by dodger