ITPub博客

首页 > 数据库 > Oracle > HPUX Oracle Ioctl ASYNC_CONFIG error, errno = 1

HPUX Oracle Ioctl ASYNC_CONFIG error, errno = 1

原创 Oracle 作者:kingprise 时间:2006-01-19 18:15:42 0 删除 编辑

今天发现一台Report DB(HPUX)的$ORACLE_HOME/rdbms/log有非常多的tracefile,

/rptdata/app/oracle/product/920/rdbms/log/e4crpt_ora_27637.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /rptdata/app/oracle/product/920
System name: HP-UX
Node name: e4cepd03
Release: B.11.23
Version: U
Machine: ia64
Instance name: e4crpt
Redo thread mounted by this instance: 0
Oracle process number: 0
27637

Ioctl ASYNC_CONFIG error, errno = 1

FIX

Oracle(for HP only) always uses async I/O regardless of the value of init
(disk_asynch_io).
That's why this parameter filesystemio_options=none doesn't work.

Oracle always 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_ASYNC_IO parm is set to TRUE.

So to unactivate ASYNCH_IO with Oracle , workaround could be:

chown bin:bin /dev/async
chmod 660 /dev/async


dba group has MLOCK priv

References

Metalink:Note:302801.1 How to disable asynch_io on HP to avoid Ioctl Async_config Error Errno = 1

在网上还发现另外一种解法(未尝试)

1、创建/etc/privgroup文件,内容为:
dba MLOCK
2、执行命令/usr/sbin/setprivgrp -f /etc/privgroup
3、执行完毕,再用sqlplus登陆发现没有再生成上述的trace文件。

解释:因为ASYNC io的配置没有完成,所以每执行一次sqlplus登陆到数据库便会产生这样一个trace文件。

参考:http://blog.itpub.net/post/3701/16129

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/87949/viewspace-813508/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 常用指令
请登录后发表评论 登录
全部评论
  • 博文量
    6
  • 访问量
    209553