首先查看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.