Ioctl ASYNC_CONFIG error, errno = 1

回复 收藏
OS:HP UX

发现/oracle/BIP/saptrace/background目录中,有大量的trace文件
> cat bip_smon_9812.trc
/oracle/BIP/saptrace/background/bip_smon_9812.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/BIP/102_64
System name:        HP-UX
Node name:        sapbip01
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: BIP
Redo thread mounted by this instance: 0
Oracle process number: 0
Unix process pid: 9812, image: oracle@sapbip01

Ioctl ASYNC_CONFIG error, errno = 1

查看发现文件里面均报错:Ioctl ASYNC_CONFIG error, errno = 1
解决办法:http://forums1.itrc.hp.com/servi ... 1090237618+28353475


As the root user, enter the following command:

# /usr/sbin/setprivgrp dba MLOCK
# vi /etc/privgroup
This should contain dba MLOCK RTSCHED RTPRIO
# cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO


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

解释:
hp平台的Oracle数据库总是使用异步IO而忽略disk_asynch_io和filesystemio_options初始化参数。
异步IO比同步IO的性能好,也会写缓冲区,这样也带来了安全性问题!   
direct IO(hp ux) 跨过了文件系统层,性能更优。(如果使用裸设备实现,这个就增加了因表空间增长而带来的扩文件系统文件)即AIX的 (CIO)。
2009-12-23 14:29 举报
已邀请:
0

slpyj

赞同来自:

,刻章请加QQ:599746566,货到付款。

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: