Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FILE SIZE EXCEEDED HELP NEEDED!!

Re: FILE SIZE EXCEEDED HELP NEEDED!!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 09 Nov 1998 16:16:41 +0100
Message-ID: <36470759.F893118A@sybrandb.demon.nl>


You need to increase your ulimit (of the oracle user) beyond the size of the system01.dbf. Osh checks only for a default limit AFAIK. As you didn't specify your flavour of Unix I can't tell you exactly how to change it. Hth anyway

Sybrand Bakker, Oracle DBA

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
Received on Mon Nov 09 1998 - 09:16:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US