OID 11g Connection to DB ServiceName using SDP Protocol on Exalogic for High Availability Not Taking Effect. Is SDP Protocol Supported for OID Connections to its MR DB? (Doc ID 2007349.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 11g.

Enabling SDP protocol (Sockets Direct Protocol) to ensure high availability (HA) for database (DB) connection on Exalogic using tns alias for the OID environment.

Backed up and updated the tnsnames.ora in $ORACLE_INSTANCE/config/tnsnames.ora as follows:

From the original:

OIDDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mydbhost01-vip)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbhost.mycompany.com)))

To:

OIDDB =
 (DESCRIPTION =
  (LOAD_BALANCE = on)
  (ADDRESS = (PROTOCOL = SDP)(HOST = mydbhost01-vip)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = mydbhost02-vip)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = mydbhost03-vip)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = mydbhost04-vip)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = dbhost.mycompany.com)
  )
 )


(Note: Also configured setDomainEnv.sh located at $FMW_HOME/user_projects/domains/IDMDomain/bin/setDomainEnv.sh to include two java options as below:
  JAVA_OPTIONS="${JAVA_OPTIONS} -Doracle.net.tns_admin=/u01/fmw/11.1.1.7/asinst_1/config -Doracle.net.SDP=true"

As per documentation:
Oracle® Fusion Middleware Exalogic Enterprise Deployment Guide Release EL X2-2 and EL X3-2 E18479-10
Chapter 7 Enabling Exalogic-Specific Enhancements in Oracle WebLogic Server 11g Release 1 (10.3.4)
Section 7.7 Configuring SDP-Enabled JDBC Drivers for Dept1_Cluster1 )


After these changes, WebLogic (WLS) wls_ods1 Managed Server was restarted, and the server process picked up this change, but OID server continues to connect to the DB via TCP protocol, i.e., a "sdpnetstat | grep sdp" command returns no hits.

Is SDP protocol supported for OID connections to its Metadata Repository (MR) DB?

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