This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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

Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 18150

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.
It is sorta covered in the JavaRanch Style Guide.
subject: Oracle 10g (RAC) and WebSphere
Similar Threads
re:java.lang.Exception: ORA-00020: maximum number of processes (150) exceeded?
datasource connection in admin console unsuccessful
Oracle 10g RAC Configuration, JBOSS
OC4J - Connection issues.. Very important