- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-27061 : waiting for async I/Os failed
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 01:34 AM
тАО07-24-2008 01:34 AM
We have a small batch cycle that sometimes fails ( a rerun mostly finishes ok ) with an error : " ORA-27061 : waiting for async I/Os failed "
Cycle runs on a itanium / HPUX 11.23 :
root/svuxpc11#model
ia64 hp server rx4640
root/svuxpc11#uname -a
HP-UX svuxpc11 B.11.23 U ia64 1465226551 unlimited-user license
Any suggestestions ?
Tx ...
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 01:46 AM
тАО07-24-2008 01:46 AM
Re: ORA-27061 : waiting for async I/Os failed
We get to guess the version of Oracle here I suppose.
Since it works some of the time and not others, I would say that it falls into one of the following categories:
OS problem with async I/O needs to be resolved with an OS patch
I/O is overloaded and the process is not getting an answer fast enough.
Oracle problem needs to be resolved by installing an oracle patch.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 01:56 AM
тАО07-24-2008 01:56 AM
Re: ORA-27061 : waiting for async I/Os failed
9.2.0.7.0 is the oracle_version.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 05:58 AM
тАО07-24-2008 05:58 AM
SolutionI suspect it is running into a maximum number of async IOs and either OS or DB not handling that correctly.
Seems Oracle failed to recognize that an issues of an IO async failed. Then later when it tries to wait for the IO to be done, that fails because it was never started.
Slightly different DB loads an IO response times could make it run into this, or stay clear.
Did you recently increase the SGA? That might allow for more IOs to be queued.
It would be best if you could throttle the DB, but I suspect that the easiest workaround is to increase the maximum number of async IOs the OS can handle.
See man mage for aio_max_ops.
http://docs.hp.com/en/B2355-60105/aio_max_ops.5.html
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2008 11:56 AM
тАО07-24-2008 11:56 AM
Re: ORA-27061 : waiting for async I/Os failed
as an interim solution you could disable async I/O. set DISK_ASYNC_IO to false
regards