Discussion Locked

apache listener on Solaris 8 seems to ha

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, My Oracle database TEST instance's apache listener seems to hang frequently when I stop/start the instance.

Usually what happens is that I need to bounce the instance, so I stop the forms server side, then bring down the database server side. usually i wait a couple of minutes before restarting the instance. when i do i find the forms server isn't able to get the apache server to start up b/c it is being used by another port. that port is the correct port, it is doing this b/c the process is hung and doesn't die off. i've tried doing a 'kill -9' on the PID but it will not go away (it's not a permissions issue). it will only go away after a reboot of the box.
any suggestions would be greatly appreciated.
cmazur@skinceuticals.com

3 replies

by kshcsuf

Are you referring to your Net8 Oracle listener or an Apache instance which supports your Oracle install? netstat -an is really helpful, and shows you what sockets are currently in used, and any active TCP/UDP listening binds.

You may have several sockets open to support HTTP requests that have not completely closed yet. Try (substitute 80 for the port your web server runs on):

netstat -an | grep .80

If you see several hundred pending CLOSE_WAIT and TIME_WAIT sockets, give it a few minutes. Production grade Apache and IPlanet Web Servers on Solaris best benefit from a lowered tcp_time_wait_interval. The default is 10 minutes. (That means that a disconnected HTTP request may still have a file descriptor, socket and appropriate kernel resources allocated to it for up to 10 minutes!) Not to mention that the Solaris default rlim_fd_max for Solaris 8 is 1024. (You can actually run out of available file descriptors for sockets due to connections in CLOSE_WAIT or TIME_WAIT wasting resources.)

by z_mazurc

thanks. this has put me on a path to correcting it in the future, however i've left this establishment so i can not verify it. thanks again.

This discussion is closed to new replies.