Re: Oracle 10g on Windows connection problem - ORA-12505

naboeger_at_gmail.com wrote:

> This is my problem:
>
> FAIL (Cannot create PoolableConnectionFactory (Listener refused the
> connection with the following error:
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
> The Connection descriptor used by the client was:
> 192.168.1.7:1521:system

10gR1 or 10gR2?
Where did this Connection descriptor originate?

This is a typical TNSNAMES entry:

ORABASE =
   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = perrito)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orabase)
     )

Where, in here, do you see the equivalent to what you posted?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)