How to configure Clarity with Oracle RAC database

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have upgraded to Oracle RAC and unable to connect from Clarity CSA. How do we configure this? 

 

Environment

Release : Any

Resolution

Oracle Database Clustering

Classic PPM  supports using an Oracle cluster to provide higher scalability, redundancy, and failover than is possible with a single Oracle server.

Follow these steps:

1. If necessary, export your existing single-server Oracle database from the single node instance and import it into the cluster.
2. Log in to CSA.
3. Open Home, and click Servers.
4. Click the Properties icon for the server for which you want to edit properties.
5. Select the Database sub tab.
6. Edit the following properties for the database connection: 

• Specify URL

Selected.  

• JDBC Url

Fully qualified Oracle cluster JDBC URL. This URL is a jdbc prefix followed by the full TNS specification.

The JDBC URL must contain the ServiceName parameter referencing a TNS entry on the specified Oracle host with the desired RAC configuration.

For example:

jdbc:clarity:oracle://server:1521;ServiceName=SERVICENAME;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true

Alternative examples:

Embed the RAC servers in the URL itself with the following DataDirect syntax:

jdbc:clarity:oracle://server1:1521;ServiceName=SERVICENAME;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;AlternateServers=(server2:1521;server3:1521);LoadBalancing=true

Oracle RAC servers with SCAN listener:

jdbc:clarity:oracle://oracscan:1521;ServiceName=SERVICENAME;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;AlternateServers=(oracscan:1521);FailoverMode=Select;ConnectionRetryCount=20;ConnectionRetryDelay=15;LoadBalancing=true"

Oracle DataGuard:

jdbc:clarity:oracle://PRIMARY_SERVER:1521;ServiceName=SERVICENAME;AlternateServers=(PHYSICAL_STANDBY_SERVER:1521);ConnectionRetryCount=20;ConnectionRetryDelay=15;;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true

 For more information, see these resources: 

Oracle documentation for RAC and DataGuard setup, SCAN, and services setup.  DataDirect Web site. Search for information about using DataDirect Connect for JDBC with Oracle Real Application Clusters (RAC).

1. Save the changes.
2. To validate the database settings, run a system health report for each server. See Run a Health Report.
3. For the Apache Tomcat application servers, restart all services in Classic PPM System Administration.

Additional Information

This is documented here: Broadcom Documentation: Oracle Database Clustering