Davis Apps DBA: APPS Login page is not coming

One fine morning after the backup has finished in Production environment, thought to have a health checkup. DB was fine. When tried to login to APPS the login page is throwing the below issue,

Apps Login Issue with Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

Quick search on google yields some hits on my issue.

Solution 1:

The root cause of the issue is with GUEST User and Password not in sync.

Running the below query, confirmed that GUEST user and password was not in sync

select fnd_web_sec.validate_password('GUEST','ORACLE') from dual;

FND_WEB_SEC.VALIDATE_PASSWORD('GUEST','ORACLE')
--------------------------------------------------------------------------------
N

Also, confirmed with the below error on the oacore log

javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

Fix:

1. Shutdown the EBS services.

2. The only supported way to change the Guest user password is to update the context variable s_guest_pass and run AutoConfig, which runs the AdminAppServer utility internally.

3. Run autoconfig on DB Node and then application node.

4. Execute the below sql again:

select fnd_web_sec.validate_password('GUEST','ORACLE') from dual;

Check whether query output is showing Y.

If no, Please check whether the below error is seen on autoconfig log:

Unable to update GUEST_USER_PWD in database to GUEST/ORACLE - Password was not changed, this point to the DB parameter JAVA_JIT_ENABLED which is set as TRUE.

5. On 11g DB you need to have the below settings for EBS specifically, run the below sql

alter system set JAVA_JIT_ENABLED= FALSE scope = both;

6. Follow the steps 2 and 3 again.

7. Run the below command:

perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2

8. Check whether the compile completed successfully.

9. Restart the application services.

Ref : Doc ID 1673030.1

Solution 2:

SQL> select fnd_web_sec.validate_login('GUEST','oracle') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N

SQL>
SQL>
SQL> select fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Oracle error -4031: ORA-04031: unable to allocate 4096 bytes of shared memory ("
java pool","unknown object","joxs heap",":Intern") has been detected in FND_WEB_
SEC.VALIDATE_LOGIN(u,p).

here the problem is clear.

Then I checked.

SQL> show parameter java

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

java_jit_enabled boolean TRUE

java_max_sessionspace_size integer 0

java_pool_size big integer 0

java_soft_sessionspace_limit integer 0

SQL>

Solution:

Increase the java_pool_size=128M

SQL> alter system set java_pool_size =128M scope=both;

System altered.

Now bounce both DB and APPS. This time login page appears. This should fix the Issue.

Solution 3:

The same issue happened again, but this time the reason for the issue is different. No need to bother about the Guest password even though the issue stated so.

Issue: