Re: Help connecting JDeveloper 3.0 to Oracle8i through JDBC

[Quoted] more thoughts on the subject...

you may want to watch the server and tail out the listener.log file to see what the listener is recieving.
[Quoted] This may give you a clue as to what the connection is asking for.

Steven Finkelman
ideas llc.

Jacob wrote:

> Hi all.
>
> This may be a simple question to most of you, but anyway. I just got
> JDeveloper 3.0 and wanted to connect it to Oracle8i, running on another
> machine on the network. My own NT Workstation have the Oracle8i Client
> installed, and I have set up a Net Service Name for the server at TCP/IP
> address 192.168.1.1, port 1521, called "ORACLE8I.IKASTHS.DK". The Net
> Service Name is tested using Net8 Assistant, and there doesn't seem to be
> any problems here. I have also tested with SQL*Plus, and no problems here
> neither.
>
> I try to establish a connection by right-clicking on "Connections..." in
> JDeveloper, which brings up the Connections dialog. I now want to establish
> a connection to the server with either the JDBC Thin Driver or the OCI8 JDBC
> Driver. But none of them seems to work. Here's what happens:
>
> I choose "Existing TSN Names", and choose the one, that I created
> previously, "ORACLE8I.IKASTHS.DK", which is listed here.
>
> JDBC Thin: When I attempt to test the the connection, I get an error that
> starts with "Connection refused" and a lot of trace information, which
> somewhere says something about "ERRCODE=12505". I looked this error up in
> the documentation, which said something about "TNS:Listener could not
> resolve SID given in connect descriptor". But I don't know what to make of
> this error. As I mentioned before, everything works fine except in
> JDeveloper.
>
> OCI JDBC: Here I get a (maybe) more useful error. "No oci8jdbc (or something
> like that) in java.library.path". But what is "java.library.path", and where
> are the OCI JDBC drivers located? I assume it's all installed together with
> JDeveloper, since I checked an option saying "JDBC Drivers".
> "java.library.path" sounds like a Java classpath, but where do I set it up?
> In CLASSPATH or in some config file??
>
> Any help with any or both of these questions would be greatly appreciated!
>
> Thanks in advance!
>
> Jacob
>
> jacmads_at_hotmail.com
Received on Sat Nov 27 1999 - 09:30:10 CET