Cannot Connect When Using 9.2.0.1 Thin Driver and Loadbalancing (Doc ID 371702.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 9.2.0.1 to 9.2.0.3 - Release: 9.2 to 9.2
Information in this document applies to any platform.

Symptoms

Using 9.2.0.1 JDBC  Thin driver to access  a RAC cluster with the following connect string :

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(LOAD_BALANCE=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))
)
(CONNECT_DATA =(SERVER =DEDICATED)(SERVICE_NAME = DB102))
)


At connection time,  the following exception is occurring :

java.sql.SQLException: Io exception: Connection refused (DESCRIPTION=(ERR=1153)(VSNNUM=153093632)
(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTO =TCP)(HOST=hostname)(PORT=1521))'))
(ERROR=(ODE=305)(EMFI=1))))

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms