Re: Oracle has trouble with big files on Linux???

Linux support only 2G files...

tu

<karipid_at_my-deja.com> wrote in message news:84arg8$72p$1_at_nnrp1.deja.com...
> Hello,
>
> I'm facing a rather strange situation. Oracle won't startup on my
> Linux box. The datafile containing the SYSTEM tablespace is supposed to
> be corrupt. I can see it when I do an "ls", it's 2147482624 bytes!
> This is close to the 32-bit signed integer upper limit. Could this be
> the reason?
>
> Here's the dump file produced:
>
> Dump file /u01/app/oracle/admin/ORCL/bdump/dbw0_orcl_4522.trc
> Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.1.0 - Production
> ORACLE_HOME = /u01/app/oracle/product/8.0.5
> System name: Linux
> Node name: her-linux
> Release: 2.0.36
> Version: #73 Tue Jan 19 12:21:53 MET 1999
> Machine: i686
> Instance name: ORCL
> Redo thread mounted by this instance: 1
> Oracle process number: 3
> Unix process pid: 4522, image: ora_dbw0_ORCL
>
> *** SESSION ID:(2.1) 1999.12.28.20.00.21.657
> ORA-01157: cannot identify data file 1 - file not found
> ORA-01110: data file 1: '/u01/oradata/ORCL/system01.dbf'
> ORA-27037: unable to obtain file status
> Linux Error: 2: No such file or directory
> Additional information: 3
> ORA-01157: cannot identify data file 1 - file not found
> ORA-01110: data file 1: '/u01/oradata/ORCL/system01.dbf'
> ORA-27037: unable to obtain file status
> Linux Error: 2: No such file or directory
> Additional information: 3
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 28 1999 - 13:06:04 CST