'ASYNC_CONFIG'에 해당되는 글 1건
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.x
HP-UX Itanium
HP-UX PA-RISC (64-bit) How to disable async_io on Oracle in HP-UX to avoid this message in trace file:
Ioctl ASYNC_CONFIG error, errno = 1
Oracle (for HP only) always 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.
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.
In 9.2 version, to inactivate ASYNCH_IO with Oracle , workaround is:
chown bin:bin /dev/async
chmod 660 /dev/async
Note:
This may impact other applications that wish to use asynch I/O
Grant dba group the MLOCK priv 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, these settings stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none