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 to [Release 9.0.1 to 10.2]
Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.


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:

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

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.


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

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