socket connection error while running Oracle Express

[sheevm]

When using Oracle Express Server on hp server we get socket connection
errors every 5 - 10 minutes. I have opened a case with Oracle on this issue
and they have asked us to look into the following ::

- Is there any socket related errors we find on HP at O.S level?
- tcp/ip timeout parameter setting on the host

can anyone tellme where I look for this info in hp server?

We are running 11.0/L2000.

Thanks

[Stefan Farrelly]

The only way to see TCP socket problems on the HP is; netstat -a|grep tcp|grep -i wait

This will show hung connections (TIME_WAIT, CLOSE_WAIT, TIME_WAIT2) where a tcp socket connection was broken. If an application closes down normally these shouldnt happen.

As for the tcp timout parameter you want;

ndd -get /dev/tcp tcp_keepalive_interval

And use ndd -set to change it. This is only temporary though (lost at next reboot) - modify in /etc/rc.config.d/netconf to make it permanent.

[sheevm]

Hi Stephan:

Thanks for the reply. I executed ndd command
I get 7200000 value.

I looked at the man on ndd it says
240000 = 4min. I did math on the 7200000

it is 120 minutes? Am i right? This is high value right? Please comment on this.

Thanks