ORION工具（二）

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 f=/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的時候控制裸裝置的檔案大小。