Sunday, April 19, 2009

HP-UX Async IO

After we installed a 10.2.0.4 RAC database on an HP-UX Itanium 64-bit platform, we noticed some errors related to asynchronous IO in the database trace files. Here is the message:

Ioctl ASYNC_CONFIG error, errno = 1

After further analysis on MetaLink, and assistance from Support, we determined that asynch IO was not configured. The following are the steps that we did as root to resolve the issue:

  • created /etc/privgroup. Added the following entries in the file:
  • dba RTPRIO RTSCHED MLOCK
  • oinstall RTPRIO RTSCHED MLOCK
  • /usr/sbin/setprivgrp -f /etc/privgroup
  • getprivgrp dba
  • getprivgroup oinstall
  • cd /dev/async
  • chown oracle:dba async
  • chmod 660 async
This was an interesting issue because of the Oracle 10gR2 documentation. The Oracle Clusterware and Oracle Real Application Clusters Installation Guide for HP-UX doesn't include these procedures. However, the Administrator's Reference for UNIX-Based Operating Systems does in an appendix for HP-UX.

We just had to say "Isn't that interesting..."

No comments: