OID 11g Fails to Respond to LDAP Requests / OID Instances Do Not Failover to Active Cluster Database. Oidmon Log Errors Include: ORA-03135 ORA-03114
(Doc ID 2299835.1)
Last updated on AUGUST 11, 2020
Applies to:
Oracle Internet Directory - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Symptoms
Oracle Internet Directory (OID) 11g 11.1.1.9.0 version.
OID fails to respond to LDAP requests.
Or, in the case of RAC database, when one of the databases on a cluster is down, e.g., for maintenance, OID instances do not failover to active database(s).
<COMPANY> OID oidmon log errors include:
[2017-05-28T05:45:21.122035+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiExecSql: ORA error = 3135 message = ORA-03135: connection lost contact
Process ID: 4122
Session ID: 783 Serial number: 28082
SQL=SELECT attrname, attrval from ds_attrstore where entryid=907
[2017-05-28T05:45:21.122308+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT p.Instance, p.Configset, p.Pid, p.ServerId, p.Flags, p.State, p.Retrycount, NVL(p.failedhost, ' '), NVL(p.instancename, ' '), NVL(p.compname, ' '), NVL(p.comptype, ' ') FROM ods_process_status p WHERE hostname=:hostname ORDER BY p.ServerId, p.Instancename)
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T05:45:21.122395+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed
[2017-05-28T08:10:54.352034+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsldfc_FetchOneLevelObjs] ORA error 3135: ORA-03135: connection lost contact
Process ID: 14629
Session ID: 787 Serial number: 24917
[2017-05-28T08:10:54.359403+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Error in gsldfosFetchOneLevelObjs:5
[2017-05-28T08:10:54.359455+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Missing registry (some one perhaps deleted)
[2017-05-28T08:10:54.359477+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Missing registry entry for <HOSTNAME>.<COMPANY>.com
[2017-05-28T08:10:54.359660+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsldfb_FetchBaseObjs] ORA error 3114: ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.359688+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Error in gsldfbsFetchBaseObjs:5
[2017-05-28T08:10:54.359706+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsggECreateInstance: Configset entry not found;
[2017-05-28T08:10:54.359723+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gslsggECreateInstance]Failed to insert Instance 1 into registry
[2017-05-28T08:10:54.535099+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT attrname, attrval from ds_attrstore where entryid=907 )
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.535168+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgrpFetchReplStatus : gsldudiSetSqlStmt failed
[2017-05-28T08:10:54.535210+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT p.Instance, p.Configset, p.Pid, p.ServerId, p.Flags, p.State, p.Retrycount, NVL(p.failedhost, ' '), NVL(p.instancename, ' '), NVL(p.compname, ' '), NVL(p.comptype, ' ') FROM ods_process_status p WHERE hostname=:hostname ORDER BY p.ServerId, p.Instancename)
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.535239+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed
[2017-05-28T09:19:54.147127+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Warning: Node=<HOSTNAME 2>.<COMPANY>.com is not responding .., last update Time=20170528091412Z
...<etc>...
[2017-05-28T09:30:20.220783+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Node=<HOSTNAME 2>.<COMPANY>.com did not respond for configured 10 times,Failing over ..
[2017-05-28T09:30:20.230572+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgffFailOver : <HOSTNAME 2>.<COMPANY>.com node did not respond for 968 seconds
[2017-05-28T09:31:24.291649+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Warning: Node=<HOSTNAME 2>.<COMPANY>.com is not responding .., last update Time=20170528091348Z
...<etc>...
[2017-05-28T09:53:17.612255+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgffFailOver : <HOSTNAME>.<COMPANY>.com node did not respond for 2412 seconds
[2017-05-28T13:09:21.285573+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Shutting down
Process ID: 4122
Session ID: 783 Serial number: 28082
SQL=SELECT attrname, attrval from ds_attrstore where entryid=907
[2017-05-28T05:45:21.122308+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT p.Instance, p.Configset, p.Pid, p.ServerId, p.Flags, p.State, p.Retrycount, NVL(p.failedhost, ' '), NVL(p.instancename, ' '), NVL(p.compname, ' '), NVL(p.comptype, ' ') FROM ods_process_status p WHERE hostname=:hostname ORDER BY p.ServerId, p.Instancename)
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T05:45:21.122395+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed
[2017-05-28T08:10:54.352034+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsldfc_FetchOneLevelObjs] ORA error 3135: ORA-03135: connection lost contact
Process ID: 14629
Session ID: 787 Serial number: 24917
[2017-05-28T08:10:54.359403+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Error in gsldfosFetchOneLevelObjs:5
[2017-05-28T08:10:54.359455+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Missing registry (some one perhaps deleted)
[2017-05-28T08:10:54.359477+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Missing registry entry for <HOSTNAME>.<COMPANY>.com
[2017-05-28T08:10:54.359660+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gsldfb_FetchBaseObjs] ORA error 3114: ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.359688+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Error in gsldfbsFetchBaseObjs:5
[2017-05-28T08:10:54.359706+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsggECreateInstance: Configset entry not found;
[2017-05-28T08:10:54.359723+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: [gslsggECreateInstance]Failed to insert Instance 1 into registry
[2017-05-28T08:10:54.535099+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT attrname, attrval from ds_attrstore where entryid=907 )
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.535168+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgrpFetchReplStatus : gsldudiSetSqlStmt failed
[2017-05-28T08:10:54.535210+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gsldudiSetSqlStmt: Sql prepare failed (SELECT p.Instance, p.Configset, p.Pid, p.ServerId, p.Flags, p.State, p.Retrycount, NVL(p.failedhost, ' '), NVL(p.instancename, ' '), NVL(p.compname, ' '), NVL(p.comptype, ' ') FROM ods_process_status p WHERE hostname=:hostname ORDER BY p.ServerId, p.Instancename)
ORA error = 3114 message = ORA-03114: not connected to ORACLE
[2017-05-28T08:10:54.535239+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed
[2017-05-28T09:19:54.147127+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Warning: Node=<HOSTNAME 2>.<COMPANY>.com is not responding .., last update Time=20170528091412Z
...<etc>...
[2017-05-28T09:30:20.220783+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Node=<HOSTNAME 2>.<COMPANY>.com did not respond for configured 10 times,Failing over ..
[2017-05-28T09:30:20.230572+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgffFailOver : <HOSTNAME 2>.<COMPANY>.com node did not respond for 968 seconds
[2017-05-28T09:31:24.291649+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Warning: Node=<HOSTNAME 2>.<COMPANY>.com is not responding .., last update Time=20170528091348Z
...<etc>...
[2017-05-28T09:53:17.612255+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: gslsgffFailOver : <HOSTNAME>.<COMPANY>.com node did not respond for 2412 seconds
[2017-05-28T13:09:21.285573+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: <HOSTNAME>] [pid: <PID>] [tid: 0] Guardian: Shutting down
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |