Sunday, June 4, 2023

ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.220719 1.7) does not match that of the oracle executable (12.1.0.2.220719 1.6)

We are getting the below error while changing APPLSYS password using FNDCPASS.

NONPROD [******* ~]$ FNDCPASS apps/****** 0 Y system/**** SYSTEM APPLSYS *******

   FNDCPASS system/***** SYSTEM APPLSYS *****

+----------------------------------------------------------------------------+

Working...

Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.220719 1.7) does not match that of the oracle executable (12.1.0.2.220719 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.

Concurrent request completed

Current system time is 04-JUN-2023 23:54:51

 Fix : ( This should be done in CDB and PDB)

2905337.1

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 databasedoes not match that of the oracle executable.

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.7.0_351





No comments:

Post a Comment