tnsnames.ora file question in relation to AE - will it pick up changes dynamically

Products

• CA Workload Automation AE

Issue/Introduction

hi.  we have a tnsnames.ora file which is used for AE to connect to the DB.  here's what the file looks like

UNCAE =
    (DESCRIPTION =
                (CONNECT_TIMEOUT=3) (RETRY_COUNT=3)
                (ADDRESS_LIST = (LOAD_BALANCE=off) (FAILOVER=ON)
                        (ADDRESS=(PROTOCOL=tcp)(HOST=host1234)(PORT=1521))
                        (ADDRESS=(PROTOCOL=tcp)(HOST=host5678)(PORT=1545))
                )
                (CONNECT_DATA = (SERVICE_NAME=UNC_PRD_host.com))
        )

 

the first ADDRESS line is our live Prod DB

the second ADDRESS line is our DR DB

the DR DB hostname is changing and we have to update this file to support an upcoming Oracle infrastructure DR test.

ie.  we need to update the second ADDRESS line, following this update, a few days later our Oracle team will be executing an infrastructure DR test.

my question is... when they perform the DR test, and Autosys fails to connect to the first ADDRESS, will it automatically kick over to the second ADDRESS line even if I didn't first recycle Autosys to pick up any changes? 

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

If autosys is configured to use the tnsnames.ora file and autosys encounters an interruption with the database it will request a new connection from the oracle client.  Meaning if you update the tnsnames.ora file, those changes would be picked up during the next restart of the product or if the product needs to re-establish the database connections for any reason.