I have faced strange problem when applying July 2019 CPU patch in Oracle 12cR2 (220.127.116.11) database !
So I wanted to share it in my blog in case somebody faced a similar issue.
Java component is not valid
select * from dba_registry;
when you execute utlrp for recompilation
The following error is displayed:
### validate_javavm caught -29548
In the alert log file…the following error is thrown:
joxcsys: release mismatch, 18.104.22.168.190416 1.8 in database (classes.bin) vs 22.214.171.124.190716 1.8 in executable pid 28179 cid 0
SQL> select dbms_java.longname(‘TEST’) from dual;
select dbms_java.longname(‘TEST’) from dual
ERROR at line 1:
ORA-29548: Java system class reported: joxcsys: release mismatch,
126.96.36.199.190416 1.8 in database (classes.bin) vs 188.8.131.52.190716 1.8 in Executable
the first way: shutdown the database and listener and perform relinking
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk javavm_refresh ioracle
The second way:
Roll-back the OJVM patch and re-apply the patch again:
SQL> shutdown immediate;
lsnrctl stop listener_db11
$ORACLE_HOME/OPatch/opatch rollback -id 29774415
SQL> startup upgrade;
After roll-back is successful….apply the patch again and execute utlrp.sql to ensure JAVA component is now valid !
I hope this blog post helps !