Go to main content

Oracle® SuperCluster M8 and SuperCluster M7 Administration Guide

Exit Print View

Updated: June 2020
 
 

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. For 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.
    2. Select a managed server, such as WLS1, by clicking WLS1.
    3. Click the Control tab. Select WLS1 in the Server Status table. Click Start.

Related Information