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 laterInformation 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:
To:
(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 |