Hi All,
We are facing the below issues while connecting to Oracle RAC 11g server using SCAN IP from JDK 1.7 application using JDBC Thin client
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647552)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at java.sql.DriverManager.getConnection(DriverManager.java:571)
[16/May/2014:22:33:58] warning ( 6975): CORE3283: stderr: at java.sql.DriverManager.getConnection(DriverManager.java:215)
TNSNAMES ORA File Entry has proper "SERVICE_NAME" , when compared with entries in Listener.ora file from DB Server.
I have only "tnsnames.ora" file in my client "/opt/app/oracle/product/11.2.0/client_1/network/admin" and my GUI application is using this as reference.
HELLO=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Name>-orasvip.rr.<xyz>)(PORT = 1522))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HELLO)
)
)
===I have verified all blogs and confirmed with all parameters, please let me know if I need to add any other libraries/configurations at client side?