Changing apps password with FNDCPASS failed with below error.Working...
Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) 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.
Fix
===
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 23 21:13:41 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
INSTANCE_NAME> 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 Java system classes in the
database (12.1.0.2.201020 1.6) does not match that of the oracle executable
(12.1.0.2.220719 1.6)
INSTANCE_NAME> spool javaissue.txt
INSTANCE_NAME> @?/javavm/install/update_javavm_db.sql
INSTANCE_NAME> SET FEEDBACK 1
INSTANCE_NAME> SET NUMWIDTH 10
INSTANCE_NAME> SET LINESIZE 80
INSTANCE_NAME> SET TRIMSPOOL ON
INSTANCE_NAME> SET TAB OFF
INSTANCE_NAME> SET PAGESIZE 100
INSTANCE_NAME>
INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
INSTANCE_NAME>
INSTANCE_NAME> -- If Java is installed, do CJS.
INSTANCE_NAME>
INSTANCE_NAME> -- If CJS can deal with the SROs inconsistent with the new JDK,
INSTANCE_NAME> -- the drop_sros() call here can be removed.
INSTANCE_NAME> call initjvmaux.drop_sros();
Call completed.
INSTANCE_NAME>
INSTANCE_NAME> create or replace java system;
2 /
Java created.
INSTANCE_NAME>
INSTANCE_NAME> 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.
INSTANCE_NAME>
INSTANCE_NAME> commit;
Commit complete.
INSTANCE_NAME>
INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=false;
Session altered.
INSTANCE_NAME>
INSTANCE_NAME> select dbms_java.get_jdk_version() from dual;
DBMS_JAVA.GET_JDK_VERSION()
--------------------------------------------------------------------------------
1.6.0_211
1 row selected.
Thanks.