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.








Comments

Popular posts from this blog

Useful OEM Queries to get Target details from OEM Repository

WARNING: Subscription for node down event still pending' in Listener Log

ORA-65139: Mismatch between XML metadata file and data file