Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9.2: Ioctl ASYNC_CONFIG error

SOLVED
Go to solution
Claudio Cilloni
Honored Contributor

Oracle 9.2: Ioctl ASYNC_CONFIG error

Hi all.

I realized that my /oracle/rdbms/log/ directory
contains 30.000 *.trc files, produced by 4 instances running in the last 3 months.
all these files seem to contain something
like this:

----------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /oracle
System name: HP-UX
Node name: dbsermm
Release: B.11.22
Version: U
Machine: ia64
Instance name: oa
Redo thread mounted by this instance: 0
Oracle process number: 0
7092

Ioctl ASYNC_CONFIG error, errno = 1
-------------------------------------------

All these instances are working really well.
What kind of trouble are these trace files trying to tell me?

Oracle 9.2.0.2, HP-UX 11.22, Itanium.

Thanks for yor help!

Claudio
4 REPLIES
Robert-Jan Goossens
Honored Contributor

Re: Oracle 9.2: Ioctl ASYNC_CONFIG error

Hi Claudio,

http://www.cs.nott.ac.uk/TSG/manuals/databases/oracle/standard/a90347/appb_hp.htm

Note:
If the Oracle software owner does not have the MLOCK privilege, Oracle9i on HP-UX generates trace files that include the following error:

Ioctl ASYNC_CONFIG error, errno = 1

Hope it helps,

Robert-Jan.
Hari Kumar
Trusted Contributor
Solution

Re: Oracle 9.2: Ioctl ASYNC_CONFIG error

If you are using RAW disk partitions for you Database, The following from Administrator Reference Guide from Oracle ----------

The asynchronous I/O pseudo-driver on HP allows the Oracle server to perform I/O to raw disk partitions using an asynchronous method, resulting in less I/O overhead and higher throughput. You can use the asynchronous I/O pseudo-driver on both HP-UX 9000 servers and workstations.

MLOCK Privilege
To allow Oracle9i to execute asynchronous I/O operations, the group that the Oracle software owner belongs to (dba) must have the MLOCK privilege. To give the dba group the MLOCK privilege:

As the root user, enter the following command:

# setprivgrp dba MLOCK


To retain the MLOCK privilege after rebooting, create the /etc/privgroup file, if it does not exist on your system, and add the following line to it:

dba MLOCK



--------------------------------------------------------------------------------
Note:
If the Oracle software owner does not have the MLOCK privilege, Oracle9i on HP-UX generates trace files that include the following error:

Ioctl ASYNC_CONFIG error, errno = 1

--------------------------------------------------------------------------------


Information is Wealth ; Knowledge is Power
Hari Kumar
Trusted Contributor

Re: Oracle 9.2: Ioctl ASYNC_CONFIG error

The documentation available at -------
http://otn.oracle.com/documentation/index.html

The Part Number A90347-01
In that Go for HP specific pages

Thanks
Information is Wealth ; Knowledge is Power
Yogeeraj_1
Honored Contributor

Re: Oracle 9.2: Ioctl ASYNC_CONFIG error

hi,
*
According to metalink, to fix the problem, you'll need to grant oracle owner privileges to lock memory pages. This is done with the command:
*
# setprivgrp dba MLOCK
*
After this, no more trace files are generated.
*
Hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)