Autosys Web Server do not manage connections to more than one DB

Document ID : KB000103905
Last Modified Date : 05/09/2018
Show Technical Document Details
Issue:
We need the webserver to connect to the WDBC database in failover on 3 addresses, but it does not work. 
Environment:

Autosys 11.3.6 Sp5. 
Resolution:
Update the tnsnames.ora as shown in the sample below:

AUTOSYS = 
(DESCRIPTION_LIST= 
(LOAD_BALANCE=off) (FAILOVER=on) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=autorac1)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac2)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac3)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 


WCCDB = 
(DESCRIPTION_LIST= 
(LOAD_BALANCE=off) (FAILOVER=on) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=autorac1)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac2)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac3)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 


WCCREP = 
(DESCRIPTION_LIST= 
(LOAD_BALANCE=off) (FAILOVER=on) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=autorac1)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac2)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
(DESCRIPTION= (ENABLE=broken) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) 
(ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST= autorac3)(PORT=1521))) 
(CONNECT_DATA=(SERVICE_NAME=rac) (FAILOVER_MODE = (TYPE=none)))) 
)