OID lost database connections intermittantly
Somewhere in our code we do a LDAP look-up.
It fails sometimes due to OID dropping the database connections intermittantly.
OID logs in /u01/oid/oid_inst/diagnostics/logs/OID/oid1 says:
ConnID:76 mesgID:2 OpID:1 OpName:search ConnIP:10.244.87.239 ConnDN:cn=policyrwuser,cn=users,dc=us,dc=oracle,dc=com
[gsldecfsFetchEntries] ORA error 3135: ORA-03135: connection lost contact
Process ID: 29973
Session ID: 164 Serial number: 3
Someone suggested to check both CRS ORACLE_HOME and RDBMS ORACLE_HOME have SQLNET.EXPIRE_TIME set and check the TNS and alert logs on the DB side for any other possible connection failure.
I wonder why this happens? and how to make OID connection to the database more robust?
Please help! thanks!