Largefiles, Oracle, Veritas, Solaris & D1000
Date: Thu, 22 Nov 2001 12:56:13 GMT
Message-ID: <NB6L7.34120$xS6.58616_at_www.newsranger.com>
Sol8 (07/01), E420 + 2 x D1000, Veritas Volume Manager 3.1, Veritras File
System, Oracle 8.1.6.1 (64 bit).
O/S is 64 bit (confirmed).
The above situation has 2 D1000s with 8 drives in each (5x36G, 3x18G). 2nd
D1000 mirrors the 1st. 2 x 36 Gb striped for /u04 (500 Mb) and /u10 (53500 Mb),
2 x 36 Gb striped for /u11 (54000Mb), 1 x 36 Gb hotspare, the 3 x 18 Gb drives
each /u02, /u03 and /u05 (18 Gb each) respectively.
mkfs -m /dev/vx/rdsk/datadg/u10 gives
mkfs -F vxfs -o ninode=unlimited, bsize=8192, version=4, inosize=256,
logsize=128 largefiles /dev/vx/rdsk/datadg/u10 141019776
mkfs -m /dev/vx/rdsk/datadg/u11 gives
mkfs -F vxfs -o ninode=unlimited, bsize=8192, version=4, inosize=256,
logsize=128 largefiles /dev/vx/rdsk/datadg/u11 142248576
/etc/vfstab includes
/dev/vx/dsk/datadg/u10 /dev/vx/rdsk/datadg/u10 /u10 vxfs 2 yes
convosync=direct,mincache=direct,largefiles
/dev/vx/dsk/datadg/u10 /dev/vx/rdsk/datadg/u10 /u10 vxfs 2 yes
convosync=direct,mincache=direct,largefiles
Ostensibly then, both /u10 and /u11 have largefiles "turned on". However, when our oracle DBA tried to create a 50Gb file ('cos he doesn;t want to conficure it with 25x2Gb files!) he gets a warning about file size too large and that it is limited to 2Gb!
Anybody any ideas what we've done wrong?
Incidentally, a "sister" box (E220 with 1x A1000 (4x36Gb disks), hardware RAID
controlled, 2x36 Gb mirrored) has 2x36Gb disks striped (h/w raid) for /u02
200Mb, /u03 200 Mb, /u04 500 Mb, /u10 9000Mb and /u11 9000Mb. The same DBA
(same s/w situation) can create the required files he wants (in excess of 2GB).
The differences are the h/w (2xD1000 v 1xA1000) and the RAID (s/w via VXVM and h/w via raid controller).
Didds Received on Thu Nov 22 2001 - 13:56:13 CET