Establishing Oracle RAC Connectivity

An Oracle database with the Oracle Real Application Clusters (RAC) option allows multiple instances running on different servers to access the same physical database stored on shared storage.

As part of the design-time setup in CIC Studio, follow the normal steps to define your Data Source object. In addition to normal configuration steps (define classpath, driver, user credentials, etc), you must also:

• Obtain necessary metadata for Schema creation.
• Reformat the JDBC URL for the RAC connection.

Obtain metadata for Schema creation

As part of the initial connection, you must first retrieve metadata from the database tables (in order to create appropriate schema definitions). To do so, populate the URL field of the Data Source editor with the following URL, formatted as shown below. 

jdbc:remote://${GROUND_AGENT_NAME}:jdbc:oracle:thin:@${ORACLE_NODE_HOST}:${ORACLE_NODE_PORT}/${DATABASE_NAME}

Where:

Here the example is shown in the Data Source editor:

Once this is done, you can click the Fetch Metadata button to retrieve the metadata.

At this point, the design-side part of the process is complete. The next step relates to how the Data Source will actually connect to your Oracle database at runtime.

Reformat the JDBC URL for RAC Connection

In the same URL field, reformat the URL for your remote Oracle JDBC URL as follows:

jdbc:oracleremote:${IP_MASK_REGEX_PATTERN}://${GROUND_AGENT_NAME};jdbc:oracle
:thin:@${ORACLE_SCAN_SERVER_HOST}:${ORACLE_SCAN_SERVER_PORT}/${DATABA
SE_NAME}

Where:

Here the example is shown in the Data Source editor:

Use this reformatted JDBC URL to establish a connection to your Oracle database.