How to Remove PDB From Restricted Mode

Run “datapatch” might remove PDB from restricted mode

1) Check PDB  status.

SQL> select INST_ID,NAME,OPEN_MODE,RESTRICTED 
     from gv$pdbs order by 1,2;

INST_ID    NAME                           OPEN_MODE  RES
---------- ------------------------------ ---------- ---
 1         RACTESTPDB                     READ WRITE YES
 1         PDB$SEED                       READ ONLY  NO
 2         RACTESTPDB                     READ WRITE YES
 2         PDB$SEED                       READ ONLY  NO

2) Check PDB_PLUG_IN_VIOLATIONS.

SQL> select 
            status, message, action 
     from   
            pdb_plug_in_violations 
     where 
            status !='RESOLVED';

STATUS      MESSAGE                                  ACTION
---------   ----------------------------------------  -------------
PNDING     PSU bundle patch 180116 (DATABASE PATCH   Call datapatch.
            SET UPDATE 12.1.0.2.180116):Installed in 
            the CDB but not in the PDB.
PENDING     ...
            ..
            .

3) Rerun “datapatch” as per “run datapatch”.

4)Bounce all instances and pdbs.

$srvctl stop database -d RACTEST;

$srvctl start database -d RACTEST;

SQL> alter pluggable database RACTESTPDB open instances=all;

Pluggable database altered.

SQL> select INST_ID,NAME,OPEN_MODE,RESTRICTED 
     from gv$pdbs order by 1,2;

INST_ID    NAME                           OPEN_MODE  RES
---------- ------------------------------ ---------- ---
 1         RACTESTPDB                     READ WRITE NO
 1         PDB$SEED                       READ ONLY  NO
 2         RACTESTPDB                     READ WRITE NO
 2         PDB$SEED                       READ ONLY  NO

SQL> alter pluggable database RACTESTPDB save state;

Pluggable database altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.