ORACLE系统出现大量的TRC文件解决一例

  • Post author:
  • Post category:其他



今天用户抱怨系统挂起了,到用户处检查发现,是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