Getting error ORA-29548: Java system class reported: release of classes.bin in the database does not
Hi
We are getting the following error in the Production Standby Database after applying OJVM OCT 2016 patch both in Primary and Standby Oracle Homes (11.2.0.4).
=================================================================================================================================================
[Error] Execution (1: 8): ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable
ORA-06512: at "SYS.DBMS_JAVA", line 139
=================================================================================================================================================
The alert log of the stanndby database shows the following error whenever we attempt to run this select statement using SQLPLUS: "select dbms_java.longname('TEST') from dual;"
"joxcsys: release mismatch 11.2.0.4.160719 in database (classes.bin) vs 11.2.0.4.161018 in executable"
Please note that we have successfully applied the OJVM post install steps in the Primary database and synced it with standby. We do not have any issues in the Primary database. The DBA_REGISTRY in both the databases is showing JAVAVM in VALID status. The DBA_REGISTRY_HISTORY even reflects that the OJVM post install steps were run in both the databases. We even tried to apply the post-install steps multiple times, however it still having the same issue.