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