Re: JDBC Connection problem ORA-12505 SID does not exist

From: brent <brent.ryan_at_gmail.com>
Date: 9 May 2006 09:36:01 -0700
Message-ID: <1147192561.936070.135760@j73g2000cwa.googlegroups.com>

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

    )
  ) Received on Tue May 09 2006 - 11:36:01 CDT