今天用户抱怨系统挂起了,到用户处检查发现,是TRACE文件太大,有20G了,经检查,发现TRACE文件内容中,都是一下内容:
Ioctl ASYNC_CONFIG error, errno = 1
这个问题以前遇到过,是异步IO设置的问题,特别是在HPUX系统上,而用户正好是HPUX 11.31,ORACLE 11G R2 RAC
于是这个问题,通过以下方式即可解决:
查看/etc/privgroup文件是否存在,如果不存在创建这个文件,并添加如下内容:
dba MLOCK RTSCHED RTPRIO
#分配权限给/etc/privgroup
setprivgrp -f /etc/privgroup
附 TRC文件内容:
wlsvr1b-> more timms2_ora_2202.trc
Trace file /oracle/app/oracle/diag/rdbms/timms/timms2/trace/timms2_ora_2202.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1
System name: HP-UX
Node name: wlsvr1b
Release: B.11.31
Version: U
Machine: ia64
Instance name: timms2
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 2202, image: oracle@wlsvr1b
*** 2011-04-25 08:38:39.094
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
Trace file /oracle/app/oracle/diag/rdbms/timms/timms2/trace/timms2_ora_2202.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1
System name: HP-UX
Node name: wlsvr1b
Release: B.11.31
Version: U
Machine: ia64
Instance name: timms2
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 2202, image: oracle@wlsvr1b
*** 2011-04-26 15:48:40.422
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1
Ioctl ASYNC_CONFIG error, errno = 1