HI all ,

I am getting the following error while trying to connect my database
through JDBC thin conection of Forte tool.

We are able to connect our database from SQLPLUS. We are on SUN solaris
5.8 . Oracle8.1.6. Listner is running and we have even restarted
our listner but it does no help in solving this problem. I am also
attaching the listner services file with this mail. Please suggest some
feasible solution
to this problem.

java.sql.SQLException: Io exception: The Network Adapter could not
establish the
connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:342)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:415)

at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:485)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:337)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Premier.BaseServlet.openConnection(BaseServlet.java:340)
at Premier.Login.validateUserPassword(Login.java:297)
at Premier.Login.service(Login.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletReque
stDispatcher.java:508)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(Ser
vletRequestDispatcher.java:177)
at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpReques
tHandler.java:576)
at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.ja
va:189)
at com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:62)

Error Code :17002
Error Message :Io exception: The Network Adapter could not establish the
connect
ion
Error - Localized Message :Io exception: The Network Adapter could not
establish
the connection


Thanks in advance
Vijay Kr. Singh


$ lsnrctl services

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 30-SEP-2002 10:26:11

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS
=(PROTOCOL=TCP)(HOST=3.209.4.40)(PORT=1521)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
systip has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
systip has 3 service handler(s)
DISPATCHER established:1 refused:0 current:1 max:1022 state:ready
D001 <machine: sun-lily, pid: 20647>
(ADDRESS=(PROTOCOL=tcp)(HOST=sun-lily)(PORT=51288))
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D000 <machine: sun-lily, pid: 20645>
(DESCRIPTION=(ADDRESS
=(PROTOCOL=tcp)(HOST=sun-lily)(PORT=51286))(PRESENTAT
ION=oracle.aurora.server.SGiopServer)(SESSION=RAW))
Presentation: oracle.aurora.server.SGiopServer
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
test has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
tip has 1 service handler(s)
DEDICATED SERVER established:1 refused:0
LOCAL SERVER
tip has 1 service handler(s)
DEDICATED SERVER established:151 refused:0
LOCAL SERVER
The command completed successfully

Oracle LazyDBA home page