OraFAQ Forum: General » Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter could

Home » Other » General » Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter could

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter could [message #102533]

Thu, 11 July 2002 09:09

Ranga
Messages: 1
Registered: July 2002

Junior Member

Hi,
I am trying to run one of my application which talks to the Database which is remotely located .
I am getting the following error

Error:
Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Oracle is 8.1.7.3 on Solaris 8 platform.
I can do an SQLPLUS and the connection is ok.
From my application I tried to echo the DB_URL which had the following output

jdbc:oracle:thin:@Box1:1521:sid1

Box1 is were the Datbase resides. The Db_user and Db_password are also set in the .login of the user which the application can see.

I don't know were the problem is ?
Can any body help me out.
Thanks
Ranga

Report message to a moderator

Re: Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter co [message #102534 is a reply to message #102533]

Thu, 11 July 2002 11:17

Grant
Messages: 578
Registered: January 2002

Senior Member

Has this ever worked? If sqlplus works I would say your port is incorrect for the jdbc connection. When you are able to connect with sqlplus it says your listener is running and the database is up. Make sure your port is correct, your LD_LIBRARY, CLASSPATH is set. Take a look at "Identifying Connection String Problems in JDBC Driver" in Meta Link.

Report message to a moderator

Re: Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter co [message #102687 is a reply to message #102533]

Mon, 26 August 2002 18:45

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi, I fased the same problem once, after starting my oracle lsnrctl it solved.

It may help you.

Report message to a moderator

Re: Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter co [message #102690 is a reply to message #102533]

Tue, 27 August 2002 09:57

Hugh Saunders
Messages: 1
Registered: August 2002

Junior Member

I was having this problem under Linux and it came down to a hostname mismatch - the DNS resolved correctly, but the result from the hostname had a different domain name. Solution was to update the hostname to match DNS and restart.

Report message to a moderator

Re: Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter co [message #103047 is a reply to message #102690]

Wed, 22 January 2003 04:47

bharath
Messages: 30
Registered: November 2000

Member

Hi,

I'm new to linux could u pls explain me how to configure the hostname to match DNS?

TIA
Bharath.

Report message to a moderator

Re: Failed to make database connection: java.sql.SQLException: Io exception: The Network Adapter co [message #103181 is a reply to message #102533]

Wed, 26 February 2003 12:47

Roland
Messages: 24
Registered: March 2002

Junior Member

I had the same problem. This was caused because I had the wrong DB name in my connection string. I fixed it by using the SID name as the DB name.

Report message to a moderator

Hostname [message #103354 is a reply to message #103047]

Thu, 26 June 2003 04:12

Peter Saitz
Messages: 1
Registered: June 2003

Junior Member

# hostname the_name_you_like
e.g.
# hostname mymachine.anywhere.net
or if you are running RedHat-Linux use
# linuxconf

Report message to a moderator

Previous Topic:	Problem: Import in relaese 8.1.5 while it exported from 8.1.6 error case statement
Next Topic:	UTL_FILE packge

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 22:47:10 CST 2024