打开和关闭 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.