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

After completed cloning of EBS-12.2.4, working on the post clone activities. When tried to change the APPS and SYSADMIN passwords using FNDCPASS utility faced the below issue.

This is the first time I'm facing this issue. I can't understand why this issue has occurred as I didn't face any issues during cloning. Below is the step by step process to overcome this issue.

Create two scripts 'rmcorejvm.sql' & 'corejvminst.sql' and execute them on the DB Tier.

Content of rmcorejvm.sql

connect / as sysdba

set echo on

set serveroutput on

select * from v$instance;

select owner, status, count(*) from all_objects

where object_type like '%JAVA%' group by owner, status;

execute rmjvm.run(false);

shutdown immediate

set echo off

spool off

exit

Content of corejvminst.sql

set serveroutput on

set echo on

startup mount

alter system set "_system_trig_enabled" = false scope=memory;

alter database open;

select owner, status, count(*) from all_objects

where object_type like '%JAVA%' group by owner, status;

create or replace java system

/

shutdown immediate

set echo off

spool off

exit

Now run the scripts in the below mentioned order at DB Tier via sqlplus as sysdba user.

Now mount the database, change the parameter _system_trig_enabled to false and take a bounce on the DB.

Once the DB is started, check the below value and proceed to change the apps/sysadmin passowrds.

This time I could change the passwords without any issues.

****************************நன்றி****************************