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)。
发现/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)。
编辑回复