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

cristian.vulpe_at_gmail.com (Cristian-Marius Vulpe) wrote in message news:<6ae1ea80.0410110050.3d3c9a3c_at_posting.google.com>...
> 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.
>

It would help if you would post connect string you're using with thin driver.

> Many thanks,
> cristi.
>
> PS: sorry if this is (maybe) the wrong place to put this question!
Received on Mon Oct 11 2004 - 13:25:05 CDT