How To Resolve Firewall Between OID 11g and DB Killing Idle Connections, Resulting In Client Time Outs and OID Log Error ORA-03135: connection lost contact? (Doc ID 1549764.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.

Goal

Oracle Internet Directory (OID) 11g, i.e., 11.1.1.5, with underlying RDBMS (RAC) Database (DB) 11g, i.e., 11.2.0.3.

A firewall exists in between OID and DB.  The firewall kills the connections between OID and DB when they are idle for more than 30 minutes.

This causes the OID server to enter in a status in which it is not able to contact the DB anymore so every client requesting LDAP operations times out.

The only way to restore the connections is to restart the OID server.

OID server log file shows:

[2013-04-23T13:15:08+02:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost] [pid: 4476] [tid: 9] [ecid: 004qkKL9wPl2bMXh1tyGOj00015w00000V,0] ServerWorker (REG):[[
BEGIN
ConnID:7 mesgID:32 OpID:31  OpName:search ConnIP:::ffff:<IP Address> ConnDN:cn=orcladmin
[gsldfb_FetchBaseObjs] ORA error 3135: ORA-03135: connection lost contact
Process ID: 22115
Session ID: 78 Serial number: 2689

How to get around this problem?

Solution

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