Re: FILE SIZE EXCEEDED HELP NEEDED!!

ORA-07209 "sfofi: file size limit was exceeded"

  *Cause: The size of the file to be opened exceeded the OS limit imposed on    this process.

  *Action: Run osh to increase the files size limit.

Solution Explanation:

The series of error messages are a result of an inadequate ULIMIT setting at the OS level. The ULIMIT parameter controls the size of a file which may be opened at a given time.

The superuser (root) can change the ULIMIT parameter, and the user Oracle may execute the OSH utility to change the parameter.

The OSH utility is within $ORACLE_HOME/bin

Consult your operating system documentation for the appropriate unix command to set the ULIMIT.

In article <726r3v$4id$1_at_nnrp1.dejanews.com>,   naveen_arora_at_my-dejanews.com wrote:
> hi!,
>
> While brining up ORACLE 7.3.2 on UNIX I am getting following message :
>
> ORA -01116 : error in opening db file1
> ORA-01110 : data file 1 : /volA/oracle/oradata/CDOT/system01.dbf
> ORA-07209 : file size limit was exceeded
>
> I tried to use osh on system01.dbf but I am not sure its correct usage.
>
> Can any one HELP ? Its urgent.
>
> naveen
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 09 1998 - 13:57:29 CST