Enable SDP Support for JDBC

1. Create the grid link data sources for the JDBC connectivity on ComputeNode1 and ComputeNode2.

   Refer to Section 7.6 “Configuring Grid Link Data Source for Dept1_Cluster1” of the Oracle® Fusion Middleware Exalogic Enterprise Deployment Guide at: http://docs.oracle.com/cd/E18476_01/doc.220/e18479/optimization.htm#BABHEDI.

   The console automatically generates the complete JDBC URL, as shown in the following example:

   jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.x.x.x)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=myservice)))

2. In the JDBC URL, replace TCP protocol with SDP protocol.

   For example:

   jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=sdp)(HOST=192.x.x.x)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=myservice)))

3. Manually add the system property -Djava.net.preferIPv4Stack=true to the startWebLogic.sh script.

   The script is located in the bin directory of base_domain.

   Use a text editor as follows:

   1. Locate the following line in the startWebLogic.sh script:

      . ${DOMAIN_HOME}/bin/setDomainEnv.sh $*

   2. Add the following property immediately after the preceding entry:

      JAVA_OPTIONS="${JAVA_OPTIONS} -Djava.net.preferIPv4Stack=true -Doracle.net.SDP=true"

   3. Save and close the file.
4. Restart the managed server.
   1. In the administration console, click Environment → Servers. The Summary of Servers page is displayed.
   2. Select a managed server, such as WLS1, by clicking WLS1. The Settings for WLS1 page is displayed.
   3. Click the Control tab. Select WLS1 in the Server Status table. Click Start.