ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error (Doc ID 559697.1)
ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error (Doc ID 559697.1)
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 and laterIBM AIX on POWER Systems (64-bit)
***Checked for relevance on 16-Feb-2011***
IBM AIX Based Systems (64-bit)
Symptoms
After patching the OS with Patch IBM Technology Level 6 (5300-06) or Level 7 (5300-07), the application log started reporting the following errors:
ORA-01115: IO error reading block from file <file id> (block # <block number>)
ORA-01110: data file <file id>: <file name>
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
- The errors are not reported in the alert log file.
- Running dbv against datafiles from the error messages shows no errors.
- All the mandatory OS patches are applied.
- Oracle patch for - IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05) was installed before patching the OS.
Changes
Patch IBM Technology Level 6 (5300-06) or higher was applied to the OS.
Cause
The value of maxreqs (4096) was too low. This asynchronous I/O parameter specifies the maximum number of asynchronous I/O requests that can be outstanding at any one time and has as default value 4096.
Solution
Increase maxreqs to a value greater than or equal to 8192.
Steps:
1. run aioo -a command to double check current setting for aio0 device
2. run aioo -o maxreqs=<value> to set maxreqs dynamically
3. chdev -l aio0 -a maxreqs=<value> -P to set the value of maxreqs permanently for next reboot
4. run aioo -a to confirm change
5. restart oracle
NOTE: Values that fixed the errors: 8192, 16384 or 32768.
References
- IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5 (5300-05)NOTE:390656.1 - IO Interoperability Issue between IBM ML05 and Oracle Databases
NOTE:395375.1 - Opatch Fails With Error Code 73 and 'ar: 0707-126' When Applying Interim Patch 5496862
NOTE:418105.1 - Is Patch 5496862 Mandatory for 10.2.0.3?
NOTE:430697.1 - 'Warning: lio_listio returned EAGAIN' On ASM
NOTE:443944.1 - Is Patch 5496862 applicable on AIX 5.3 TL 06 and higher AIX 5.3 TL's ?
NOTE:5496862.8 - Bug 5496862 - AIX: Mandatory patch to use Oracle with IBM Technology Level 5 (5300-5)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-2051536/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 ErrorIBMAIError
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 on AIX 5LAI
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 問題解決方法
- [ERROR] Slave I/O: Replication event checksum Error_code: 1743Error
- sloaris 出現“mount: I/O error”錯誤Error
- HP-UX: Asynchronous i/o (Doc ID 139272.1)UX
- MySQL [ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_eventMySqlError
- Asynchronous I/O Support On Windows (Doc ID 1228845.1)Windows
- Could Not Save Service Alias: TNS-04415 : File I/O Error [ID 798206.1]Error
- InnoDB: Error: space id and page n:o stored in the page?Error
- 執行SQL發生錯誤!錯誤:disk I/O errorSQLError
- mount error(5): Input/output errorError
- I/O Tuning with Different RAID Configurations (Doc ID 30286.1)AI
- org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.SQLExceptionErrorWhile
- [ERROR]SlaveI/O:errorconnectingtomasterErrorAST
- How To Check if Asynchronous I/O is Working On Linux (Doc ID 237299.1)Linux
- yarn add @fortawesome/Font Awesome-free 之後 報錯 EIO: i/o errorYarnError
- 安裝GRID時跑root.sh指令碼報錯(ORA-27091: unable to queue I/O)指令碼
- SQL error 2812: Could not find stored procedure.docSQLError
- Rman Backup Failed With Error Rman-00600 [8201] (Doc ID 412786.1)AIError
- Step by Step Troubleshooting Guide for TDE Error ORA-28374 (Doc ID 1541818.1)GUIIDEError
- Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5LAI
- PBOOTCMS網站程式提示“執行SQL發生錯誤!錯誤:DISK I/O ERROR”boot網站SQLError
- Glide error 求解IDEError
- Install Error : ERROR:SQLException null Resultset [ID 875002.1]ErrorSQLExceptionNull
- ORACLE ORA-01110: ORA-27072: 處理Oracle
- Error bpbrm (pid=909384) client restore EXIT STATUS 5ErrorclientREST
- O/S-Error: (OS 33) The process cannot access the fileError
- Angular 錯誤訊息:ERROR Error NullInjectorError No provider for XXAngularErrorNullIDE
- Error: Invoke-customs are only supported starting with Android O (--min-api 26)ErrorAndroidAPI
- Linux下的5種I/O模型與3組I/O複用Linux模型
- 通俗易懂解釋一類和二類錯誤(Type I Error Type II Error)Error
- [Modules/zlibmodule.o] Error 1錯誤解決IBMError
- error ntcontab.o of makefile ins_net_client.mkErrorclient
- NON-RAC Database Startup Giving Error ORA-29702 (Doc ID 433310.1)DatabaseError
- ORACLE OMS啟動失敗之BEA-300040 I/O error while writing node manager statusOracleErrorWhile
- ServeRAID disk drive error recoveryServerAIError
- ERROR: NMO not setuid-rootErrorUI