Hi,

seems like creating the password file without notail and then enabling notail. Please do the following:

cd /opt/oracle/product/9ir2/dbs
mv orapwdevdb02 orapwdevdb02.notworking
cp -p orapwdevdb02.notworking orapwdevdb02

Then start your database. This should work then. Alternatively you may recreate your passwordfile with orapw.

Clemens

--- Originalnachricht ---
> 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
>

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