Oracle12C 打开和关闭 Oralce PDB数据库

首先查看PDB状态：

SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;

CON_ID	DBID	GUID	NAME	OPEN_MODE
2	575763998	8CC72EFAB17644E8983784B926983D6D	PDB$SEED	READ ONLY
3	901696483	9A76A11CB8A84895BD3398E0264E5B00	PDBORCL	MOUNTED

PDBORCL 的状态为MOUNTED
打开PDBORCL

SQL> alter pluggable database PDBORCL open;

关闭PDB为：

SQL> alter pluggable database PDBORCL close;                               

CON_ID	DBID	GUID	NAME	OPEN_MODE
3	901696483	9A76A11CB8A84895BD3398E0264E5B00	PDBORCL	READ WRITE

PDBORCL 的状态为READ WRITE 表示可读写 PDB已经打开

当然也可以用以下方式打开：

SQL> alter session set container=PDBORCL;
Session altered.
SQL> startup;
Pluggable Database opened.