Re: $ORACLE_HOME/bin/osh - what is it?

oracle wrote:
>
> David J DeWolfe wrote:
> >
 

> > ORA-01116: error in opening database file 1
> > ORA-01110: data file 1: '/u01/ORACLE/FINP/data/syst01FINP.dbf'
> > ORA-07209: sfofi: file size limit was exceeded.
> >
> > Which indicate that the datafile that is the system tablespace could
> > not be opened. Again, the database was up and open and has over 200
 <snip>
> "osh" is oracles own proprietary shell. It is based on the bourne shell
> but it has a ulimit of unlimited. Your problem sounds like a ulimit
> problem. What is it set at for the "oracle" user? You need to total
> all amount of all the open files that oracle is opening and see if that
> exceeds your ulimit value. Oracle recomends an unlimited value but most
<snip>

This does not sound like a ulimit error. ulimit is on a per-file basis and only applies to creating or writing files, not reading them. And database files don't grow - they are fixed size anyway. This sounds more like running out of system file descriptors or some other system resource. When this happens again, use sar (or similar program) to print out system resource usage. I don't think osh will fix it. You'll need to retune the kernel to increase the parameters. Have you looked up the 7209 error in the OS specific error msg manual? Usually this will tell you exactly what the problem is.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.