Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 10g on Windows connection problem - ORA-12505

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

From: <frank.van.bortel_at_gmail.com>
Date: 20 Mar 2006 00:39:53 -0800
Message-ID: <1142843993.427988.65480@z34g2000cwc.googlegroups.com>

naboeger_at_gmail.com schreef:

> 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

It should be in the form:
username/password@ [//] hostname [:port] [/service_name]

system/manager@//192.168.1.7:1521/my_sid would be correct. See:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_04 Received on Mon Mar 20 2006 - 02:39:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US