1. In the Connection Manger, right-click on the connection in question and choose "Properties." In the Oracle Home drop down, change from default to the client that has the RAC TNS entry stored in. Check <Oracle Home path>\network\admin\tnsnames.ora if you are unsure the RAC TNS entry exist in the Oracle home you selected.
2. When connecting, check the port number in the "Verify Cluster Connection Detail" window to be sure it is correct. If not, click into the field and change it to the correct port number (see screen shot SOL104797_Fig_2.PNG).
3. Create additional individual TNS entries for each node on the RAC.
For example, given the following RAC of two nodes...
QST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=quest1)(PORT=1531))
(ADDRESS=(PROTOCOL=tcp)(HOST=quest2)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=QST)
)
)
... please create two additional TNS entries for each node.
QST1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=quest1)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=QST)
(INSTANCE_NAME=QST1)
)
)
QST2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=quest2)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=QST)
(INSTANCE_NAME=QST2)
)
)
