We are trying to setup the Autosys database for HA, Oracle Failover Configuration, with NONE Oracle RAC impliemntation.

Products

• Autosys Workload Automation

Issue/Introduction

We have an effort to auto-failover Oracle connections during an outage. We are attempting to use the following in the tnsname.ora file but it is failing.
Does autosys know how to use this extend connection string?

<SID/SERVICENAME> =
 (DESCRIPTION=(FAILOVER_RESTORE=AUTO)(REPLAY_INITIATION_TIMEOUT=3)(CONNECT_TIMEOUT=300)
     (RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)
     (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME1>.<DOMAIN>.com)(PORT=1530))(LOAD_BALANCE=YES)
     (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<HOSTNAME2>.<DOMAIN>.com)
  (FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))

Environment

Autosys 12.x

Cause

This is not currently supporyted.

Resolution

No, there is not currently a version of Autosys that know how to use that configuration.
Currently we support Oracle using RAC where the fail-over is handled on the back end and the connection string does not change.
Or Dual event server mode where there are two connection strings setup and the application will fail-over between the two connections if the primary one goes down.