Oracle EBS登入頁面顯示空白

標籤：imp   was   pwd   lang   report   ini   str   one   空白   

問題描述

　　由於ebs資料庫需要閃回，在其他同事閃回資料庫到之前某一天后，重啟ebs應用，發現ebs用戶端登入顯示空白

以前也出現過類似問題，一般出現此問題，可以嘗試以下操作：

1.重啟應用

2.刪除以下檔案

$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/
執行adautocfg.sh
啟動app

3.重建jsp

關閉應用

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

重啟應用

但嘗試以上操作後都無法解決問題，只好在ORACLE METLINK上搜尋相關案例

查到ID 2036519.1和我相似

登入ebs的apps資料庫

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 not match that of the orac
le executable (12.1.0.2.170117 1.6) has been detected in FND_WEB_SEC.VALIDATE_PA
SSWORD.

從messige可知是由於oracle的補丁和資料庫中的post install的補丁不一致導致的，是由於oracle程式補丁更新了，但沒有post install，想起來所回退時間之後又打了最近季度的PSU補丁，回退後導致資料庫沒有post install

重新post install下psu補丁

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 May 12 21:23:46 2017
Copyright (c) 2012, 2016, 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 will be rolled back:
24315824 (Database PSU 12.1.0.2.161018, Oracle JavaVM Component (OCT2016))
The following patches will be applied:
24917972 (Database PSU 12.1.0.2.170117, Oracle JavaVM Component (JAN2017))
24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117)

 

post install之後重啟資料庫，重新查詢fnd_web_sec.validate_login(‘GUEST‘,‘ORACLE‘)的值

SQL> select fnd_web_sec.validate_password(‘GUEST‘,‘ORACLE‘) from dual;

FND_WEB_SEC.VALIDATE_PASSWORD(‘GUEST‘,‘ORACLE‘)
--------------------------------------------------------------------------------
Y

重啟應用，開啟頁面正常

 

 

以下為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 when attempting to login the following errors are 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 J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
       at com.evermind[Oracle Containers for J2EE 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 J2EE 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 be reproduced at will with the following steps:

1. Restart the system after 2015 PSU patching.

2. Login to E-Business Suite.

CHANGES

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

CAUSE

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

The 2015 PSU patch contains ojvm patches for the database JVM, which is 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 be 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

 

Oracle EBS登入頁面顯示空白