Hello,
I have an issue with enabling directio on 9.2.0.8 running on SLES 9SP3. It is running fine with filesystemio_options=asynch. The notail option was added to fstab after enabling directio (setall). The database was created without it with no asyncio or directio. I'm experiencing the same problem on an other machine too.


My fstab looks as follows:
oracle@(protected)
/dev/hda1        /             reiserfs  acl,user_xattr,notail     1 1
/dev/hdb1        /u01           reiserfs  acl,user_xattr,notail     1 2
/dev/hdd2        /u02           reiserfs  acl,user_xattr,notail     1 2
/dev/hdd1        swap           swap     pri=42           0 0
devpts          /dev/pts         devpts   mode=0620,gid=5     0 0
proc           /proc           proc     defaults         0 0
usbfs           /proc/bus/usb     usbfs    noauto           0 0
sysfs           /sys           sysfs    noauto           0 0
/dev/cdrom       /media/cdrom      subfs    fs=cdfss,ro,procuid,nosuid,nodev,exec,fs=cdfss,procuid,nosuid,nodev,fs=cdfss,procuid,nosuid,nodev,iocharset=utf8 0 0
oracle@(protected):~>

Here is what happens when I try to enable directio:
oracle@(protected)"
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jan 11 11:07:06 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area  97587796 bytes
Fixed Size             451156 bytes
Variable Size         58720256 bytes
Database Buffers       37748736 bytes
Redo Buffers           667648 bytes
Database mounted.
Database opened.
SQL> alter system set filesystemio_options=SETALL scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  97587796 bytes
Fixed Size             451156 bytes
Variable Size         58720256 bytes
Database Buffers       37748736 bytes
Redo Buffers           667648 bytes
ORA-01995: error reading password file
'/opt/oracle/product/9ir2/dbs/orapwdevdb02'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 22: Invalid argument
Additional information: 1


SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
oracle@(protected)
/opt/oracle/product/9ir2/dbs/orapwdevdb02
oracle@(protected)
-rwSr----- 1 oracle oinstall 1536 2007-01-04 15:25 /opt/oracle/product/9ir2/dbs/orapwdevdb02
oracle@(protected):~>

Thank you for any hints,
Radovan

--
Radovan Bičiště
Provozní programátor, Správa datového centra
STAPRO s. r. o.
Pernštýnské nám. 51, 530 02 Pardubice

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting