HP/Oracle error

[Tyrone Seldon]

Oracle suggested that it's an HP problem & HP suggest it's a Oracle problem. Has anyone had this problem before?
I'm on a HP9000 K-460 with 4 processors and 1 gig of memory. I'm on a 11.00 operating system.

Recommendation from Oracle support:


In each of these occurances you have the same error stack, as follows:

TNS-12547: TNS:lost contact <-- Oracle's presentation of the error at high level.
TNS-12560: TNS:protocol adapter error <-- Next level down of the error (protocol adapter error)
TNS-00517: Lost contact <-- Lowest Oracle level. lost contact. Why? Because of the next error.
HPUX Error: 32: Broken pipe <----This is the actual error. It is an error that is comming from the HPUX level.

The HPUX error 32 is not an oracle error. This is an HP error.

If the listener is up for a long running time and then this error occurs with no changes in the Oracle configuration, then I would strongly recommend that you speak with HP on this error and see if they can isolate the nature of the problem with you. You will also want to examine the error logs on your OS.

[Sridhar Bhaskarla]

Tyrone,

Broken Pipe = Error 32 = signal EPIPE.

This results when a process writes to a FIFO but there is no process has that FIFO open for reading.

1. Check if your network configuration is ok.
2. Check if you are running short of system resources like Shared memory kernel parameters, memory and swap etc.,

If nothing works, relink the oracle executables. It doesn't make sense, but it worked before.

-Sri

[Ulf Lipski]

Hi,

your problem looks like a timeout on your network connection port or your listener process is just blocked by shortage of resources. Try to increase the number of semaphores in the kernel, parameter is nsem.

The other approach is to tune up your network, to make it faster.

How heavy is the load of your machine?

Try to restart the listener regularly and
nice the listener process.

By

[Andreas D. Skjervold]

Hi
What is the version of your Listener?

The 8.0.x listener on HP-UX has a memory leak that makes it hang and thus can't direct incoming calls to their port/localtion.

If this is the case:
Either upgrade to a 8i Listener or as I do; bounce the listener process weekly.

Andreas

[Alexander M. Ermes]

Hi there.
Could you send some more details ?
Which Oracle version is it ?
That would help.
Rgds
Alexander M. Ermes