Re: JDBC Connection problem ORA-12505 SID does not exist Here's the tnsnames.ora entry.
H8SONTST =
(DESCRIPTION =
(ADDRESS_LIST =
(ENABLE = broken)
(FAILOVER = on)
(LOAD_BALANCE = on)
(ADDRESS = (PROTOCOL = TCP)(HOST = host 1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host 2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = h8sontst)
(SID = h8sontst)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
(RETRIES = 180)
(DELAY = 5)
)
)
) |