Vivek, Just to add a simple way of determining the extent of overflow, you could use the sar -v command. This will also display other OS counters as well.
00:00:02 proc-sz ov inod-sz ov file-sz ov lock-sz 00:20:02 435/2580 0 4641/8816 0 7593/16884 0 25/33168 In fact, I would first check this out before adding a new database on any server, and use the SHM-modifications-reboot to change these as well. As per my understanding, Solaris defines an upper limit for these values, but doesn't allocate space until required, so you are Ok to define larger values without bulking up OS memory requirements. Anyone knows what happens in HP-UX? John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-----Original Message----- >From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, June 04, 2002 5:28 PM >To: Multiple recipients of list ORACLE-L >Subject: RE: Production Database Open Fails after Mount > > >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 <parameter>' 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 > >-----Original Message----- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
