The Oracle EBS login page appears blank

Problem description

Because the EBS database needs to be flashed back, restart the EBS app after another colleague has flashed back to the database, and found that the EBS client login appears blank

There have been similar problems in the past, and this problem generally occurs, and you can try the following:

1. Restart the app

2. Delete the following files

$INST _top/ora/10.1.3/j2ee/forms/persistence/
$INST _top/ora/10.1.3/j2ee/oafm/persistence/
$INST _top/ora/10.1.3/j2ee/oacore/persistence/
Executive adautocfg.sh
Launch app

3. Rebuilding the JSP

Close the app

$perl $FND _top/patch/115/bin/ojspcompile.pl–compile–flush-p 2

Restart your app

However, after trying the above operation can not solve the problem, we have to search for relevant cases on Oracle Metlink

ID 2036519.1 looks like me.

Login to EBS's apps database

sql> SELECT fnd_web_sec.validate_login (' GUEST ', ' ORACLE ') from dual;

Fnd_web_sec. Validate_login (' GUEST ', ' ORACLE ')
--------------------------------------------------------------------------------
N

Sql> select Fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Oracle Error-29548:ora-29548:java System class reported:release of Java Syst
EM classes in the database (12.1.0.2.161018 1.6) does don't match that of the ORAC
Le executable (12.1.0.2.170117 1.6) had been detected in Fnd_web_sec. Validate_pa
ssWOrd.

From Messige it is because the Oracle patch and the database of the Post install patch inconsistency caused by the Oracle program patch update, but there is no post install, recall the return time after the last quarter of the PSU patch, Back up causes the database to have no post install

Re-post install under PSU patch

Sql>sqlplus/as SYSDBA

Sql>shutdown Immediate

Sql>startup Upgrade

$CD $ORACLE _home/opatch/

$./datapatch

SQL Patching tool version 12.1.0.2.0 Production on Fri 12 21:23:46 2017
Copyright (c), Oracle. All rights reserved.

Connecting to Database ... Ok
Bootstrapping registry and package to current Versions...done
Determining Current State...done
Adding patches to installation queue and performing prereq Checks...done
Installation queue:
The following patches'll be rolled back:
24315824 (Database PSU 12.1.0.2.161018, Oracle javavm Component (OCT2016))
The following patches would be applied:
24917972 (Database PSU 12.1.0.2.170117, Oracle javavm Component (JAN2017))
24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117)

Restart the database after post install and query the value of Fnd_web_sec.validate_login (' GUEST ', ' ORACLE ') again

Sql> Select Fnd_web_sec.validate_password (' GUEST ', ' ORACLE ') from dual;

Fnd_web_sec. Validate_password (' GUEST ', ' ORACLE ')
--------------------------------------------------------------------------------
Y

Restart the app to open the page normally

The following is a description on Oracle Metlink

Applies To:

Oracle Applications Technology Stack-version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

E-business Suite 12.1.3 Applications Technology Stack, IAS for Applications technology issues

Users Unable to login to the application, and if attempting to login the following errors is reported in the log files:

15/07/20 14:13:32.570 Html:chain failed
Javax.servlet.ServletException:java.lang.RuntimeException:Guest User/pwd does not exist or match:guest/oracle
At Com.evermind[oracle Containers for Java EE 10g (10.1.3.5.0)].server.http.evermindpagecontext.handlepagethrowable ( evermindpagecontext.java:899)
At Com.evermind[oracle Containers for Java EE 10g (10.1.3.5.0)].server.http.evermindpagecontext.handlepageexception ( evermindpagecontext.java:816)
At _appslocallogin._jspservice (_appslocallogin.java:307)
At Com.orionserver[oracle Containers for Java EE 10g (10.1.3.5.0)].http. Orionhttpjsppage.service (orionhttpjsppage.java:59)
At Oracle.jsp.runtimev2.JspPageTable.service (jsppagetable.java:473)
At Oracle.jsp.runtimev2.JspServlet.internalService (jspservlet.java:594)


The issue can reproduced at'll with the following steps:

1. Restart the system after patching PSU.

2. Login to E-business Suite.

Changes

The PSU patching was performed and/or other system updates were completed.

Cause

April PSU was applied on the GKFX RDBMS Oracle_home, but the RDBMS post install steps were not completed (Per Note 1933286.1#aref_section213).

The. PSU patch contains OJVM patches for the database JVM, which are also used by E-business suite for authentication. To confirm the issue test GUEST password validation via the following SQL:

sql> SELECT fnd_web_sec.validate_login (' GUEST ', ' ORACLE ') from dual;

Fnd_web_sec. Validate_login (' GUEST ', ' ORACLE ')
--------------------------------------------------------------------------------
N

Sql> select Fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Password_invalid

Solution

To implement the solution test the following steps in a development instance where the problem can is reproduced and then Migrate accordingly:

CD $ORACLE _home/rdbms/admin
Sqlplus/nolog
Sql> Connect/as SYSDBA
Sql> STARTUP
sql> @catbundle. SQL PSU Apply
Sql> QUIT

The Oracle EBS login page appears blank