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 188.8.131.52.3 [Release 11g]
Information in this document applies to any platform.
OID server becomes unresponsive if one node in RAC is down.
Multiple OID 184.108.40.206.0 servers installed non-clustered behind load balancer. Servers connected to two-node 220.127.116.11 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: daloidap01xu.vtitel.net] [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!