When using Oracle RAC/SCAN configuration, a simple tnsnames.ora service configuration for Autosys is described here.
AutoSys Workload Automation
Here is a recommendation from Oracle Support for a failover using SCAN configuration:
PROD_AUTOSYS_SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-ALIAS.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD_AUTOSYS_SERVICE)
(RETRIES=7)
(DELAY=7)
)
)
# Other defaults which do not need to be added unless you want non default values
# (FAILOVER = ON)
# (TYPE = SELECT)
# (METHOD = BASIC)
# (LOAD_BALANCE = ON)
Work with Oracle DBA to ensure that the Oracle service is registered properly on all the nodes first.
Retest failover of the database nodes using below approach:
1) Recreate the Oracle service, ensure it is registered on both nodes first
2) Then stop AutoSys first
3) Start AutoSys next
4) Now retest database node restarts to verify that the failover is working properly and being realized from AutoSys side