You might have faced below error.
SQL> select dbms_java.get_jdk_version() from dual;
select dbms_java.get_jdk_version() from dual
*
ERROR at line 1:
ORA-29548: Java system class reported: release of classes.bin in the database
does not match that of the oracle executable.
Solution:
This error usually comes, if you haven’t completed the post patching activities for JVM patch.
The workaround to solve this issue is to run @?/javavm/install/update_javavm_db.sql
SQL> @?/javavm/install/update_javavm_db.sql SQL> SET FEEDBACK 1 SQL> SET NUMWIDTH 10 SQL> SET LINESIZE 80 SQL> SET TRIMSPOOL ON SQL> SET TAB OFF SQL> SET PAGESIZE 100 SQL> SQL> alter session set "_ORACLE_SCRIPT"=true; Session altered. SQL> SQL> -- If Java is installed, do CJS. SQL> SQL> -- If CJS can deal with the SROs inconsistent with the new JDK, SQL> -- the drop_sros() call here can be removed. SQL> call initjvmaux.drop_sros(); Call completed. SQL> SQL> create or replace java system; 2 / Java created. SQL> SQL> update dependency$ 2 set p_timestamp=(select stime from obj$ where obj#=p_obj#) 3 where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and 4 (select type# from obj$ where obj#=p_obj#)=29 and 5 (select owner# from obj$ where obj#=p_obj#)=0; 0 rows updated. SQL> SQL> commit; Commit complete. SQL> SQL> alter session set "_ORACLE_SCRIPT"=false; Session altered. SQL>
Now check again:
SQL> select dbms_java.get_jdk_version() from dual; DBMS_JAVA.GET_JDK_VERSION() -------------------------------------------------------------------------------- 1.6.0_105 1 row selected
Hi, Similar to this error in FNDCPASS which may helpful here:
FNDCPASS Error
Thanks,
Worked like a charm, thank you!
I faced and after running above script it worked well. Thanks.
really great… its work and help me to resolving the issue also time save.. Thanks….