Oracle-L: Patch 3186847 does not work for Ext3 filesystem.

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Thu, 23 Oct 2003 20:14:25 -0800
Message-ID: <F001.005D4244.20031023201425@fatcity.com>

Patch for Oracle on linux which is supposed to enable directio on Ext2 filesystem does not work on Ext3.
Here is my configuration:

     Linux medo.adelphia.net 2.4.22 (RH 8.0, Ximian GNOME2, latest kernel)
     glibc-2.3.2-4.80.6

Oracle:
SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

SQL>
Here is what happens:

ALTER SYSTEM SET filesystemio_options='DIRECTIO' SCOPE=SPFILE; Thu Oct 23 22:49:51 2003
Shutting down instance: further logons disabled Shutting down instance (immediate)
.......
ALTER DATABASE MOUNT
Thu Oct 23 22:50:03 2003

ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/data/oradata/ctl/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error

Linux Error: 22: Invalid argument

Direct I/O works on IBM JFS. It doesn't work on Ext3, not even with the patch applied.
--

Mladen Gogala
Oracle DBA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mladen Gogala
INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 23 2003 - 23:14:25 CDT