O-direct on ext3 file ssytem

[david x chan]

Hi I am back ... with more questions.   I am currently running oracle 
9205 with
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 i686
>>>      
>>>
>>2.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 mailing list
>Ext3-users at redhat.com
>https://www.redhat.com/mailman/listinfo/ext3-users
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/ext3-users/attachments/20040714/78b9fed7/attachment.htm>