Re: exception: The Network Adapter could not establish the connection

From: SP <sdpantDelete_this_to_reply_at_yahoo.com>
Date: Thu, 20 Mar 2003 20:12:43 GMT
Message-ID: <%gpea.4768$8Z5.41520@sea-read.news.verio.net>

And here is my listner.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = devdb1)(PORT = 1521))     )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = devdb1.mydomain.com)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = devdb1)

    )
  )

TRACE_LEVEL_LISTENER = ADMIN
"SP" <sdpantDelete_this_to_reply_at_yahoo.com> wrote in message news:V5pea.4767$8Z5.41552_at_sea-read.news.verio.net...
> Hi,
> I've problem connecting to Oracle 9 release 2 on windows 2000 from clinet
> which is doing a java call and has to go through firewall. I looked at
the
> listner and log file. They don't show any error. But I'm getting a error
> as below. I was trying to increase the timeout on listener.ora but
lsnrctl
> set connect_timeout 20 didn't work. How do i increase the timeout on
> listener and any ideas how to resolve this issue?
> SP
> driver: oracle.jdbc.driver.OracleDriver
> connection: jdbc:oracle:thin:@201.21.18.144:1521:devdb1
> login: user
> password: pwd
> Exception in thread "main" java.sql.SQLException: Io exception: The
Network
> Adapter could not establish the connection
> at

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
> at

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
> at
> oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)

>


>         at

> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
> va:468)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:172)
> at JDBC.main(JDBC.java:21)

>
>
>

Received on Thu Mar 20 2003 - 14:12:43 CST