SYMPTOMS
E-Business Suite 12.1.3, IAS for Applications Technology
Users unable to login to the application, and when attempting to login the following errors are reported in the log files:
ERROR
-----------------------
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)
STEPS
-----------------------
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
CAUSE
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','0RACLE') FROM dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','0RACLE')
--------------------------------------------------------------------------------
N
SQL> select fnd_message.get from dual;
GET
--------------------------------------------------------------------------------
PASSWORD_INVALID
SOLUTION
To implement the solution, please test the following steps in a development instance where the problem can be reproduced:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
========================================================================
E-Business Suite 12.1.3, IAS for Applications Technology
Users unable to login to the application, and when attempting to login the following errors are reported in the log files:
ERROR
-----------------------
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)
STEPS
-----------------------
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
CAUSE
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','0RACLE') FROM dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','0RACLE')
--------------------------------------------------------------------------------
N
SQL> select fnd_message.get from dual;
GET
--------------------------------------------------------------------------------
PASSWORD_INVALID
SOLUTION
To implement the solution, please test the following steps in a development instance where the problem can be reproduced:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
========================================================================
Hi ,
ReplyDeleteI got this issue while cloning this time, we follow rman duplicate for DB refresh and EBS version is 12.1.3.
DB is on exadata 11.2.0.4.
After doing the DB restore using RMAN duplicate , this is the first time we got this issue.
### Stack trace for uncaught java exception:
java.lang.UnsatisfiedLinkError: sun.net.PortConfig.getLower0
at sun/net/PortConfig.(PortConfig.java:83)
at java/net/SocketPermission$1.run(SocketPermission.java:1235)
at java/net/SocketPermission$1.run(SocketPermission.java:1227)
at java/security/AccessController.doPrivileged(Native Method)
at java/net/SocketPermission.initEphemeralPorts(SocketPermission.java:1226)
at java/net/SocketPermission.(SocketPermission.java:221)
at sun/security/util/SecurityConstants.(SecurityConstants.java:164)
at sun/security/provider/PolicyInfoBootStatics.(PolicyFile.java:2599)
at sun/security/provider/PolicyFile.setBootPolicy(PolicyFile.java:332)
at java/lang/System.initializeSystemClass(System.java:1345)
Assertion failure at eox.c:359
Uncaught exception Root of all Java exceptions: java.lang.UnsatisfiedLinkError sun.net.PortConfig.getLower0
GUEST user password authentication was "N".
After running cat bundle the issue got fixed.
We also created a SR with oracle , but Oracle did not say anything for root cause.
In February we had oracle patching , that time also this issue happened and front end was not coming up. after running catbundle the issue got fixed.
Between that period ( exadata patch) and cloning period nothing have changed in DB binary side, what could have possibly wrecked Java ?
I found this similar kind of issue you got hence posting here.
Thanks & Regards,
Amruta
Good solution
ReplyDelete