Oracle error -29548: ORA-29548 Solution (FNDCPASS Error)

Hey DBA-Mates,

Hope you all are doing Great in success life…

Friends, we faced this issue while changing the APPS password in R12.1.3 through FNDCPASS.

We are not sure, have you guys have faced this issue or not but hope this may useful here if anyone face this issue in future. As we have searched in Google or metalink and we hit many pages but didn’t worked for us. After that we decided to share with you all.

Please find the below details as per Real scenario:

$ . ./ora-data.blogspot.com.env

$ echo $TWO_TASK

ORA-DATA

1. Changing APPS password:

$ FNDCPASS apps/<prod_apps_password> 0 Y system/dev0dba SYSTEM APPLSYS <test_apps_password>

Log filename : L2230661.log

Report filename : O2230661.out

2. Changing SYSADMIN password:

$ FNDCPASS apps/<test_apps_pass>  0 Y system/dev0dba USER SYSADMIN <sysadmin_pass>

APP-FND-01564: ORACLE error 1017 in AFPCOA

Cause: AFPCOA failed due to ORA-01017: invalid username/password; logon denied

.

The SQL statement being executed at the time of the error was:  and was executed from the file .

$

Here, above error is not the main error because it clearly says invalid username and password. It means password was not changed.

So, we checked the APPS password change log file and we found the main error below error:

$ cat L2230661.log

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

Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:

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

Current system time is 15-JUL-2018 08:42:51

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

Working...

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

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

Concurrent request completed

Current system time is 15-JUL-2018 08:42:51

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

$

Solution:

For this we have to run below these 2 scripts as SYSDBA:

SQL> @rmcorejvm.sql

SQL> @corejvminst.sql

$ cat 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

$

$ cat 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

$

Hope this may useful and helpful. Please let us know for any suggestions @Contact US

Some more important links:

ADADMIN UTILITIES

OACORE NOT STARTING UP TROUBLESHOOTING TIPS

ORA-12091 WORK-Around and SOLUTION STEPS

Life journey from PHP to ORACLE APPS DBA

Custom Schema in R12.2

Regards,