cancel
Showing results for 
Search instead for 
Did you mean: 

HP-UX Error

Radhakrishnan Venkatara
Trusted Contributor

HP-UX Error

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
Negative thinking is a highest form of Intelligence
3 REPLIES
Herve BRANGIER
Respected Contributor

Re: HP-UX Error

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
Honored Contributor

Re: HP-UX Error

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Rainer von Bongartz
Honored Contributor

Re: HP-UX Error

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
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...