Re: DB hang

From: Eve Hoellwarth <eve_hoe_at_gmx.at>
Date: 10 Sep 2006 12:08:07 GMT
Message-ID: <slrneg801d.2udl.eve_hoe@eve.fqdn.uucp.at>

madunix wrote:
> I am running SLES9 with Oracle10g on Intel based server DellPowerEdge
> 2850,
> when I came today found low performance, High utilization with Oracle
> user which include many oracle processes and system suffering
> performance lack
>
> I checked the error log didnt find in alert anything abnormal
> but the listenr logs was showing
>
> TNS-12518: TNS:listener could not hand off client connection
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> Linux Error: 24: Too many open files

This error may occur when open files limit is reached. To what value is it set on your box? Should be set at least to 65536 Are there done any changes recently to database or application? Is this a new system?

Eve Received on Sun Sep 10 2006 - 07:08:07 CDT