Ioctl ASYNC_CONFIG error, errno = 1 (HP-UX)

dbtut September 7, 2018 ORACLE

You can encounter this problem on HP-UX platforms.

Many trace files are being created with the error “Ioctl ASYNC_CONFIG error, errno = 1”.

Disabling ASYNCH_IO in Oracle 9.2 databases:

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

1 2	$ chown bin:bin /dev/async $ chmod 660 /dev/async

This change will also affect other applications that use asynchronous I / O.

Get MLOCK privilege for the dba group.

$ /usr/sbin/setprivgrp dba  MLOCK
$ vi /etc/privgroup

1 2	$ /usr/sbin/setprivgrp dba MLOCK $ vi /etc/privgroup

Add the following line.

dba MLOCK RTSCHED RTPRIO

1	dba MLOCK RTSCHED RTPRIO

$ cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO

1 2	$ cat /etc/privgroup dba MLOCK RTSCHED RTPRIO

Following Oracle 10.2, the following parameters will also prevent the error.

disk_asynch_io=FALSE
filesystemio_options=none

1 2	disk_asynch_io=FALSE filesystemio_options=none

This error will not happen again when you turn the database off and on.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux