PDB is in READ WRITE, but it stays in RESTRICTED mode.

Issue: PDB is in Restricted mode.

Today we have upgraded 11g datbase to 12c and plugged in container.

After running noncdb_to_pdb.sql we tried to open PDB,

PDB status Restricted is  YES..


CDB$ROOT@AGIIPRDC> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 RQBIPRDPDB1                            READ WRITE YES

Reason:

Rows with type ERROR and status PENDING from pdb_plug_in_violations

select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time;

CDB$ROOT@AGIIPRDC> set linesize 150

col name for a15

col cause for a15

col message for a50

select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time;CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC>

NAME            CAUSE           TYPE      MESSAGE                                            STATUS

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

RQBIPRDPDB1     Sync Failure    ERROR     Sync PDB failed with ORA-959 during 'CREATE USER C PENDING

                                          ##S24DBA PROFILE C##S24DBA_PROFILE IDENTIFIED BY *

                                           DEFAULT TABLESPACE SYSAUX

                                           TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK containe

                                          r=all'

RQBIPRDPDB1     Sync Failure    ERROR     Sync PDB failed with ORA-959 during 'CREATE USER C PENDING

                                          ##S24RMAN PROFILE C##S24RMAN_PROFILE IDENTIFIED BY

                                           * DEFAULT TABLESPACE SYSAUX

                                           TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK  contain

                                          er = all'

We Created temporary tablespace then RESTRICTED status changed to NO.

CDB$ROOT@AGIIPRDC> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                             READ ONLY  NO

         3 RQBIPRDPDB1                    READ WRITE NO

Fix: Fix any issues based on violations errors returned by pdb_plug_in_violations and restart PDB.