Skip to Main Content

Database Software

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 opening in RESTRICTED mode

After installing July 2025 CPU patch 37847857 (OJVM) for Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.28.0.0.0 on Linux server one of pdbs was opening in RESTRICTED mode.

I followed instructions in the Document 3097851.1 (19.28 OJVMRU Datapatch Execution Failing With ORA-29532 Error During Drop java Command While Opening File javax/servlet (Doc ID 3097851.1)):

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=58635485002367&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=3097851.1&_afrWindowMode=0&_adf.ctrl-state=9ke1ng0j1_102

to fix the issue.

Now patch is installed successfully with no records in the PDB_PLUG_IN_VIOLATIONS:

SQL>SELECT STATUS, MESSAGE, ACTION FROM PDB_PLUG_IN_VIOLATIONS;

no rows selected

But one pdb is still opening in RESTRICTED mode:

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

    2 PDB$SEED                      READ ONLY  NO

    3 TESTPDB                       READ WRITE NO

    4 EMPPDB                         READ WRITE YES

How to fix the issue?

Comments
Post Details
Added on Sep 16 2025
2 comments
53 views