My Oracle Support Banner

Intermittent Login Failure to SSO/OID Integrated Application After Being Idle/Unused (Overnight) / OID Log Shows Error: ORA-03113: end-of-file on communication channel (Doc ID 742544.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Net Services - Version 9.0.1.0.0 to 10.2.0.1.0 [Release 9.0.1 to 10.2]
Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.

Symptoms

Single Sign-On (SSO) and Oracle Internet Directory (OID) 10g, i.e., 10.1.4.
Metadata Repository (MR) Database (DB) 10.2 in a separate database server.
Each are on a seperate server with firewall in between. 

Experiencing intermittent login problems when application needs to login to OID.

During the day, while users are logged on to the front-end application integrated with SSO and OID, never encounter any issues.

After everyone leaves for the day and the application sits idle / unused for quite a while, such as overnight, then the problem occurs, i.e. whenever users are first trying to login in the morning.

When the problem occurs, the OID log shows the following error:

BEGIN
2008/09/08:16:16:39 * ServerWorker (REG):8
ConnID:1879 * mesgID:5 * OpID:4 * OpName:search
ConnIP:<IP_ADDRESS> ConnDN: orclapplicationcommonname=orasso_ssoserver,cn=sso,cn=products,cn=oraclecontext
INFO :gslfseADoSearch BASE = cn=users, dc=<COMPANY>,dc=com FILTER = (uid=<UID_VALUE>) #REQDATTR = 7 scope =2
16:16:39 * => gsldbBuildFilterList
16:16:39 * [gsldecfsFetchEntries] ORA error 3113: ORA-03113: end-of-file on communication channel
END

As a temporary workaround, able to setup an auto-login process that logs into the application, say, every 5 minutes.  This seems to keep the OID to DB connections alive and prevents the problem from happening.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.