Oracle has trouble with big files on Linux???

From: <karipid_at_my-deja.com>
Date: Tue, 28 Dec 1999 17:27:35 GMT
Message-ID: <84arg8$72p$1@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 - 11:27:35 CST