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 JUNE 30, 2017

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.
***Checked for relevance on 17-Sep-2014***


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:<MASKED> ConnDN: orclapplicationcommonname=orasso_ssoserver,cn=sso,cn=products,cn=oraclecontext
INFO :gslfseADoSearch BASE = cn=users, dc=mycompany,dc=com FILTER = (uid=<MASKED>) #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

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