Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDB is in restrict mode

Amjad KhanJun 26 2019 — edited Jun 26 2019

Hi

I am working on Oracle Database 12c Standard Edition Release 12.1.0.2.0

show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------             ----------       ----------

         2 PDB$SEED                                READ ONLY   YES

         3 PDB_****                                    READ WRITE YES

I just need to know that how to change PDB mode from restrict mode to normal mode. i have run the following SQL command and got the output as follow

select name,cause,type,action from pdb_plug_in_violations where status <> 'RESOLVED';

NAME

------------------------------

CAUSE                                                            TYPE

---------------------------------------------------------------- ---------

ACTION

--------------------------------------------------------------------------------

PDB_*****

SQL patch error                                                  ERROR

Call datapatch to reinstall

PDB_*****

SQL patch error                                                  ERROR

Call datapatch to reinstall

NAME

------------------------------

CAUSE                                                            TYPE

---------------------------------------------------------------- ---------

ACTION

--------------------------------------------------------------------------------

PDB$SEED

SQL patch error                                                  ERROR

Call datapatch to reinstall

PDB$SEED

SQL patch error                                                  ERROR

NAME

------------------------------

CAUSE                                                            TYPE

---------------------------------------------------------------- ---------

ACTION

--------------------------------------------------------------------------------

Call datapatch to reinstall

Any kind of help will be appreciated. Thank you in advance.

Comments
Post Details
Added on Jun 26 2019
1 comment
5,779 views