Opening and Closing PDB’s.

Opening and Closing PDB’s.

SQL> select name, open_mode from V$pdbs;

NAME              OPEN_MODE
——————————        ——————
PDB$SEED          READ ONLY
PDB_PURCHASE      READ WRITE
PDB_HR            READ WRITE

3 rows selected.
To Close a particualr PDB

SQL> alter pluggable database PDB_PURCHASE close;

Pluggable database altered.
To Close all PDB except an PDB

SQL> alter pluggable database all except PDB_PURCHASE close;

Pluggable database altered.
SQL> select name, open_mode from V$pdbs;

NAME         OPEN_MODE
——————————   ———-
PDB$SEED     READ ONLY
PDB_PURCHASE MOUNTED
PDB_HR       MOUNTED

3 rows selected.
To Open all PDB except an PDB.

SQL> alter pluggable database all except PDB_PURCHASE open;

Pluggable database altered.

SQL> select name, open_mode from V$pdbs;

NAME         OPEN_MODE
——————————   ———-
PDB$SEED     READ ONLY
PDB_PURCHASE MOUNTED
PDB_HR       READ WRITE

3 rows selected.

To Open one particular PDB.
SQL> alter pluggable database PDB_PURCHASE open;

Pluggable database altered.

SQL> select name, open_mode from V$pdbs;

NAME         OPEN_MODE
——————————   ———-
PDB$SEED     READ ONLY
PDB_PURCHASE READ WRITE
PDB_HR       READ WRITE

3 rows selected.
Close Immediate -> If we use close immediate then transaction in the PDB are rolled back and sessions are disconnected.

Close -> Statement will Hang until all sessions are disconnected.