TNS error and HPUX Error 32

[Gumeni]

Hi,
I have the following message error in listener.ora log file:
"TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe"

Configuration is:
HW: 9000/800
OS: HPUX11.00
RAM: 512MB
Swap: 1.5 GB (fs)
SW: ORACLE 8.0.5
Thank you

[Steven Sim Kok Leong]

Hi,

I encountered this error when my server ran out of memory and swap. The listener died and this messages are logged in the listener log. Was any of your system resources depleted at the point in time the listener died?

For further troubleshooting, you may wish to enable listener trace. However, do bear in mind that listener trace files can consume a lot of disk space especially on a production server.

Hope this helps. Regards.

Steven Sim
Brainbench MVP for Unix Admin
http://www.brainbench.com

[Alexander M. Ermes]

Hi there.
Check your memory usage with the ipcs or glance. Your SGA may be a wee bit to large,
so that users cannot ( like oracle with the listener ) take more space.

Rgds
Alexander M. Ermes