Oracle提供了一个免费的测试系统存储系统性能的工具:orion。
这里描述使用orion常见的问题。
ORION工具(一):http://yangtingkun.itpub.net/post/468/489322
别看orion的操作这么简单,但是使用过程中,还真是碰到了不少的错误。
root@ser1 # ./orion_solaris_sparc64 -run simple -testname mytest
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20090812_1028
Test will take approximately 9 minutes
Larger caches may take longer
storax_skgfr_openfiles: File identification failed on /dev/dsk/emcpower6a
OER 27037: please look up error in Oracle documentation
Additional information: 5
rwbase_lio_init_luns: lun_openvols failed
rwbase_rwluns: rwbase_lio_init_luns failed
orion_thread_main: rw_luns failed
Non test error occurred
Orion exiting
这是最先碰到的错误,这时指定的/dev/dsk/emcpower6a是目录/data所挂载的磁盘,如果检查对应的ora-27037错误会发现:
ORA-27037: unable to obtain file status
Cause: stat system call returned an error, additional information indicates which function encountered the error
Action: check errno
对于文件系统而言,应该指定一个文件,而不是一个目录,因此报错。只需将上面的/dev/dsk/emcpower6a改为/data目录下的一个文件的地址信息就可以解决这个问题。
root@ser1 # ./orion_solaris_sparc64 -run simple -testname mytest
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20090812_1041
Test will take approximately 9 minutes
Larger caches may take longer
storax_skgfr_openfiles: File identification failed on /dev/rdsk/emcpower5a
OER 27041: please look up error in Oracle documentation
SVR4 Error: 6: No such device or address
Additional information: 2
rwbase_lio_init_luns: lun_openvols failed
rwbase_rwluns: rwbase_lio_init_luns failed
orion_thread_main: rw_luns failed
Non test error occurred
Orion exiting
Oracle对应的ORA-27041错误为:
ORA-27041: unable to open file
Cause: open system call returned an error, additional information indicates which function encountered the error
Action: check errno
导致这个错误是由于/dev/rdsk/emcpower5a没有对应任何的裸设备,实际上emcpower5对应的分区没有分配0区间。
对于设置裸设备也可能碰到上面的27037错误,这是由于裸设备中并没有拷贝文件,导致orion找不到要读取的文件因此报错,可以用dd拷贝文件到裸设备上,并完成测试:
root@ser1 # dd if=/data/10gr2_db_sol.cpio of=/dev/rdsk/emcpower5g
1792016+0 records in
1792016+0 records out
另外还可能碰到下面的错误:
bash-3.00$ ./orion_solaris_sparc64 -run simple -testname mytest
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20090812_1822
Test will take approximately 9 minutes
Larger caches may take longer
storax_skgfr_openfiles: File identification failed on /data/patch/p5337014_10203_SOLARIS64.zip
OER 27046: please look up error in Oracle documentation
Additional information: 1
rwbase_lio_init_luns: lun_openvols failed
rwbase_rwluns: rwbase_lio_init_luns failed
orion_thread_main: rw_luns failed
Non test error occurred
Orion exiting
Oracle的ORA-27046错误给出了原因:
ORA-27046: file size is not a multiple of logical block size
Cause: file size as indicated by stat is not correct, additional information indicates which function encountered the error
Action: verify that the file has not been overwritten or truncated
由于给定的zip文件不是logical block的整数倍,因此导致这个问题。选择一个Oracle数据库相关的文件测试即可。如果是裸设备,可以在dd的时候控制裸设备的文件大小。