Oracle Database 11g Release 2 Includes The Orion I/O Test Tool, But You Better Get That Full Path Name Right.

As Miladin Modrakovic recently pointed out, Oracle Database 11g Release 2 includes, for the first time ever, a copy of the ORacle IO Numbers (ORION) disk throughput test tool. The executable has been put into $ORACLE_HOME/bin.
This is just a quick blog entry to point out that the executable does work, but I had to file a bug since it only functions if executed with a full path name. At least that is the case on Linux, I can’t try it on Solaris.

This one goes out to the wayward Googler looking for the search terms error 27155 at location skgpchild2.

The following shows the diagnostic for why a relative path name fails and a full path name succeeds. When invoked without a full path name, the second invocation of execve(2) (called by a child thread) fails ENOENT. The last set of strace(1) output shows that the full path name is the fix.

Note, you can hover over the following box and an icon will appear that allows you to open the text in a better viewer.

 

$ uname -s -r -v -m -p -i -o
Linux 2.6.18-128.1.16.0.1.el5 #1 SMP Tue Jun 30 16:48:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
$ type orion
orion is hashed (/u01/app/oracle/product/11.2.0/dbhome_1/bin/orion)
$ orion -run normal -testname ext3 -num_disks 1
ORION: ORacle IO Numbers -- Version 11.2.0.1.0
ext3_20091106_1024
Calibration will take approximately 19 minutes.
Using a large value for -cache_size may take longer.

Error in spawning child process
Additional information: : error 27155 at location skgpchild2 - execv() - No such file or directory
orion_main: orion_spawn sml failed
Test aborted due to errors.
$
$ strace -o strace.out -f orion -run normal -testname ext3 -num_disks 1
ORION: ORacle IO Numbers -- Version 11.2.0.1.0
ext3_20091106_1025
Calibration will take approximately 19 minutes.
Using a large value for -cache_size may take longer.

Error in spawning child process
Additional information: : error 27155 at location skgpchild2 - execv() - No such file or directory
orion_main: orion_spawn sml failed
Test aborted due to errors.
$ grep execve strace.out
25824 execve("/u01/app/oracle/product/11.2.0/dbhome_1/bin/orion", ["orion", "-run", "normal", "-testname", "ext3", "-num_disks", "1"], [/* 31 vars */]) = 0
25825 execve("orion", ["orion", "_ranseq", "0", "33010150\370x%;\377\177"], [/* 34 vars */]) = -1 ENOENT (No such file or directory)
$
$ strace -o strace.out -f $ORACLE_HOME/bin/orion -run normal -testname ext3 -num_disks 1
ORION: ORacle IO Numbers -- Version 11.2.0.1.0
ext3_20091106_1026
Calibration will take approximately 19 minutes.
Using a large value for -cache_size may take longer.

$ grep execve  strace.out
26223 execve("/u01/app/oracle/product/11.2.0/dbhome_1/bin/orion", ["/u01/app/oracle/product/11.2.0/d", "-run", "normal", "-testname", "ext3", "-num_disks", "1"], [/* 31 vars */]) = 0
26224 execve("/u01/app/oracle/product/11.2.0/dbhome_1/bin/orion", ["/u01/app/oracle/product/11.2.0/d", "_ranseq", "0", "1771981131\33\351\377\177"], [/* 34 vars */]) = 0

2 Responses to “Oracle Database 11g Release 2 Includes The Orion I/O Test Tool, But You Better Get That Full Path Name Right.”


  1. 1 glennfawcett November 19, 2009 at 4:59 pm

    This seems to be a generic Oracle 11gR2 bug. I just tried this out on the latest S10 release…

    $ orion -run simple
    ORION: ORacle IO Numbers — Version 11.2.0.1.0
    orion_20091119_0853
    Calibration will take approximately 9 minutes.
    Using a large value for -cache_size may take longer.

    Error in spawning child process
    Additional information: : error 27155 at location skgpchild2 – execv() – No such file or directory
    orion_main: orion_spawn sml failed
    Test aborted due to errors.
    Segmentation Fault(coredump)

  2. 2 Andreas Piesk November 19, 2009 at 8:44 pm

    i had to file another bug (Bug 9104898: ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I/OS FAILED).

    Orion runs just fine until it comes to random large i/o:

    ran (large): VLun = 0 Size = 2914705735680
    Error completing IO
    (storax_aiowait)
    ORA-27061: waiting for async I/Os failed
    Linux-x86_64 Error: 14: Bad address
    Additional information: -1
    Additional information: 1048576
    lun_aiowait: storax_aiowait failed.
    rwbase_run_test: rwbase_reap_req failed
    rwbase_run_process: rwbase_run_test failed
    rwbase_rwluns: rwbase_run_process failed
    orion_thread_main:rwbase_rwluns failed

    Orion 11.1.0.0.0 works, Orion 11.1.0.7.0 shows the same error.

    regards,
    -ap


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,058 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

Follow

Get every new post delivered to your Inbox.

Join 2,058 other followers

%d bloggers like this: