How Oracle Enable PDB Restricted Mode

  • by

We can enable the restricted mode of a PDB either in CDB or PDB.

In CDB

Enabling the restricted mode of a PDB in the root container is the easiest way to do it.

1. Check Current Status

[oracle@test ~]$ sqlplus / as sysdba
...
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO

2. Enable Restricted Mode

Here we use OPEN RESTRICTED FORCE to enable restricted mode.

SQL> alter pluggable database ORCLPDB open restricted force;

Pluggable database altered.

3. Check Current Status Again

SQL> show pdbs

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

As you can see, RESTRICTED is now YES.

In PDB

In a PDB, you can enable its restricted mode as a normal database.

Leave a Reply

Your email address will not be published. Required fields are marked *