I'm trying to connect to DB using connecion url:
jdbc:oracle:thin:@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=2)(RETRY_COUNT=3)(ADDRESS_LIST=(FAILOVER = on)(ADDRESS = (PROTOCOL = tcp)(HOST = host1.test.net)(PORT = 1521))(ADDRESS = (PROTOCOL = tcp)(HOST = host2.test.net)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = test)))
and receive ORA-01033 error.
Though it works with one available address:
jdbc:oracle:thin:@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=2)(RETRY_COUNT=3)(ADDRESS_LIST=(FAILOVER = on)(ADDRESS = (PROTOCOL = tcp)(HOST = host2.test.net)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = test)))
I expected TNSNAMES style allows to select working host in case one of them is down. But it doesn't work