Oracle 异步io过错ITeyedongfang - 凯发娱乐

Oracle 异步io过错ITeyedongfang

2018-10-24 09:08:13 | 作者: 盼曼 | 标签: 文件,体系,权限 | 浏览: 5330

客户一数据库alert日志继续报以下过错
引证LNS: Standby redo logfile selected for thread 1 sequence 4060 for destination LOG_ARCHIVE_DEST_2
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
Thu Apr 22 06:49:04 2010
Errors in file /oracle/admin/archive/udump/archive_ora_5657.trc:
盯梢文件显现
引证/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440

Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440

Ioctl ASYNC_CONFIG error, errno = 1
/oracle/admin/archive/udump/archive_ora_25053.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rp4440
Release: B.11.23
Version: U
Machine: 9000/800
Instance name: archive
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25053, image: oracle@rp4440

Ioctl ASYNC_CONFIG error, errno = 1
从盯梢文件能够根本定位为体系异步IO出现问题
操作体系:HP-UX B.11.23
数据库库版别为:10.2.0.1
过错为:Ioctl ASYNC_CONFIG error, errno = 1
进一步确诊:
查看HP-UX异步IO文件,能够看到Oracle具有读写权限
引证# ls -l /dev/async
crw-rw-rw-  1 bin  bin  101 0x000000 Nov  7  2007 /dev/async
在HP-UX平台下假如Oracle数据文件存放在文件体系中,咱们强烈主张不能运用异步IO,能够经过添加dbwr进程来进步写速度,需求留意的是修正其权限可能会影响到其他应用软件运用异步io,而且主张修正之前封闭Oracle
引证# chmod 660 /dev/async
查看体系参数
引证# kctune|grep fs_async
fs_async  0  Default 
查看Oracle参数文件
引证SQL show parameter disk_async

NAME  TYPE  VALUE
-
disk_asynch_io  boolean  TRUE
SQL show parameter filesystem

NAME  TYPE  VALUE
-
filesystemio_options  string  asynch
将参数修正为
disk_asynch_io=FALSE
filesystemio_options=none

为了防止Ioctl ASYNC_CONFIG过错,给dba组赋MLOCK权限
引证#/usr/sbin/setprivgrp dba MLOCK
# cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO
参考文献:metalink 302801.1
版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表凯发娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章

阅读排行

  • 1
  • 2
  • 3
  • 4

    union联合查询guojizaixian

    成果,数据,排序
  • 5

    TIME快报

    效劳,状况,修正
  • 6

    SQL试题环球

    用户,时刻,信息
  • 7
  • 8
  • 9

    asdfasdfITeye头条

    用户,权限,指令
  • 10

    SQL一招ITeyesohu

    字符串,标题,检索