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

Yes, you're probably running into the 2GB limit. And it's probably too late to try to fix it. You need to trash this database and start a new one.

This time, as soon as it's been built, create another tablespace, called something else (like USERS), and alter all users to have that as their default tablespace. There are reasons why it's not a good idea to let users (even yourself) add arbitrary tables to the SYSTEM tablespace.

Moreover, it would be a good idea if this tablespace were made up of datafiles which have a size limit somewhere under 2GB. There can be almost as many as you like, so you can make the database as large as you like (within reason).

For instance, I've got 8i on RedHat 6.1, with a user tablespace with 6 datafiles of around 1.5 GB each, for a total of 9 GB. Plus, of course the SYSTEM tablespace.

These datafiles can be wherever you like in your filesystem, but you probably should read about the Optimal Flexible Architecture in the back of the Administrator's manual for Linux.

• kevin

karipid_at_my-deja.com wrote:
>
> 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.

--
Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net At school: kogorman_at_cs.ucsb.edu
Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org Received on Tue Dec 28 1999 - 21:17:51 CST