Re: Oracle Thin connectio fails from outside the network

From: hilz <hs_74_at_hotmail.com>
Date: Tue, 1 Jul 2003 02:03:17 -0400
Message-ID: <ytadnT0bmNu_uZyiRTvU2Q_at_speakeasy.net>

> Can you ping the server?

yes

> Can you tnsping the listener?

i don't know. how do i do that?

> What is the error message?

in the "listener.log", i get the follwoing:

01-JUL-2003 01:07:25 *
(CONNECT_DATA=(SID=orcl1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=4.31.67.91)(PORT=1248)) * establish * orcl1 * 0

and in the java program (on the client, from outside the network), i get the following exception:
Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)

at testjdbc.<init>(testjdbc.java:18)
at testjdbc.main(testjdbc.java:7)

Any help is greatly appreciated. Received on Tue Jul 01 2003 - 08:03:17 CEST