PDB Open In RESTRICTED Mode after unplugging from Oracle Cloud Database Instance and attaching it to the new Oracle Cloud Instance (Doc ID 2415713.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

The PDB has been unplugged from another CDB (WIndows) and plugged in to this Oracle Cloud instance resulting to RESTRICTED mode when it was opened in the new instance.

There is 1 PENDING item in PDB_PLUG_IN_VIOLATIONS the message that says "APEX mismatch: PDB has installed common APEX. CDB has not installed APEX.

Query results:

select time,name,cause,status,message from PDB_PLUG_IN_VIOLATIONS where STATUS='PENDING';
TIME                                                NAME        CAUSE       STATUS      MESSAGE
--------------------------------------------------------------------------------------------------
01-MAY-18 02.14.37.387299 PM      PDB01         APEX         PENDING     APEX mismatch: PDB has installed common APEX. CDB has not installed APEX.

Check the status of the PDB$SEED and the PDB in questioned via SQLPLUS:

show pdbs; 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED 
---------- ------------------------------ ---------- ---------- 
         2 PDB$SEED                       READ ONLY  NO 
         3 PDB01                             READ WRITE YES 

Changes

 Plugged an existing PDB from another instance to a new one.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.