My Oracle Support Banner

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 MAY 21, 2021

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=<VIP_DB_HOSTNAME>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICENAME>)))

To:

OIDDB =
 (DESCRIPTION =
  (LOAD_BALANCE = on)
  (ADDRESS = (PROTOCOL = SDP)(HOST = <VIP_DB_HOSTNAME1>)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = <VIP_DB_HOSTNAME2>)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = <VIP_DB_HOSTNAME3>)(PORT = 1521))
  (ADDRESS = (PROTOCOL = SDP)(HOST = <VIP_DB_HOSTNAME4>)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = <SERVICENAME)
  )
 )


(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?

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.