topic socket connection error while running Oracle Express in Operating System - HP-UX

socket connection error while running Oracle Express

sheevm — Mon, 15 Jul 2002 12:31:16 GMT

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

Re: socket connection error while running Oracle Express

Stefan Farrelly — Mon, 15 Jul 2002 13:05:58 GMT

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.

Re: socket connection error while running Oracle Express

sheevm — Mon, 15 Jul 2002 13:19:11 GMT

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