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-----
Sent: Tuesday, June 04, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L

text file is usually "/usr/include/sys/errno.h" on most UNIX platforms...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 04, 2002 4:09 PM

> Hi,
>
> As I remember "Error Num 23" is OS error code. Contact your system admin.
There should
> be a text file which defines OS error codes.
>
> VIVEK_SHARMA wrote:
>
> > Solved
> >
> > Database OPENed Successfully on another HP-UX Box Without any ORA-1092
> > The Same Oracle & OS Versions Existed on Both HP-UX Boxes .
> >
> > NOTE Though ORA-1092 was often succeeded by the message :-
> > "Error Num 23"
> > NO Idea what Error Num 23 Stands for ?
> > Thus This seems to be Some OS /Hardware Issue with the Previous
Production Database
> > on which the Database would NOT Open after OS RE_Installation .
> >

< Stuff Deleted >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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: ListGuru_at_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).