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?