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:
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 |