Ioctl ASYNC_CONFIG error, errno = 1

数据库一直写trc，导致磁盘空间满了。

g2bh8050:hd04ehis > more hd04ehis_ora_21902.trc
/paic/g2bh8050/soft/10g1/app/oracle/admin/hd04ehis/udump/hd04ehis_ora_21902.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Oracle Label Security, Data Mining and Real Application Testing options
ORACLE_HOME = /paic/g2bh8050/dev/xt2/app102052/oracle/product/10.2.0
System name:    HP-UX
Node name:      g2bh8050
Release:        B.11.23
Version:        U
Machine:        ia64
Instance name: hd04ehis
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 21902, image: oracle@g2bh8050

Ioctl ASYNC_CONFIG error, errno = 1

 

看了下好像是异步IO的问题

If /dev/async is present and correctly configured, Oracle (for HP only) will use it for memory locking which is needed for async i/o for SGA memory pages via ioctl.

Oracle (for HP only) 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_ASYNCH_IO parameter is set to TRUE.

Problem is Oracle (for HP only) still uses async I/O regardless of the value of init settings
(disk_asynch_io=FALSE and filesystemio_options=none).
The parameter filesystemio_options=none doesn't work.

From the 9.2 until 10.1 version, to inactivate ASYNCH_IO with Oracle, the workaround is to:

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

Note: This may impact other applications that wish to use asynch I/O.
It is recommended to shutdown Oracle database before inactivating asynch I/O.

Grant dba group the MLOCK privilege to avoid the Ioctl ASYNC_CONFIG trace file errors:

(1) # /usr/sbin/setprivgrp dba MLOCK
(2) # vi /etc/privgroup
-- This should contain dba MLOCK RTSCHED RTPRIO
(3) # cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO

Since the Oracle 10.2 version, the problem is resolved as these settings stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none 

 

但是本人还有个疑问就是为啥同一台主机上，公用的同一套oracle软件，其他的库没有报这个错误？

如果哪位高手知道，请指点下小弟。

谢谢