hi. we have a tnsnames.ora file which is used for AE to connect to the DB. here's what the file looks like
(ADDRESS_LIST = (LOAD_BALANCE=off) (FAILOVER=ON)
(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?
Release : 12.0
Component : CA Workload Automation AE (AutoSys)
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.