Portal version 22.214.171.1241 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?
Release : 126.96.36.1991
Component : CA Test Data Manager - TDM Web Portal
You can always review the supported Database connection from here:
Supported Data Sources (broadcom.com)
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.