JDBC Connection to RAC with 2 listeners 2 ports errors out
I have a 2 node RAC 11.2.0.3 we are in the process of moving from the old stile vip listeners to the new SCAN. We have both running old on 1522 and scan on 1521. Remote listener is 1521 local listener is 1522 as instructed by oracle support.
When connecting using OCI (sqlplus,plsql developer) no problems connects without error. I traced the network using wireshark and when connecting to the db via 1521 the client is almost always redirected to 1522.
When using JDBC thin connection as soon as the client is redirected to 1522 I get the error. "java.sql.SQLException: The Network Adapter could not establish the connection". I tested with sqldeveloper as well as my own jdbc connect test class. Same results. As soon as I change the connect string to go to port 1522 it works fine.
Anyone else have this issue?
DB Parameters
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.241.91.4)(PORT=1522))))
remote_listener string vc-orcltrx-scan.qa.paygateway.com:1521