cannot contact database via JDBC thin driver but I can contact it via OCI driver

Hi!

  I have an Oracle 9.2.0 running on Solaris OS. I am trying to use a JDBC application to contact the database, but I have the following:

• if I set the application to use the OCI driver (on the machine where the Oracle is running) everything if fine.
• [the problem] if I try to use the thin driver (even if I start the application on the same machine as the Oracle installation), I cannot contact the database and I receive the following exception:

java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

        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:334)

        at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3695)

        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)

        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:362)

        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:536)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328)

        at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:124)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)

        at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:368)

        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

        at java.lang.Thread.run(Thread.java:534)

Please notice that there is no firewall (this is valid for the remote machines only), the TNS listener runs on 1521 port and I have the following lines in "sqlnet.ora" file from "network/admin/" folder:

# allow only specified nodes to access the database(s) TCP.VALIDNODE_CHECKING = YES
TCP.INVITED_NODES = (<os_DNS_Name>, <my_IP_address>).

Do you think you can help me with this topic (?) or please point me to a documentation where I can find this topic.

Many thanks,
  cristi.

PS: sorry if this is (maybe) the wrong place to put this question! Received on Mon Oct 11 2004 - 03:50:16 CDT