Oracle RAC Aware
search cancel

Oracle RAC Aware

book

Article ID: 93111

calendar_today

Updated On:

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 :