HPUX Oracle Ioctl ASYNC_CONFIG error, errno = 1

今天发现一台Report DB（HPUX）的$ORACLE_HOME/rdbms/log有非常多的tracefile，

/rptdata/app/oracle/product/920/rdbms/log/e4crpt_ora_27637.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /rptdata/app/oracle/product/920
System name: HP-UX
Node name: e4cepd03
Release: B.11.23
Version: U
Machine: ia64
Instance name: e4crpt
Redo thread mounted by this instance: 0
Oracle process number: 0
27637

Ioctl ASYNC_CONFIG error, errno = 1

FIX

Oracle(for HP only) always uses async I/O regardless of the value of init
(disk_asynch_io).
That's why this parameter filesystemio_options=none doesn't work.

Oracle always opens /dev/async successfully only if the /dev/async HP-UX
device driver is properly configured for read and write. This is irrespective
of whether the DISK_ASYNC_IO parm is set to TRUE.

So to unactivate ASYNCH_IO with Oracle , workaround could be:

chown bin:bin /dev/async
chmod 660 /dev/async

dba group has MLOCK priv

References

Metalink：Note:302801.1 How to disable asynch_io on HP to avoid Ioctl Async_config Error Errno = 1

在网上还发现另外一种解法(未尝试)

1、创建/etc/privgroup文件,内容为：
dba MLOCK
2、执行命令/usr/sbin/setprivgrp -f /etc/privgroup
3、执行完毕，再用sqlplus登陆发现没有再生成上述的trace文件。

解释：因为ASYNC io的配置没有完成，所以每执行一次sqlplus登陆到数据库便会产生这样一个trace文件。

参考：http://blog.itpub.net/post/3701/16129

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/87949/viewspace-813508/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/87949/viewspace-813508/