TDM: Oracle RAC Connection from Portal as source/target

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Portal version 4.9.1.311 Oracle 12.

I don't think this is a product issue because I am getting the Oracle Error that indicates connection not getting to the Listener of the Oracle server. What I wanted to know is do I need any special JDBC Jar or Oracle connection parameters for RAC Server?

Environment

Release : 4.9.1.311

Component : CA Test Data Manager - TDM Web Portal

Cause

N/A

Resolution

 

You can always review the supported Database connection from here:
Supported Data Sources (broadcom.com)

We do support oracle 12C RAC:

by Default when making a connection to a RAC server from JDBC you should not need any additional; Connection properties.

You will need to confirm with your Oracle DBA that this particular instance does not need any extra parameters to make a connection.

I would start with simple tests from the TDM Portal server such as using telnet to the server name and port to see if you can make a connection.

If that works, install an oracle client on the TDM portal and test with things such as tnsping and sqlplus to make a connection.

Below is an example of JDBC connection strings.
Connecting to Oracle Database 12c Release 1 (12.1)

In this case, it ended up being a IP/Ports and firewall issue.