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
Last updated on JUNE 30, 2017
Applies to:Oracle Net Services - Version 22.214.171.124.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***
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:<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
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.
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