HP-UX Error

[Radhakrishnan Venkatara]

Hai,

my oracle database has got shutdown automatically the lgwr process got killed.
I found a error file of lgwr in /software/oracle/rdbms/log/lgwr_5888.log

the error is :

error 313 detected in background process
OPIRIP:Uncaught error 447.Error stack:
ORA-00447:fatal error in background process
ORA-00313:open failed for members of log group 1 of thread 1
ORA-00312:online log 1 thread 1:`/software/oracle/dbs/log1CEN.dbf'
ORA-07362:sfifi: open error, unable to open file.
HP-UX Error:23:File table overflow

if any body could find

thanks in advance

radhakrishnan

[Herve BRANGIER]

Hi

I never use Oracle but your message come from
HPUX system error : you can't open a file
because you have too many open files !!!

You can modify tunables parameters in :
sam->kernel configuration->configurable parameters

I think you can modify "nfile" (increase values)
and ninode. I think that a database use a lot of
file locks so it may be interisting to increase
nflocks value.

Don't forget you need to rebuild a kernel so you
have to restart your server....

I can't say you if this error comes from another
problem on oracle's applications.

HTH

Herv?

[Alexander M. Ermes]

Hi there.
Depending on the size of your machine you should enlarge these kernel parameters :

nfile
ninode

An Oracle database needs a lot of open files.
The database files, the online logs, the offline logs ( if exist ), the control files and so on.
Try to get the lsof utility to checl the number of oopen files used by Oracle.
Rgds
Alexander M. Ermes

[Rainer von Bongartz]

definitly caused by kernel parameter nfile to small.
you should increase nfile.

if you are on 11.x first check the value of nfile
kmtune -q nfile
then increase nfile (double it )
kmtune -s nfile=xxx
build a new kernel
mk_kernel
schedule kernel update
kmupdate
and reboot box now or at a later time
shutdown -r