[ORACLE] ORACLE 193 pdb 创建与pdb/cdba切换

select pdb_name,status from cdb_pdbs ; PDB_NAME STATUS -------------------------------------------------------------------------------------------------------------------------------- ---------- D3CPDB NORMAL PDB$SEED NORMAL SQL> create pluggable database D4CPDB admin user D4CPDB_admin identified by "12345678" roles=(dba) file_name_convert=(‘/oracle/D4C/oradata/D4CDB/pdbseed‘,‘/oracle/D4C/oradata/D4CDB/D4CPDB‘) ; Pluggable database created. SQL> select pdb_name,status from cdb_pdbs ; PDB_NAME STATUS -------------------------------------------------------------------------------------------------------------------------------- ---------- D3CPDB NORMAL PDB$SEED NORMAL D4CPDB NEW SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs; CON_ID DBID NAME OPEN_MODE ---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 482843019 PDB$SEED READ ONLY 3 50879882 D3CPDB READ WRITE 4 3947681941 D4CPDB MOUNTED SQL> alter PLUGGABLE database D4CPDB open; Pluggable database altered. SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs; CON_ID DBID NAME OPEN_MODE ---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 482843019 PDB$SEED READ ONLY 3 50879882 D3CPDB READ WRITE 4 3947681941 D4CPDB READ WRITE SQL> alter PLUGGABLE database D4CPDB close; Pluggable database altered. SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs; CON_ID DBID NAME OPEN_MODE ---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 482843019 PDB$SEED READ ONLY 3 50879882 D3CPDB READ WRITE 4 3947681941 D4CPDB MOUNTED

2.PDB/CDB 切换

#切换PDB
SQL> alter session set container=D3CPDB;

Session altered.

SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

    CON_ID     DBID NAME                                                                   OPEN_MODE
---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------
     3   50879882 D3CPDB                                                                   READ WRITE
SQL> show con_name;

CON_NAME
------------------------------
D3CPDB
#切换PDB#SEED
SQL> alter session set container=PDB$SEED;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
PDB$SEED

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 D3CPDB              READ WRITE NO
     4 D4CPDB              READ WRITE NO
SQL> alter pluggable database all close immediate ; 

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 D3CPDB              MOUNTED
     4 D4CPDB              MOUNTED
     
SQL> alter session set container=D3CPDB;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
D3CPDB
#切换CDB
SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

 

[ORACLE] ORACLE 193 pdb 创建与pdb/cdba切换

标签：src   altered   user   roles   select   admin   str   mod   inf