How to fix EBS 12.1.3 post clone EBS URL not working :
Error:
500 Internal Server Error Servlet error:
An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.
Issue: Post EBS 12.1.3 clone, adopmnctl.sh started successfully but unable to access EBS URL , showing above ERROR
Fix:
When i checked logfiles found below error:
cd $INST_TOP/logs/ora/10.1.3/opmn/oacore_default_group_1/
ls -tlr
oacorestd.err
oacorestd.out
Error details from above log files:
25/06/04 09:44:22 at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
25/06/04 09:44:22 ... 32 more
25/06/04 09:44:22 Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: The account is locked.
25/06/04 09:44:22 at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:856)
25/06/04 09:44:22 at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)
25/06/04 09:44:22 Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: The account is locked.
Step 1: Check APPLSYSPUB account locked
select username,account_status from dba_users where account_status like '%LOCK%'
If its locked then unlock it using below SQL
SQL> alter user APPLSYSPUB account unlock;
User altered.
SQL
Step 2: Check .dbc file for GUEST and APPLSYSPUB account passwords
In my case i found wrong passwords in .dbc file so APPLSYSPUB account got locked. Now i need to change my .dbc file to reflect correct passwords.
cd $FND_SECURE
cat PRODEBS.dbc --> it contains below entries with wrong passwords
GUEST_USER_PWD=GUEST/<worng password>
GWYUID=APPLSYSPUB/<wrong passwrod>
Working .dbc file entries for passwords should look like below
GUEST_USER_PWD=GUEST/ORACLE
GWYUID=APPLSYSPUB/PUB
Step 3: Login in one of the application server with applmgr user and check/update below context vlaues:
grep -i s_gwyuid_pass $CONTEXT_FILE
oa_var="s_gwyuid_pass">PUB</password> ->should look like this
grep -i s_guest_user $CONTEXT_FILE
oa_var="s_guest_user">GUEST</username> ->should look like this
Step 4: Run autoconfig , check .dbc file should show correct values and restart opmn services fixed the issue.
on application server with applmgr user:
below entries should look like this
GUEST_USER_PWD=GUEST/ORACLE
GWYUID=APPLSYSPUB/PUB
cd $ADMIN_SCRIPTS_HOME
sh adopmnctl.sh startall
Check now and you should be able to access EBS URL.
Happy troubleshoot, comment if you still need any help .
0 Comments