OID 11g Instances Do Not Failoverto Active Cluster Database. Oidmon Log Error Include: ORA-03135 ORA-03114 (Doc ID 2299835.1)

Last updated on AUGUST 22, 2017

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 11g 11.1.1.9.0 version.

When one of the databases on the cluster is down, e.g., for maintenance, OID instances do not failover to active database(s).

Example OID oidmon log errors include:

[2017-05-28T05:45:21.122035+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed

[2017-05-28T08:10:54.352034+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [tid: 0] Guardian: Error in gsldfosFetchOneLevelObjs:5

[2017-05-28T08:10:54.359455+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Missing registry (some one perhaps deleted)

[2017-05-28T08:10:54.359477+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Missing registry entry for oidhost1.example.com

[2017-05-28T08:10:54.359660+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [tid: 0] Guardian: Error in gsldfbsFetchBaseObjs:5

[2017-05-28T08:10:54.359706+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsggECreateInstance: Configset entry  not found;

[2017-05-28T08:10:54.359723+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: [gslsggECreateInstance]Failed to insert Instance 1 into registry

[2017-05-28T08:10:54.535099+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsgrpFetchReplStatus : gsldudiSetSqlStmt failed

[2017-05-28T08:10:54.535210+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [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: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsgpBFetPtab : gsldudiSetSqlStmt failed

[2017-05-28T09:19:54.147127+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Warning: Node=oidhost2.example.com is not responding .., last update Time=20170528091412Z

...<etc>...

[2017-05-28T09:30:20.220783+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Node=oidhost2.example.com did not respond for configured 10 times,Failing over ..

[2017-05-28T09:30:20.230572+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsgffFailOver : oidhost2.example.com node did not respond for 968 seconds

[2017-05-28T09:31:24.291649+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Warning: Node=oidhost2.example.com is not responding .., last update Time=20170528091348Z

...<etc>...

[2017-05-28T09:53:17.612255+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: gslsgffFailOver : oidhost1.example.com node did not respond for 2412 seconds

[2017-05-28T13:09:21.285573+00:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: oidhost1] [pid: 13076] [tid: 0] Guardian: Shutting down

 

 

Changes

 

Cause

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