My Oracle Support Banner

OID 11g - All OID Servers Unavailable If One RAC Node Is Down when using SCAN addressing (Doc ID 2026647.1)

Last updated on APRIL 19, 2018

Applies to:

Oracle Internet Directory - Version 11.1.1 to [Release 11g]
Information in this document applies to any platform.


OID server becomes unresponsive if one node in RAC is down.
Multiple OID servers installed non-clustered behind load balancer. Servers connected to two-node RAC with SCAN configured.
QA testers shut down one node of the RAC to test HA failover. Both OID servers became non-responsive until the node was restored.

oidmon.log file sample error message:
[2015-06-22T15:09:39-04:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host:] [pid: 29540] [tid: 0] Guardian: gsl
dudiSetSqlStmt: Sql prepare failed (SELECT attrname, attrval from ds_attrstore where entryid=899 )
  ORA error = 3114 message = ORA-03114: not connected to ORACLE
We followed DocId 1494043.1 and DocId 975457.1 to modify the tnsnames.ora file with the three separate IP addresses of the SCAN name but the result was still not working. Need advice on correctly configuring HA because the documentation has conflicting information.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.