Tuesday, July 22, 2014

SOA domain creation on Exalogic using Exadata

I had afew lesson learn while doing Oracle SOA Suite 11.1.1.7 platform provisioning on Exalogic using Exadata. These configurations will maximise your performance on your Oracle Engineered Systems investment.

Lesson #1:

Repository Creation Utility (RCU) has a limitation when it comes to Sockets Direct Protocol (SDP). Paul Done wrote a good article on which version of JVM is supports SDP.

The root cause with RCU is that the SDP classes are not in the startup therefore RCU only works with TCP. Therefore it is a recommended best practice to run the RCU step using the TCP during installation, example connection string below.

jdbc:oracle:thin:@(DESCRIPTION_LIST=(DESCRIPTION=(CONNECT_TIMEOUT=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=db-node1-ib)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=db-node2-ib)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=SOASID))))

Once the domain has been created and running, goto each of the JDBC Data Sources and update all connection string to SDP.

jdbc:oracle:thin:@(DESCRIPTION_LIST=(DESCRIPTION=(CONNECT_TIMEOUT=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=SDP)(HOST=db-node1-ib)(PORT=1522))(ADDRESS=(PROTOCOL=SDP)(HOST=db-node2-ib)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=SOASID))))

Lesson #2:

Modify setDomainEnv.sh to add support for SDP, this setting will be enabled for all servers in the current domain.

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

Lesson #3:

Managed Server is recommended to mounted exclusively by each compute node (ie. local volume). This is mention explicitly in the Exalogic Elastic Cloud Enterprise Deployment Guide for Oracle SOA Suite. This is to optimise I/O performance to disk by leveraging on Exalogic solid-state drive (SSD) technology.

However, the trade off is shared storage (NFS), shared storage enables reliability and availability through data replication and DR.

Lesson #4:

Ensures that Enable Exalogic Optimizations is selected under Domain > Configuration > General.

Refers to Oracle Support Note How To Enable Exalogic Optimizations For WebLogic Server Running On Exalogic Machine (Doc ID 1373571.1) for up-to-date details.