My Oracle Support Banner

OID 11g - All OID Servers Unavailable If One RAC Node Is Down when Using SCAN Addressing / OID Installation Hangs at the "Create Oracle Internet Directory" Configuration Step (Doc ID 2026647.1)

Last updated on DECEMBER 06, 2021

Applies to:

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

Symptoms

OID server becomes unresponsive if a node of the RAC database is down.
Multiple OID 11gR1 servers installed non-clustered behind load balencer. Servers connected to two-node RAC Database with SCAN configured.
When shutting down one node of the RAC. 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: <HOSTNAME>] [pid: <PID>] [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

 

A similar issue can also be encountered during initial installation/configuration when using a RAC database configured for SCAN addressing, where it hangs at the "Create Oracle Internet Directory" configuration step and the install*.log shows:

[2020-07-23T18:36:45.762-05:00] [as] [NOTIFICATION] [] [oracle.as.config] [tid: <TID>] [ecid: <ECID>] Wallet Created
[2020-07-23T18:36:45.762-05:00] [as] [NOTIFICATION] [] [oracle.as.config] [tid: <TID>] [ecid: <ECID>] Adding configuration entry for OID
[2020-07-23T18:36:45.762-05:00] [as] [NOTIFICATION] [] [oracle.as.config] [tid: <TID>] [ecid: <ECID>] Cmd: <ORACLE_HOME>//bin/oidctl connect=OIDDB server=OIDLDAPD inst=1 flags=port=<NONSSL_PORT> sport=<SSL_PORT> add
[2020-07-23T18:36:45.774-05:00] [as] [NOTIFICATION] [] [oracle.as.config] [tid: <TID>] [ecid: <ECID>] Error Stream: NLS_LANG not set in environment
[2020-07-23T18:36:45.774-05:00] [as] [NOTIFICATION] [] [oracle.as.config] [tid: <TID>] [ecid: <ECID>] Error Stream: Setting NLS_LANG to AMERICAN_AMERICA.AL32UTF8

 

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


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