RE: [SLE] nscd: 452: while accepting connection: Too many open files in system

From: Greg Wallace (jgregw_at_acsalaska.net)
Date: 09/29/05

  • Next message: John Scott: "Re: [SLE] Perl and Perl Modules - YaST vs. CPAN(?)"
    To: <suse-linux-e@suse.com>
    Date: Wed, 28 Sep 2005 17:33:42 -0800
    
    

    On Wednesday, September 28, 2005 @ 5:09 AM, Asim Sardar wrote:

    >Importance: High

    >Hi
     
    >I have Oracle Database running on Suse. For last two days I am having a
    >performance issues and machines got hanged. When I check /var/log/messages
    >I found the following errors:
     
    >1. nscd: 452: while accepting connection: Too many open files in system. <
    >Most Critical>
     
    >2. modprobe: modprobe: Can't locate module char-major-116.
     
    >I am more worried about the first one. Please advice.
     
    >Regards
    >Asim Sardar
     
    I am running 9.2 on my machine. The installation manual for 9i says the max
    open files should be set to 65536. I think you'll find that you cannot
    increase it beyond 1024 unless you are logged on under root. You may be
    able to modify this via some kernel parameter, but I don't know. I went a
    different route. I set up a start-up script under root and execute it via a
    su -C from my regular user account. The script issues two ulimit commands,
    starts Oracle, then comes back to my regular session. The two ulimit
    commands are --

    ulimit -n 65536 <-max open files
    ulimit -u 16384 <-max processes per user

    These limits are as per the instructions in the Oracle 9i Installation Guide
    under Pre-Installation Requirements (page 2-21).

    Greg Wallace

    -- 
    Check the headers for your unsubscription address
    For additional commands send e-mail to suse-linux-e-help@suse.com
    Also check the archives at http://lists.suse.com
    Please read the FAQs: suse-linux-e-faq@suse.com
    

  • Next message: John Scott: "Re: [SLE] Perl and Perl Modules - YaST vs. CPAN(?)"

    Relevant Pages

    • Re: AIX Performance issue
      ... this is how we take backup ... Same for Oracle 7.3.4? ... application, in this database, on this Operating System? ... Perhaps the scripts and commands you're running ...
      (comp.unix.aix)
    • Re: Quick role test
      ... alter user bob1 default role all except foo33 identified using ... After the combined commands, ... Surely Oracle development tests all sorts of things, ...
      (comp.databases.oracle.server)
    • Re: [SLE] sudoers file
      ... I like it because it logs all commands, ... # This file MUST be edited with the 'visudo' command as root. ... # Oracle user is oracle on some machines, ...
      (SuSE)
    • Re: Spool in SQL*Plus without SQL statments
      ... ECHO does not affect the display of commands ... Oh and to get rid of the column heading underline I asked about ... web; not oracle docs though). ...
      (comp.databases.oracle.misc)
    • Re: Sql*Loader, Bequeath and ulimit
      ... Ulimit for Oracle for fsize is unlimited, ... calls sqlldr is 2 GB. ... the ulimits of the calling user ...
      (comp.databases.oracle.server)