oracle怎么切换到pdb,[ORACLE] ORACLE 193 pdb 创建与pdb/cdba切换

SQL> select pdb_name,status fromcdb_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') ;

Pluggabledatabasecreated.

SQL> select pdb_name,status fromcdb_pdbs ;

PDB_NAME STATUS-------------------------------------------------------------------------------------------------------------------------------- ----------

D3CPDB NORMAL

PDB$SEED NORMAL

D4CPDB NEW

SQL> select con_id,dbid,NAME,OPEN_MODE fromv$pdbs;

CON_ID DBID NAME OPEN_MODE---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------

2 482843019 PDB$SEED READ ONLY

3 50879882 D3CPDB READWRITE4 3947681941D4CPDB MOUNTED

SQL> alter PLUGGABLE database D4CPDB open;

Pluggabledatabasealtered.

SQL> select con_id,dbid,NAME,OPEN_MODE fromv$pdbs;

CON_ID DBID NAME OPEN_MODE---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------

2 482843019 PDB$SEED READ ONLY

3 50879882 D3CPDB READWRITE4 3947681941 D4CPDB READWRITE

SQL> alter PLUGGABLE database D4CPDB close;

Pluggabledatabasealtered.

SQL> select con_id,dbid,NAME,OPEN_MODE fromv$pdbs;

CON_ID DBID NAME OPEN_MODE---------- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------

2 482843019 PDB$SEED READ ONLY

3 50879882 D3CPDB READWRITE4 3947681941 D4CPDB MOUNTED