an ocfs-volume was nearly full (only 800MB free). i deleted some
datafiles to free space:
$ df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/sdp1 10G 5.3G 4.8G 53% /db/DPS
so there are more than 4GB available.
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba;
Connected.
SQL> create tablespace data_dp
datafile '/db/DPS/tablespaces/dp/data01.dbf'
size 999m autoextend on
segment space management auto;
create tablespace data_dp
*
ERROR at line 1:
ORA-01119: error in creating database file
'/db/DPS/tablespaces/dp/data01.dbf'
ORA-27044: unable to write the header block of file
Linux Error: 28: No space left on device
Additional information: 3
what could be the reason for this error? looks like ocfs doesn't free
the space from the deleted files. ocfs is mounted on 1 node only.
# fsck.ocfs -n /dev/sdp1
fsck.ocfs 1.1.2-PROD1 Fri Apr 2 14:04:10 PST 2004 (build
2df841d19c031db220f8cfb73439339d)
/dev/sdp1: clean, 282 objects, 5344/10234 blocks
what are these 282 objects? the volume contains only 26 dirs/files:
# debugocfs -l /dev/sdp1
debugocfs 1.1.2-PROD1 Fri Apr 2 14:04:05 PST 2004 (build
fcb0206676afe0fcac47a99c90de0e7b)
filelisting:
File1 = /tablespaces/
File2 = /tablespaces/vbv/
File3 = /tablespaces/undo2_01.dbf
File4 = /tablespaces/undo1_01.dbf
File5 = /tablespaces/tools01.dbf
File6 = /tablespaces/temp01.dbf
File7 = /tablespaces/system01.dbf
File8 = /tablespaces/dp/
File9 = /tablespaces/dp/idx01.dbf
File10 = /tablespaces/abo/
File11 = /spfileDPS.ora
File12 = /redologs2/
File13 = /redologs2/log6a.rdo
File14 = /redologs2/log5a.rdo
File15 = /redologs2/log4a.rdo
File16 = /redologs2/archive/
File17 = /redologs1/
File18 = /redologs1/log3a.rdo
File19 = /redologs1/log2a.rdo
File20 = /redologs1/log1a.rdo
File21 = /redologs1/archive/
File22 = /orapwDPS
File23 = /mirror/
File24 = /control02a.ctl
File25 = /control01a.ctl
File26 = /backup/
Any advices?
best,
-ap
--
Andreas Piesk
Systemadministration E-/M-Commerce
--------------------------------------------------------------
V?B-ZVD
Bank f?r Zahlungsverkehrsdienstleistungen GmbH
Godesberger Allee 88
53175 Bonn
Tel.: +49 (0) 228 9377-535
Fax: +49 (0) 228 9377-596
E-Mail: andreas.piesk@voeb-zvd.de
Internet: http://www.voeb-zvd.de
unfortuantely the space on disk needs to be contiguous when creating datafiles. so you should try to create a smaller file adn then grow it. extfinder I think is shipped as a tool that shows the chunksizes on disk available On Wed, Sep 01, 2004 at 01:14:00PM +0200, Andreas Piesk wrote:> > an ocfs-volume was nearly full (only 800MB free). i deleted some > datafiles to free space: > > $ df -h . > Filesystem Size Used Avail Use% Mounted on > /dev/sdp1 10G 5.3G 4.8G 53% /db/DPS > > so there are more than 4GB available. > > $ sqlplus /nolog > > SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> connect / as sysdba; > Connected. > SQL> create tablespace data_dp > datafile '/db/DPS/tablespaces/dp/data01.dbf' > size 999m autoextend on > segment space management auto; > create tablespace data_dp > * > ERROR at line 1: > ORA-01119: error in creating database file > '/db/DPS/tablespaces/dp/data01.dbf' > ORA-27044: unable to write the header block of file > Linux Error: 28: No space left on device > Additional information: 3 > > > what could be the reason for this error? looks like ocfs doesn't free > the space from the deleted files. ocfs is mounted on 1 node only. > > # fsck.ocfs -n /dev/sdp1 > fsck.ocfs 1.1.2-PROD1 Fri Apr 2 14:04:10 PST 2004 (build > 2df841d19c031db220f8cfb73439339d) > /dev/sdp1: clean, 282 objects, 5344/10234 blocks > > what are these 282 objects? the volume contains only 26 dirs/files: > > # debugocfs -l /dev/sdp1 > debugocfs 1.1.2-PROD1 Fri Apr 2 14:04:05 PST 2004 (build > fcb0206676afe0fcac47a99c90de0e7b) > filelisting: > File1 = /tablespaces/ > File2 = /tablespaces/vbv/ > File3 = /tablespaces/undo2_01.dbf > File4 = /tablespaces/undo1_01.dbf > File5 = /tablespaces/tools01.dbf > File6 = /tablespaces/temp01.dbf > File7 = /tablespaces/system01.dbf > File8 = /tablespaces/dp/ > File9 = /tablespaces/dp/idx01.dbf > File10 = /tablespaces/abo/ > File11 = /spfileDPS.ora > File12 = /redologs2/ > File13 = /redologs2/log6a.rdo > File14 = /redologs2/log5a.rdo > File15 = /redologs2/log4a.rdo > File16 = /redologs2/archive/ > File17 = /redologs1/ > File18 = /redologs1/log3a.rdo > File19 = /redologs1/log2a.rdo > File20 = /redologs1/log1a.rdo > File21 = /redologs1/archive/ > File22 = /orapwDPS > File23 = /mirror/ > File24 = /control02a.ctl > File25 = /control01a.ctl > File26 = /backup/ > > > Any advices? > > > best, > > -ap > > -- > Andreas Piesk > Systemadministration E-/M-Commerce > -------------------------------------------------------------- > V?B-ZVD > Bank f?r Zahlungsverkehrsdienstleistungen GmbH > Godesberger Allee 88 > > 53175 Bonn > > Tel.: +49 (0) 228 9377-535 > Fax: +49 (0) 228 9377-596 > E-Mail: andreas.piesk@voeb-zvd.de > Internet: http://www.voeb-zvd.de > _______________________________________________ > Ocfs-users mailing list > Ocfs-users@oss.oracle.com > http://oss.oracle.com/mailman/listinfo/ocfs-users
Run, ocfsextfinder /dev/sdp1 and post the results. On Wed, 2004-09-01 at 04:14, Andreas Piesk wrote:> an ocfs-volume was nearly full (only 800MB free). i deleted some > datafiles to free space: > > $ df -h . > Filesystem Size Used Avail Use% Mounted on > /dev/sdp1 10G 5.3G 4.8G 53% /db/DPS > > so there are more than 4GB available. > > $ sqlplus /nolog > > SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> connect / as sysdba; > Connected. > SQL> create tablespace data_dp > datafile '/db/DPS/tablespaces/dp/data01.dbf' > size 999m autoextend on > segment space management auto; > create tablespace data_dp > * > ERROR at line 1: > ORA-01119: error in creating database file > '/db/DPS/tablespaces/dp/data01.dbf' > ORA-27044: unable to write the header block of file > Linux Error: 28: No space left on device > Additional information: 3 > > > what could be the reason for this error? looks like ocfs doesn't free > the space from the deleted files. ocfs is mounted on 1 node only. > > # fsck.ocfs -n /dev/sdp1 > fsck.ocfs 1.1.2-PROD1 Fri Apr 2 14:04:10 PST 2004 (build > 2df841d19c031db220f8cfb73439339d) > /dev/sdp1: clean, 282 objects, 5344/10234 blocks > > what are these 282 objects? the volume contains only 26 dirs/files: > > # debugocfs -l /dev/sdp1 > debugocfs 1.1.2-PROD1 Fri Apr 2 14:04:05 PST 2004 (build > fcb0206676afe0fcac47a99c90de0e7b) > filelisting: > File1 = /tablespaces/ > File2 = /tablespaces/vbv/ > File3 = /tablespaces/undo2_01.dbf > File4 = /tablespaces/undo1_01.dbf > File5 = /tablespaces/tools01.dbf > File6 = /tablespaces/temp01.dbf > File7 = /tablespaces/system01.dbf > File8 = /tablespaces/dp/ > File9 = /tablespaces/dp/idx01.dbf > File10 = /tablespaces/abo/ > File11 = /spfileDPS.ora > File12 = /redologs2/ > File13 = /redologs2/log6a.rdo > File14 = /redologs2/log5a.rdo > File15 = /redologs2/log4a.rdo > File16 = /redologs2/archive/ > File17 = /redologs1/ > File18 = /redologs1/log3a.rdo > File19 = /redologs1/log2a.rdo > File20 = /redologs1/log1a.rdo > File21 = /redologs1/archive/ > File22 = /orapwDPS > File23 = /mirror/ > File24 = /control02a.ctl > File25 = /control01a.ctl > File26 = /backup/ > > > Any advices? > > > best, > > -ap