Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1OGvQb24518 for ; Mon, 24 Feb 2003 10:57:26 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1OGvPQ24513 for ; Mon, 24 Feb 2003 10:57:25 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA95530; Mon, 24 Feb 2003 05:40:57 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00556803; Mon, 24 Feb 2003 05:04:08 -0800 Message-ID: Date: Mon, 24 Feb 2003 05:04:08 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: babu.nagarajan@Cummins.com Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: babu.nagarajan@Cummins.com Subject: Re: File Table Overflow on Oracle DB Server Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Here is Kirti's reply to it (long time back in June). I think it was to you that time also... Babu >>>> Vivek, You are right, this is an OS related issue, but a DBA must be aware of why it happens ;) Error 23 means 'File Table Overflow' and it is generated when the system wide limit for the number of simultaneously open files is exceeded. It is controlled by a kernel parameter 'nfile'. which defaults to a value arrived at by a formula that uses 'maxusers' (and a couple of other) kernel parameters. You can check the values set for 'maxusers' and 'nfile' on these servers, and get your SA to increase those on the server where you had a problem starting the database. Use '/usr/sbin/kmtune -q ' command to check currently set value for 'nfile' and 'maxusers'. Read more about 'nfile' at http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html. HTH, - Kirti VIVEK_SHARMA osys.com> cc: Sent by: Subject: File Table Overflow on Oracle DB Server root@fatcity.com 02/24/03 06:28 AM Please respond to ORACLE-L > We have the following query reg. an error on HP-UX ORacle DB server. > > We are encountering "HPUX Error: 23: File table overflow'" on the > Oracle database server while executing stress tests for our > application. We are not opening any files on the database server > through the application still this error keeps coming after running > the test for some duration. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA@infosys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _____________ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: babu.nagarajan@Cummins.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).