I am trying to setup a 9.0.1.3 listener to service both 9.0.1.3 and 8.1.7.3 databases on Solaris 2.8. Regular dedicated connections and OCI Java connections work without a problem. JDBC Thin connections fail with an error of:
Code:
Exception in thread "main" java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=12518)(VSNNUM=150999808)(ERROR_STACK=(ERROR=(CODE=12518)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at thintest.main(Compiled Code)
In the listener.log, I get the following error:
Code:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
My listener.ora entry looks like:
Code:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/817)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ibdev1.us)
(ORACLE_HOME = /oracle/app/oracle/product/817)
(SID_NAME = ibdev1)
)
)
And I'm trying to connect with:
Code:
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@oradev1:1521:ibdev1", "myuser", "mypass");
Anybody have any ideas?