This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
We are connecting to Oracle RAC using thin client (using driver ojdbc14.jar) on WebSphere 184.108.40.206 (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:
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.
Joined: Dec 01, 2008
The above applies for etc/hosts files too.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com