dbi services Blog
Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Bug on Oracle 11.2 "ORION FAILS WITH ORA-27061": Patch available!
In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle 11.2, reported in Oracle bug number 9104898: "ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED".
Trying to compare performances of storage devices on a virtual machine between a classical and a paravirtual storage adapter, I experienced the same error when using large IOs. I was using a Red Hat 5 based environment, which seems to be especially concerned by this problem:
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 14:
Bad addressAdditional information: -1
Additional information: 1048576
Test aborted due to errors.
If you have already faced the problem too, there is good news! Oracle finally published a patch in November 2012 to fix this problem, reported in January ... 2009!!! The patch is available for Oracle RDBMS 126.96.36.199 and 188.8.131.52. You can download it at My Oracle Support website, searching for Patch 9104898 or Patch ID 15597001.
It works fine for me now.
Don't forget to download the last version of OPatch (6880880 in My Oracle Support) before applying this patch, as recommanded by Oracle.