Oracle Failover RAC/SCAN configuration recommendation for AutoSys

Products

• Autosys Workload Automation

Issue/Introduction

When using Oracle RAC/SCAN configuration, a simple tnsnames.ora service configuration for Autosys is described here.

Environment

AutoSys Workload Automation

Resolution

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.  

Additional Information

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