dkoleary_at_attbi.com wrote:
>Hey, all;
>
>I have 2 HP 9000/800 L1000s that are both running HPUX 11.00
>supporting multiple Oracle 9.X instances. These two systems
>are practically clones of each other - same OS level, same
>number/type/speed CPUs, same amount of RAM, etc, etc.
>
>One of the servers is getting the following error periodically:
>
>=================================================
>22-SEP-2003 11:29:02 * 12560
>TNS-12560: TNS:protocol adapter error
>TNS-00530: Protocol adapter error
>HPUX Error: 233: No buffer space available
>22-SEP-2003 11:29:18 * 12502
>TNS-12502: TNS:listener received no CONNECT_DATA from client
>22-SEP-2003 11:29:57 * 12502
>TNS-12502: TNS:listener received no CONNECT_DATA from client
>=================================================
>
>The dbas here believe the line "HPUX Error: 233: No buffer space
>available" indicates an issue with the operating system.
>
>There was originally a difference in the kernel. I updated the
>kernel on the error prone system which reduced the frequency of
>the errors, but the dbas are still getting them.
>
>Other than that, any other differences actually favor the error
>prone system. It has more swap configured, less memory utilization,
>fewer Oracle instances running, etc, etc.
>
>I am running some system diagnostics which poll the system every
>two minutes. Everything I can find in those diagnostics says
>the system is chugging away just fine - no real resource
>bottlenecks.
>
>Does anyone have any ideas on what I could look for to correct
>this issue? I'd appreciate any hints/tips/suggestions.
>
>Thanks for your time.
>
>Doug O'Leary
>
>--------
>Senior UNIX Admin
>O'Leary Computer Enterprises
>dkoleary_at_attbi.com (w) 630-904-6098 (c) 630-248-2749
>resume: http://home.attbi.com/~dkoleary/resume.html
>
>
Does "updated the kernel" translate to you went into SAM and changed all
of the shared memory and semaphore settings to match those recommended
by Oracle or just that you fiddled around a bit based on experience?
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Sep 23 2003 - 17:38:52 CDT
