Oracle RAC Aware

Document ID : KB000093111
Last Modified Date : 26/04/2018
Show Technical Document Details
Introduction:
Just moved AutoSys to Oracle RAC.  Now iDash has lost connectivity to AutoSys.  From iDash Admin, I am not sure how to update the Primary Connection for AutoSys.  Made attempt but not successful.  
Question:
Just moved AutoSys to Oracle RAC. Now iDash has lost connectivity to AutoSys. From iDash Admin, I am not sure how to update the Primary Connection for AutoSys. Made attempt but not successful. Thanks!
Answer:
Idash uses the jdbcdriver. Ensure that the URL is correct.
jdbc:oracle:thin:@BHOST:PORT/SERVICE_NAME
For example:
jdbc:oracle:thin:@somemachine.ca.com:1521/orclpdb.ca.com

tnsnames.ora file:
ORCLPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = somemachine.ca.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclpdb.ca.com) )

*Note it is a / after the port not a colon :