Oracle RAC Aware

Products

• iDash Workload Automation

Issue/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.  

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!

Environment

Release:
Component: AEIDSH

Resolution

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 :