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:
Regards,
