FNDCPASS 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

 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.

Segmentation fault (core dumped) Autoconfig failing with adgendbc.sh: line 248: 149435 Done & ORA-12154: TNS:could not resolve the connect identifier specified

 Dear Folks,

Recently, we had an issue with the adcfgclone failed with below error on external node.

Creating the DBC file...

ADD call failed with exit code 139

Updating Server Security Authentication

Updating Server Security Authentication failed with exit code 139

RestoringDBC file from backed up location /u01-BUHJI/app/**/BUHJI/inst/apps/BUHJI_servername/appltmp/TXK/BUHJI_Wed_Nov_09_04_32_2022.dbc

adgendbc.sh endd at Wed Nov  9 04:32:27 EST 2022

adgendbc.sh exiting with status 139

ERRORCODE = 139 ERRORCODE_END

.end std out.

/u01-BUHJ/app/****/BUHJI/inst/apps/BUHJI_servername/admin/install/adgendbc.sh: line 248: 149435 Done                    { echo $USERNAME/$PASSWORD$ADMIN_ALIAS; }

     149436 Segmentation fault      (core dumped) | /u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java -classpath "/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/lib/appsborg.zip:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/classes" oracle.apps.fnd.security.AdminAppServer ADD FNDNAM=$USERNAME GWYUID=APPLSYSPUB/PUB "$DBC_CONNECT_ID" TWO_TASK=BUHJI GUEST_USER_PWD=GUEST/ORACLE SECURE_PATH=/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_servername/appl/fnd/12.0.0/secure APPS_JDBC_DRIVER_TYPE=THIN DB_PORT=1522 DB_HOST=narmtjta01.jtafl.com NODE_NAME=servername JDBC\:processEscapes=true JDBC\:oracle.jdbc.maxCachedBufferSize=358400 FND_MAX_JDBC_CONNECTIONS=500 FND_JDBC_STMT_CACHE_SIZE=100 $ALL_PARAMS -nopromptmsg

/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_servername/admin/install/adgendbc.sh: line 248: 149438 Done                    { echo $USERNAME/$PASSWORD$ADMIN_ALIAS; }

     149439 Segmentation fault      (core dumped) | /u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java -classpath "/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/lib/appsborg.zip:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/classes" oracle.apps.fnd.security.AdminAppServer AUTHENTICATION SECURE DBC=/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_ServerName>/appl/fnd/12.0.0/secure/BUHJI.dbc -nopromptmsg

Upon checking, we have identify issue with the JDK version which has been corrupted.

****@kardtbhya04 bin]$ ./java -version

Segmentation fault (core dumped)

Fix

====

Hence we have restored JDK version from second node application tier and run AC. Then it was completed successfull.

Thanks.