Oracle 11.2.0.3 , EBS R12.1.3
数据库及应用克隆完成后, 登陆EBS 应用首页,发现 500 报错, 检查apache 进程,运行正常,查看Log:
$LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1 下查看application.log , 发现详细的错误信息,
居然是提示密码错误 :
html: Servlet error
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.(Utils.java:674)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)
...
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
反复确认密码输入是没有问题的, 后来查看密码发现是大小写都有, 尝试输入正常大小写的密码,系统正常。 原因是没有严格按照
EBS R12 的数据库参数设置 sec_case_sensitive_logon = FALSE , 而是保持默认 sec_case_sensitive_logon = true .
详细参考: R12: On a cloned target the logon screen reports 'HTTP error 500 Internal server error' (Doc ID 1335176.1)
$LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1 下查看application.log , 发现详细的错误信息,
居然是提示密码错误 :
html: Servlet error
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.(Utils.java:674)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:221)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:287)
...
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
反复确认密码输入是没有问题的, 后来查看密码发现是大小写都有, 尝试输入正常大小写的密码,系统正常。 原因是没有严格按照
EBS R12 的数据库参数设置 sec_case_sensitive_logon = FALSE , 而是保持默认 sec_case_sensitive_logon = true .
详细参考: R12: On a cloned target the logon screen reports 'HTTP error 500 Internal server error' (Doc ID 1335176.1)
本文转自ITPUB博客tolywang的博客,原文链接:EBS 克隆,密码大小写敏感导致白屏或报错 HTTP error 500 Internal server error,如需转载请自行联系原博主。