> 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=__jd bc__)(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(DBE rror.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.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.