HTTP error 500 Internal server e…

最新推荐文章于 2021-07-05 18:20:51 发布

babymouse1212

最新推荐文章于 2021-07-05 18:20:51 发布

阅读量713

点赞数

分类专栏： EBS

本文链接：https://blog.csdn.net/babymouse1212/article/details/71078832

版权

EBS 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

In this Document

Applies to:

Oracle Applications Technology Stack - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Applications Manager - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Affected Database: Oracle Database 11g Release 1 and Oracle Database 11g Release 2

Symptoms

On a cloned E-Business Suite Instance of release 12.0.6 with the Database 11g, the logon is failing with error :
...
HTTP error 500 Internal server error
...

In the 'application.log' following error is found :
...
html: Servlet error
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.<clinit>(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

...

Cause

The root cause for this failure has been identified in the Database Parameter Settings for the Release 11g Database.

The following Parameter is producing the failure :

... sec_case_sensitive_logon = TRUE ...

Following the Note 396009.1 - 'Database Initialization Parameters for Oracle Applications Release 12' you can find following sections :

3.1 Required Parameters (11g Release 1)
4.1 Required Parameters (11g Release 2)

following part is the same for both sections :

... ######### # # Database Password Case Sensitivity # # The default for Oracle E-Business Suite databases is FALSE i.e. passwords are case-insensitive # # Oracle E-Business Suite now supports Oracle Database 11g case-sensitive database passwords # This feature is available on E-Business Suite Rel 12.1.1 or higher # To enable this feature apply patch 12964564 and set SEC_CASE_SENSITIVE_LOGON to TRUE # ########## sec_case_sensitive_logon = FALSE ...

Solution

To get the logon working, please implement following steps :

1. Open a new shell and source the Database 11g Environment.

2. Modify the initialization startup of the Database for following setting :

Change FROM :

sec_case_sensitive_logon = TRUE

TO :

sec_case_sensitive_logon = FALSE

3. Save the modification.

4. Stop the APPS-Tier Services and verify, that they are all down.

5. Stop the Database-Tier Services.

6. Start the Database-Tier Services and the APPS-Tier Services.

7. Test the logon to the E-Business Suite Instance again.

Oracle E-Business Suite now supports Oracle Database 11g case-sensitive database passwords
This feature is available on E-Business Suite Rel 12.1.1 or higher
To enable this feature apply patch 12964564 and set SEC_CASE_SENSITIVE_LOGON to TRUE
Please ensure that the Database-Tier Services and the APPS-Tier Services are stopped and then started after changing the database initialization parameter.

Additional hint :
It is a good idea to verify all the Database 11g Settings, if they are conform with the Note 396009.1.
You can verify the Database Parameters by using the script 'bde_chk_cbo.sql' available via Note 174605.1, as it creates a HTML output, where it already checks against the needed Database Parameters as defined in the Note referenced.

References

NOTE:396009.1 - Database Initialization Parameters for Oracle E-Business Suite Release 12
NOTE:174605.1 - bde_chk_cbo.sql - EBS initialization parameters - Healthcheck