How to Configure Unifier for Connection to an Oracle RAC or Connection to an Oracle Database Using the Service Name

(Doc ID 2216069.1)

Last updated on JANUARY 02, 2018

Applies to:

Primavera Unifier - Version 16.1.0.0 and later
Information in this document applies to any platform.

Goal

This document will outline how to configure Unifier to utilize a service name for connection to a Oracle Real Application Clusters (RAC) (short format or long format)

When connecting to an Oracle RAC the following must be true:

Multiple System IDs (SIDs) combine into a single Service Name for the Oracle database.

The service name must be utilized for connecting to the RAC.

Two methods are available for Java Database Connectivity (JDBC) connections when connecting to an Oracle RAC:

Method 1: Using the JDBC Short Form:

The Single Client Access Name (SCAN) Listener feature of an Oracle RAC can be utilized to provide a single host:port reference into the RAC. 
This will allow a short form JDBC Uniform Resource Locator (URL) to be utilized for connection into the RAC.
For Example: jdbc:oracle:thin:@SCAN_LISTENERHOST:SCAN_LINSTENERPORT/SERVICE_NAME

Method 2: Using the JDBC Long Form:

If a SCAN listener is not available, the JDBC connection string will require a long format for referencing the individual host:ports of the RAC (host:port listeners for each SID), but will still utilize the Service Name.
For example: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=DBHOST1)(PORT=DBHOSTPORT1))(ADDRESS=(PROTOCOL=TCP)(HOST=DBHOST2)(PORT=DBHOSTPORT2)))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))

When using the Unifier Configurator to configure a connection to an Oracle database the following occurs:

A JDBC connection string is utilized to connect to the database

The JDBC connection string defaults to a short form and is coded to, by default, require the database SID for referencing the database. Example: jdbc:oracle:thin:@dbHOST:dbPORT:SID

The JDBC string is written in a file called "datasource.properties" located at "UNIFIER_HOME/apps/ROOT/WEB-INF/classes"

This presents a challenge when connecting to an Oracle RAC because a RAC contains >1 SID, but the Unifier configurator does not:

Provide default ability to configure a long format for the JDBC connection string

Appear to allow service name entry for connecting to an Oracle Database

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms