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

From: Peter Sylvester <not_me_at_not_here.org>
Date: Tue, 09 May 2006 12:53:20 -0400
Message-ID: <e3qhk6$p5m$1@newslocal.mitre.org>

brent wrote:
> 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)
> )
> )
> )
>

Try removing the SERVICE_NAME from the TNS entries and see if you can still connect via sqlplus. (You might also need to drop the failover stuff). JDBC only uses the SID to connect, while sql*plus can use either. Its possible that the SID is not the same as the service_name. I am going to assume that "host 1" and "host 2" don't have spaces in the name on the real file...

--Peter Received on Tue May 09 2006 - 11:53:20 CDT