How to enable and disable restricted mode of pluggable database in Oracle

Leave a reply

Enable and disable restricted mode of Pluggable database in Oracle

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
     2 PDB$SEED                       READ ONLY  NO
     3 XEPDB1                         READ WRITE N
SQL>
SQL> alter pluggable database xepdb1 open restricted force;
Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
     2 PDB$SEED                       READ ONLY  NO
     3 XEPDB1                         READ WRITE YES

SQL> alter pluggable database xepdb1 close;

Pluggable database altered.

SQL> alter pluggable database xepdb1 open restricted;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED