Ioctl ASYNC_CONFIG error, errno = 1
来源:互联网 发布:银龙裁决淘宝 编辑:程序博客网 时间:2024/05/22 07:01
数据库一直写trc,导致磁盘空间满了。
g2bh8050:hd04ehis > more hd04ehis_ora_21902.trc
/paic/g2bh8050/soft/10g1/app/oracle/admin/hd04ehis/udump/hd04ehis_ora_21902.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Oracle Label Security, Data Mining and Real Application Testing options
ORACLE_HOME = /paic/g2bh8050/dev/xt2/app102052/oracle/product/10.2.0
System name: HP-UX
Node name: g2bh8050
Release: B.11.23
Version: U
Machine: ia64
Instance name: hd04ehis
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 21902, image: oracle@g2bh8050
Ioctl ASYNC_CONFIG error, errno = 1
看了下好像是异步IO的问题
If /dev/async is present and correctly configured, Oracle (for HP only) will use it for memory locking which is needed for async i/o for SGA memory pages via ioctl.
Oracle (for HP only) opens /dev/async successfully only if the /dev/async HP-UX device driver is properly configured for read and write.
This is irrespective of whether the DISK_ASYNCH_IO parameter is set to TRUE.
Problem is Oracle (for HP only) still uses async I/O regardless of the value of init settings
(disk_asynch_io=FALSE and filesystemio_options=none).
The parameter filesystemio_options=none doesn't work.
From the 9.2 until 10.1 version, to inactivate ASYNCH_IO with Oracle, the workaround is to:
chown bin:bin /dev/async
chmod 660 /dev/async
Note: This may impact other applications that wish to use asynch I/O.
It is recommended to shutdown Oracle database before inactivating asynch I/O.
Grant dba group the MLOCK privilege to avoid the Ioctl ASYNC_CONFIG trace file errors:
(1) # /usr/sbin/setprivgrp dba MLOCK
(2) # vi /etc/privgroup
-- This should contain dba MLOCK RTSCHED RTPRIO
(3) # cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO
Since the Oracle 10.2 version, the problem is resolved as these settings stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none
但是本人还有个疑问就是为啥同一台主机上,公用的同一套oracle软件,其他的库没有报这个错误?
如果哪位高手知道,请指点下小弟。
谢谢
- Ioctl ASYNC_CONFIG error, errno = 1
- How to Disable Asynch_io on HP to Avoid Ioctl Async_config Error Errno = 1 (文档 ID 302801.1)
- HP-UX Oracle Ioctl ASYNC_CONFIG error=1
- Ioctl ASYNC_CONFIG error故障解决
- errno EAGAIN recvfrom error
- python error: [Errno 10054]
- socket error: [Errno 10061]
- syscall error number : errno
- Suddenly error='Cannot allocate memory' (errno=12) [closed]
- error: unknown field 'ioctl' specified in initializer (1)
- mysql -error 1005 (errno:150)
- socket.error: [Errno 10061]解决方法
- urlopen error [Errno 10061]解决方法
- error: [Errno 111] Connection refused
- URLError: <urlopen error [Errno 10051] >
- error: [Errno 32] Broken pipe
- socket.error: [Errno 10013] 解决方法
- QT,error: '::ioctl' has not been declared,调用ioctl
- 正确区分v o i d 与v o i d *
- ASP.NET(WCF)操作Word的权限配置
- android分辨率详解
- JavaScript程序执行顺序
- hdu 4485 B-Casting
- Ioctl ASYNC_CONFIG error, errno = 1
- Wifi connect under command
- 为什么我们觉得微软不是很‘酷’
- jQuery Mobile页面跳转后未加载外部JS
- POJ-1068-Parencodings
- 解开VC++调用.Net DLL的神秘面纱
- Windows/Linux/Mac上清除DNS缓存的命令
- DIV的边距属性在Chrome和IE中的区别
- Sox语音转换的相关知识