The Network Adapter could not establish the connection

Thread view:

kaeli - 24 Feb 2004 16:00 GMT

Hi all,

I copied some code from one (unix solaris) machine to another and am now
getting the following error:

The Network Adapter could not establish the connection

The exact same code works fine on the original machine, so the DB is up,
listeners are up, etc.
I am missing one vital thing - there is no Oracle installed on the new
machine. I just moved the classes111.zip file. I did not install Oracle.
I don't think I should have to, but obviously, I'm missing something I
need to connect.
(there is no tnsnames.ora, etc)

This fails on the new machine.
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:url:port:instance", "username", "password");

Any ideas what I need to do to get a connection to a DB without having
to install oracle on the machine?

TIA

Signature

--
~kaeli~
She was engaged to a boyfriend with a wooden leg but broke
it off.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

Reply to this Message

Joe Weinstein - 24 Feb 2004 17:10 GMT

> Hi all,
>
[quoted text clipped - 16 lines]
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:url:port:instance", "username", "password");

Check your URL. The one you print above seems broken.
It should be something like: "jdbc:oracle:thin:DBMSMACHINE:PORTNUMBER:SID

Joe Weinstein at BEA

> Any ideas what I need to do to get a connection to a DB without having
> to install oracle on the machine?
>
> TIA

Reply to this Message

kaeli - 24 Feb 2004 18:41 GMT

> Hi all,
>
> I copied some code from one (unix solaris) machine to another and am now
> getting the following error:
>
> The Network Adapter could not establish the connection

Solved.

Solution: Had to add DNS entry for Oracle host machine to host files on
new machine. New machine was missing that entry.

Oops. :)

Signature

--
~kaeli~
Who is General Failure and why is he reading my hard disk?
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

Reply to this Message

Richard Wheeldon - 27 Feb 2004 00:00 GMT

> Any ideas what I need to do to get a connection to a DB without having
> to install oracle on the machine?

I'm having similar problems here. Which version of oracle are
you trying to connect to ?

Richard

Reply to this Message

kaeli - 27 Feb 2004 14:22 GMT

> > Any ideas what I need to do to get a connection to a DB without having
> > to install oracle on the machine?
[quoted text clipped - 3 lines]
>
> Richard

I solved this problem. The machine I was on didn't "know" the machine
Oracle was on by it's name. Adding an entry to one of the config files
for the machine fixed it.
It was Oracle 8i.

Signature

--
~kaeli~
Contrary to popular opinion, the plural of 'anecdote' is
not 'fact'.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

Reply to this Message

The Network Adapter could not establish the connection

Free Magazines