mod_plsql apps not Available (Proxy Logon Failed) Ora-604 (Doc ID 305315.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle HTTP Server - Version: 10.1.2.0.2 to 10.1.2.0.2 - Release: AS10gR2 to AS10gR2
Oracle Application Server Single Sign-On - Version: 10.1.2.0.2 to 10.1.2.0.2   [Release: 10gR2 to 10gR2]
Information in this document applies to any platform.

Symptoms

Accessing the a DAD (e.g. /pls/orasso on the Infrastructure to connect to the SSO admin pages) returns Internal Server Error, and the HTTP Server error_log shows:
mod_plsql: /pls/orasso/htp.p HTTP-503 ORA-604 Proxy log On failed. [...]
If PlSqlLogEnabled is set to on "On" the error is more detailed:
mod_plsql: ORA-604: error occurred at reciursive SQL level 1

The value of environment variable $LANG ends in
.UTF-8
The value of environment variable $NLS_LANG does not end in
.UTF8

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms