Posts

Showing posts with the label PDB RESTRICTED

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, s...