• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 10g (RAC) and WebSphere 6.0.2.27

 
raj dave
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are connecting to Oracle RAC using thin client (using driver ojdbc14.jar) on WebSphere 6.0.2.27 (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
Sheriff
Posts: 20990
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The above applies for etc/hosts files too.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic