Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

HP-UX Error

Radhakrishnan Venkatara
Trusted Contributor

HP-UX Error


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

Negative thinking is a highest form of Intelligence
Respected Contributor

Re: HP-UX Error


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.



Alexander M. Ermes
Honored Contributor

Re: HP-UX Error

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


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.
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
schedule kernel update
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 ...