Differences

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

--- dba:oracle:docs:12c_pluggable [2023/01/31 08:23] – removed - external edit (Unknown date) 127.0.0.1
+++ dba:oracle:docs:12c_pluggable [2023/01/31 08:23] (current) – ↷ Page moved from dba:oracle:12c_pluggable to dba:oracle:docs:12c_pluggable dodger
@@ Line 1: / Line 1: @@
+====== [DOC] Working with pluggable databases ======
+====== Mangement ======
+===== Create a pluggable database =====
+<code sql>CREATE PLUGGABLE DATABASE PDB01 ;
+</code>
+===== Startup pluggable database =====
+<code sql>
+ALTER PLUGGABLE DATABASE PDB01 OPEN ;
+</code>
+===== tnsnames.ora =====
+Tnsnames is necessary for connecting to the pluggable databases with cli tools (sql*, expdp...)
+<code bash>
+vim  $ORACLE_HOME/network/admin/tnsnames.ora
+</code>
+<code>
+PDB01 =
+  (DESCRIPTION =
+    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
+    (CONNECT_DATA =
+      (SERVER = DEDICATED)
+      (SERVICE_NAME = PDB01)
+    )
+  )
+</code>
+====== Working with PDB's ======
+===== List of Services (pdbs+cdbs) =====
+<code sql>SELECT NAME, CON_ID FROM V$ACTIVE_SERVICES ;
+</code>
+===== Info about currently connected instance =====
+<code sql>
+SET LINESIZE 200
+SET PAGESIZE 10000
+SET SERVEROUTPUT ON
+COLUMN "DB DETAILS" FORMAT A100\
+SELECT
+ 'DB_NAME: ' ||sys_context('userenv', 'db_name')||
+ ' / CDB?: ' ||(select cdb from v$database)||
+ ' / AUTH_ID: ' ||sys_context('userenv', 'authenticated_identity')||
+ ' / USER: ' ||sys_context('userenv', 'current_user')||
+ ' / CONTAINER: '||nvl(sys_Context('userenv', 'con_Name'), 'NON-CDB')
+ "DB DETAILS"
+ FROM DUAL
+ /
+</code>
+[[http://www.dba-oracle.com/t_pluggable_database.htm|link]]
+===== List PDBS from current container =====
+<code sql>
+COLUMN "RESTRICTED" FORMAT A10
+select
+   v.name,
+   v.open_mode,
+   nvl(v.restricted, 'n/a') "RESTRICTED",
+   d.status
+from
+   v$pdbs     v
+inner join
+   dba_pdbs d
+using (GUID)
+order by v.create_scn;
+</code>
+[[http://www.dba-oracle.com/t_pluggable_database.htm|link]]
+===== Connect from CDB =====
+<code sql>
+ALTER SESSION SET CONTAINER=PDB01 ;
+</code>
+===== With sql* =====
+<code bash>
+sqlplus 'sys/DBA@PDBTEST1 AS SYSDBA'
+</code>
+<code sql>
+SELECT
+     'DB_NAME: '  ||sys_context('userenv', 'db_name')||
+  ' / CDB?: '     ||(select cdb from v$database)||
+  ' / AUTH_ID: '  ||sys_context('userenv', 'authenticated_identity')||
+  ' / USER: '     ||sys_context('userenv', 'current_user')||
+  ' / CONTAINER: '||nvl(sys_Context('userenv', 'con_Name'), 'NON-CDB')
+   "DB DETAILS"
+FROM DUAL
+/
+COLUMN "RESTRICTED" FORMAT A10
+select v.name, v.open_mode, nvl(v.restricted, 'n/a') "RESTRICTED", d.status
+from v$PDBs v inner join dba_pdbs d
+using (GUID)
+order by v.create_scn
+/
+</code>
+<code sql>
+</code>
+<code sql>
+</code>
+====== External doc ======
+  * [[http://www.oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1.php]]