Sunday, February 9, 2014

ORA-12505 SCAN Listener And JDBC


The Above Error Appears when trying to connect RAC database Using SCAN Listener through JDBC, I checked everything and it was working without any problem, I could not find any reason why this issue happened, nothing in the Listener.log.

So I Used the below connection String instead of above one.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SCAN-LISTENER-NAME)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=Service-name)))

Thank you
Osama Mustafa 

No comments:

Post a Comment