关于listener 案例_3

Subject: HPUX Error: 233, Connections to Database Hang
Doc ID: Note:239209.1 Type: PROBLEM
Last Revision Date: Status: PUBLISHED

fact: Oracle Net
fact: TNS Listener
fact: HP 9000 Series HP-UX
symptom: Connections to database hang
symptom: Errors reported in the listener.log
symptom: TNS-12560: TNS:protocol adapter error
symptom: TNS-00530: Protocol adapter error
symptom: HPUX Error: 233: No buffer space available
cause: Problem is generally seen during high workload on machine.
The underlying problem of these errors is the operating system.
The HP UX system file /usr/include/sys/errno.h shows the following information
for the OS error 233:

# define ENOBUFS 233 /* No buffer space available */

ENOBUFS means there is no sufficient memory available and the system(kernel)
can not allocate any more.
Application will usually retry the operation when it detects this error from a
system call since it indicates there is a transient resource shortage.
It is the Operating system that refuses the resource request from the listener.
The virtual memory allocation routine of the OS will determine if a swap can be
made to disk of a real memory segment thereby allowing the listener access to
some more real memory

fix:

Free up memory on the machine