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, you are not sure how to update the Primary Connection for AutoSys.  Made attempt but not successful.  

Resolution

iDash uses the jdbcdriver. Ensure that the URL is correct.

jdbc:oracle:thin:@BHOST:PORT/SERVICE_NAME

For example:
jdbc:oracle:thin:@somemachine.example.com:1521/orclpdb.example.com

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

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