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)))) ) | |||