patches 3016968 (async io fix) & 2448994_9205 (direct io fix). All my data files
are residing on an ext3 file system.
/dev/tpccvg/tpcc_disks on /tpcc_disks type ext3 (rw)
/dev/tpccvg/log1_1 on /log1_1 type ext3 (rw)
/dev/tpccvg/log2_1 on /log2_1 type ext3 (rw)
/dev/tpccvg/log3_1 on /log3_1 type ext3 (rw)
/dev/tpccvg/log4_1 on /log4_1 type ext3 (rw)
/dev/tpccvg/log5_1 on /log5_1 type ext3 (rw)
/dev/tpccvg/log6_1 on /log6_1 type ext3 (rw)
/dev/tpccvg/log7_1 on /log7_1 type ext3 (rw)
/dev/tpccvg/log8_1 on /log8_1 type ext3 (rw)
Whenever I tried to start up oracle with 'filesystemio_options=directio', it failed
to mount the dbase due to problem writing to the control file:
LCK0 started with pid=16
Wed Jul 14 13:12:57 2004
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/tpcc_disks/control_001'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 22: Invalid argument
Additional information: 1
if I do a trace on the process, it shown that oracle is doing the correct things by
open the file with O_DIRECT flag:
5997 <... rt_sigprocmask resumed> NULL, 8) = 0
5990 open("/tpcc_disks/control_001", O_RDONLY|O_DIRECT|O_LARGEFILE <unfinished ...>
5997 semop(3342337, 0xbfff5108, 1 <unfinished ...>
is there any thing that I need to do for ext3 in order for O_DIRECT to work??? Am I missing some
library files on the OS kernel level? MAny thanks in advance for your time.
Regards,
David
Stephen C. Tweedie wrote:
Hi, On Fri, 2004-07-09 at 13:22, Marc-Christian Petersen wrote:ext3 supports direct i/o, but not in 2.4 mainline. It was added in 2.6.my system is running : Red Hat Enterprise Linux AS release 3 (Taroon Update 2) Kernel 2.4.21-15.ELsmp on an i6862.4-aa, 2.4-suse, 2.4-wolk tree and some others have it, 2.4-rh kernels do not have it.2.4 RHL kernels did not; RHEL 3 does, so 2.4.21-15.EL will have it. --Stephen _______________________________________________ Ext3-users@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/ext3-users
_______________________________________________ Ext3-users@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/ext3-users
