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!

Home
Home This is where you can find all the blog posts throughout the site.
Categories
Categories Displays a list of categories from this blog.
Tags
Tags Displays a list of tags that has been used in the blog.
Bloggers
Bloggers Search for your favorite blogger from this site.

Posted by Michael Schwalm on Monday, 04 February 2013 in Development & Performance

Hits: 472
0 Comments
Subscribe to this entry
Print
PDF

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:

Error completing IO(storax_aiowait) 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 11.2.0.2 and 11.2.0.3. 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.

Tagged in: I/O Oracle 11g Storage Troubleshooting

Rate this blog entry:

Configuration des options en Oracle 11g EE avec 'c...
SQL Server View problem in LightSwitch 2012

How to avoid strange figures in the Oracle optimizer system statistics - Development & Performance Jan 03
Oracle Cluster 11g R2 listener down - que faire ? - Operating System & Cluster Dec 22
Monitoring 11g databases with Grid Control 10.2.0.5 - Database Administration & Monitoring Dec 08
Oracle Basics (2) - Data Storage - Storage, Virtualization & Cloud Jan 31
Simulating database-like I/O activity with Flexible I/O - Development & Performance Mar 10

Michael Schwalm

Michael Schwalm is Consultant at dbi Services and has more than two years of experience in Oracle database administration. He has a broad knowledge in the realization of virtualization infrastructures such as vMware vSphere. He took his first steps in database administration as an integrator of a web applications on Unix, Oracle, and Websphere environments. Michael Schwalm is Oracle Certified Associate 11g. Prior to joining dbi services, Michael Schwalm was application administrator at SOGETI Est (F) on behalf of PSA Peugeot Citroen and responsible for the realization and managing of Unix environments and Oracle databases in the context of migration projects. Michael Schwalm holds a BTS diploma in Information System Management from Belfort (F) and a TSAR diploma in advanced network administration from Strasbourg (F). His branch-related experience covers Automotive, Software industry, Financial Services / Banking, etc.

http://www.dbi-services.com/Blog