File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes Oracle 10g (RAC) and WebSphere Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Oracle 10g (RAC) and WebSphere" Watch "Oracle 10g (RAC) and WebSphere" New topic

Oracle 10g (RAC) and WebSphere

raj dave

Joined: Nov 22, 2008
Posts: 1
We are connecting to Oracle RAC using thin client (using driver ojdbc14.jar) on WebSphere (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.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

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.
Khurram Ahmed

Joined: Dec 01, 2008
Posts: 2
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.
Khurram Ahmed

Joined: Dec 01, 2008
Posts: 2
The above applies for etc/hosts files too.
I agree. Here's the link:
subject: Oracle 10g (RAC) and WebSphere
It's not a secret anymore!