[SunHELP] Activeworks!!!

[ES Srinivas]

Hi All
   We have a Sun E250 running on Solaris 7(SunOS sun250b 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-250),which is also having Oracle,Activeworks,JDE Oneworld Adapter installed.
   The problem is the application Activeworks is used to write some log files into the Oracle database,which are both on the same system.At the application end the following is the error:

11:43:02 AM [Debug] Logger(0)                                SQLException in update restart count: Error Message: Exhausted Resultset; Error Code: 17011; SQLState: null
11:43:02 AM [Debug] Integration(2)                           Unable to log begin event for com.wipro.security.active.atc.iscatc.ISCAgentForWs; Exception: SQLException in update restart count: Error Message: Exhausted Resultset; Error Code: 17011; SQLState: null
11:43:02 AM [Adapter] Unable to log begin event, is logging database available?
11:43:02 AM Unable to log begin event, is logging database available?

   The DBA says there is nothing wrong with Oracle and found out that there is a problem at the TCP/IP socket level with the following output of netstat command.
 
10.150.50.112.35032  10.150.50.112.1521   32768      0 32768      0 CLOSE_WAIT
10.150.50.112.35040  10.150.50.112.34902  32768      0 32768      0 CLOSE_WAIT
10.150.50.112.34369  10.150.50.116.1521    8760      0  8760      0 TIME_WAIT  
10.150.50.112.34676  10.150.50.118.59305   8760      0  8760      0 CLOSE_WAIT
10.150.50.112.35025  10.150.50.112.1521   32768      0 32768      0 CLOSE_WAIT
10.150.50.112.35041  10.150.50.112.33327  32768      0 32768      0 CLOSE_WAIT
10.150.50.112.35042  10.150.50.112.33605  32768      0 32768      0 CLOSE_WAIT

   According to the DBA 1521 is the port on which Oracle listens.
   The user says Active Works is  a dynamic port configurer and the DBA says its only the problem with TCP/IP stack or socket level of Solaris and is for the System Admin to resolve the issue.
    Can somebody help me 
    This is very Urgent
    Thanks in Advance

Srinivas.E.S.


_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com