ORA-01995 after enabling directio (setall) on Oracle 9.2.0.8 on SL 2007-01-11 - By Bi
iat Radovan
Back
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):~> cat /etc/fstab
/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 priB 0 0
devpts /dev/pts devpts mode20,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?fss,ro,procuid,nosuid
,nodev,exec,fs?fss,procuid,nosuid,nodev,fs?fss,procuid,nosuid,nodev,iocharset
=utf8 0 0
oracle@(protected):~>
Here is what happens when I try to enable directio:
oracle@(protected):~> sqlplus "/ as sysdba"
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 (See http://ORA-01995.ora-code.com): error reading password file
'/opt/oracle/product/9ir2/dbs/orapwdevdb02'
ORA-27091 (See http://ORA-27091.ora-code.com): skgfqio: unable to queue I/O
ORA-27072 (See http://ORA-27072.ora-code.com): 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):~> ls /opt/oracle/product/9ir2/dbs/orapwdevdb02
/opt/oracle/product/9ir2/dbs/orapwdevdb02
oracle@(protected):~> ls -l /opt/oracle/product/9ir2/dbs/orapwdevdb02
-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
|
|
