We are connecting to Oracle RAC using thin client (using driver ojdbc14.jar) on WebSphere 18.104.22.168 (AIX as the O/S). Every time we test the data source we get different results, sometimes the test connection is successful and sometimes it fails with the following error:
java.lang.Exception: java.sql.SQLException: Io exception: The Network Adapter could not establish the connectionDSRA0010E: SQL State = null, Error Code = 17,002.)
The error appears completely at random...if I test the data source connection 5 times in 10 seconds then the error would appear 2-3 times and the other test connections would be successful. I can provide the connection URL if someone can provide more insight.
I have found that there are multiple entries in /etc/hosts file on the application server host (AIX) for the Oracle 10g VIP's. Can this cause any issues? I cannot edit the file since we don't have rights to update the file.
We had a PMR open with IBM but they closed it saying that it seems to be an Oracle issue. I doubt if they even tried to recreate the problem. Any help on this issue would be greatly appreciated.
I have to agree with IBM, this most likely isn't a Websphere problem. It probably isn't an Oracle problem, either. You yourself seem to be suspecting it's a network problem. The /etc/hosts file might be the problem itself or it might be a symptom of the actual problem. So I would follow up on that. Apparently you're in one of those bureaucratic environments where you don't have free rein to work on problems by yourself, so I would recommend getting the network people involved.
I ran into a similar problem with RAC a couple of years ago. If this is INDEED a network problem then i'd advise you to ensure that all your oracle server machines are properly registered in your DNS for both forward and reverse lookup. The same goes for your client machines.