SSO Login Fails with 500 Internal Server Error After Upgrade from 10.1.2 to 10.1.4 (Doc ID 879452.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Single Sign-On - Version: 10.1.4.3.0
This problem can occur on any platform.

Symptoms

After upgrading from 10.1.2.0.2 to 10.1.4.3, unable to login to SSO
Gets "500 Internal Server Error" after clicking the login link

ssoServer.log shows the following error

Mon Aug 17 07:42:15 CEST 2009 [ERROR] AJPRequestHandler-ApplicationServerThread-5 Audit log
insertion exception: ORA-06550: line 1, column 7:
PLS-00307: too many declarations of 'ADD_AUDIT_LOG' match this call
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
....
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)

Changes

Upgraded from 10.1.2.0.2 to 10.1.4.3

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