IDC资讯中心
原文链接:
http://www.eygle.com/special/how.to.install.orabm.tpc.htm
1.首先下载orabm包
你可以从以下地址下载:
http://www.linxcel.co.uk/orabm/orabm.tar
也可以从本地下载.
[gqgai@eygle gqgai]$ wget http://www.linxcel.co.uk/orabm/orabm.tar–17:46:55– http://www.linxcel.co.uk/orabm/orabm.tar => `orabm.tarresolving www.linxcel.co.uk… done.connecting to www.linxcel.co.uk[212.227.127.109]:80… connected.http request sent, awaiting response… 200 oklength: 1,280,000 [application/x-tar]100%[========================================================================================>] 1,280,000 26.53k/s eta 00:0017:47:43 (26.53 kb/s) – `orabm.tar saved [1280000/1280000]
2.查看相关文件
$ tar -xvf *.tarx orabm, 0 bytes, 0 tape blocksx orabm/src, 0 bytes, 0 tape blocksx orabm/src/orabmload.pc, 24200 bytes, 48 tape blocksx orabm/src/orabm.c, 9346 bytes, 19 tape blocksx orabm/src/init.ora, 1442 bytes, 3 tape blocksx orabm/src/build_from_source.txt, 863 bytes, 2 tape blocksx orabm/install, 0 bytes, 0 tape blocksx orabm/install/orabm_analyze.sql, 1068 bytes, 3 tape blocksx orabm/install/orabm_cache.sql, 1116 bytes, 3 tape blocksx orabm/install/orabm_ind.sql, 1124 bytes, 3 tape blocksx orabm/install/orabm_query_cache.sql, 497 bytes, 1 tape blocksx orabm/install/orabm_serverside_stress.sql, 8528 bytes, 17 tape blocksx orabm/install/orabm_tab.sql, 2321 bytes, 5 tape blocksx orabm/install/orabm_tab_rm.sql, 197 bytes, 1 tape blocksx orabm/install/orabm_user.sql, 233 bytes, 1 tape blocksx orabm/bin, 0 bytes, 0 tape blocksx orabm/bin/orabm_tps.awk, 182 bytes, 1 tape blocksx orabm/bin/orabm_tps.sh, 70 bytes, 1 tape blocksx orabm/bin/solaris, 0 bytes, 0 tape blocksx orabm/bin/solaris/orabmload, 85940 bytes, 168 tape blocksx orabm/bin/solaris/orabm, 53140 bytes, 104 tape blocksx orabm/bin/linux, 0 bytes, 0 tape blocksx orabm/bin/linux/orabm, 42332 bytes, 83 tape blocksx orabm/bin/linux/orabmload, 50741 bytes, 100 tape blocksx orabm/bin/orabm.linuxd2.log, 559 bytes, 2 tape blocksx orabm/bin/windows, 0 bytes, 0 tape blocksx orabm/bin/windows/orabm.exe, 196653 bytes, 385 tape blocksx orabm/bin/windows/orabmload.exe, 233525 bytes, 457 tape blocksx orabm/orabm.pdf, 239954 bytes, 469 tape blocksx orabm/orabm.htm, 200488 bytes, 392 tape blocksx orabm/orabm_files, 0 bytes, 0 tape blocksx orabm/orabm_files/image001.jpg, 46143 bytes, 91 tape blocksx orabm/orabm_files/image002.jpg, 8437 bytes, 17 tape blocksx orabm/orabm_files/_vti_cnf, 0 bytes, 0 tape blocksx orabm/orabm_files/_vti_cnf/image002.jpg, 724 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/image001.jpg, 725 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/image003.gif, 699 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/editdata.mso, 708 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/filelist.xml, 707 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/header.htm, 1264 bytes, 3 tape blocksx orabm/orabm_files/_vti_cnf/.fp_folder_info, 58 bytes, 1 tape blocksx orabm/orabm_files/editdata.mso, 2976 bytes, 6 tape blocksx orabm/orabm_files/filelist.xml, 289 bytes, 1 tape blocksx orabm/orabm_files/image003.gif, 14667 bytes, 29 tape blocksx orabm/orabm_files/header.htm, 4705 bytes, 10 tape blocks$ lsorabm orabm.tar$ cd orabm$ lsbin install orabm.htm orabm.pdf orabm_files src$ lsbin install orabm.htm orabm.pdf orabm_files src$ cd install$ lsorabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sqlorabm_cache.sql orabm_query_cache.sql orabm_tab.sql orabm_user.sql
注意:缺省的orabm测试用用户会建立在tools表空间,如果你想把数据放在其他表空间可以修改orabm_user.sql来调整.
3.安装的步骤如下:
#
operation
command
1
create the orabm user (assumes tools tablespace, temp temporary tablespace)
sqlplus system/pwd @orabm_user
2
create the tables
sqlplus system/pwd @orabm_tab
3
load the data
$ orabmload warehouses 1
4
create the indexes
sqlplus system/pwd @orabm_ind
5
analyze the tables and indexes
sqlplus system/pwd @orabm_analyze
6
create the stress-test pl/sql procedures
sqlplus system/pwd @orabm_serverside_stress
7
cache the table and index data in the sga
sqlplus system/pwd @orabm_cache
4.安装日志及如下
$ sqlplus “/ as sysdba” @orabm_usersql*plus: release 9.2.0.4.0 – production on sat sep 25 17:55:40 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productionuser created.grant succeeded.user altered.user altered.revoke succeeded.disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production$ sqlplus “/ as sysdba” @orabm_tabsql*plus: release 9.2.0.4.0 – production on sat sep 25 17:55:56 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productiontable created.table created.table created.table created.table created.table created.table created.table created.table created.disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production$ cd ..$ lsbin install orabm.htm orabm.pdf orabm_files src$ cd bin$ lslinux orabm.linuxd2.log orabm_tps.awk orabm_tps.sh solaris windows$ cd solaris$ lsorabm orabmload$ ./orabmload warehouse 1ld.so.1: ./orabmload: fatal: /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0: wrong elf class: elfclass64killed$ ld_library_path=${oracle_home}/lib32:${ld_library_path} export ld_library_path $ ./orabmload warehouses 1connected to oracle as user: orabmusing timestamp=20040925181524tpcc data load started…loading item ……………….. 20000……………….. 40000……………….. 60000……………….. 80000……………….. 100000item done. loading warehouse loading stock wid=1……………….. 20000……………….. 40000……………….. 60000……………….. 80000……………….. 100000 stock done.loading districtloading customer for did=1, wid=1…customer done.loading customer for did=2, wid=1…customer done.loading customer for did=3, wid=1…customer done.loading customer for did=4, wid=1…customer done.loading customer for did=5, wid=1…customer done.loading customer for did=6, wid=1…customer done.loading customer for did=7, wid=1…customer done.loading customer for did=8, wid=1…customer done.loading customer for did=9, wid=1…customer done.loading customer for did=10, wid=1…customer done.loading orders for d=1, w= 1. 1000. 2000. 3000orders done.loading orders for d=2, w= 1. 1000. 2000. 3000orders done.loading orders for d=3, w= 1. 1000. 2000. 3000orders done.loading orders for d=4, w= 1. 1000. 2000. 3000orders done.loading orders for d=5, w= 1. 1000. 2000. 3000orders done.loading orders for d=6, w= 1. 1000. 2000. 3000orders done.loading orders for d=7, w= 1. 1000. 2000. 3000orders done.loading orders for d=8, w= 1. 1000. 2000. 3000orders done.loading orders for d=9, w= 1. 1000. 2000. 3000orders done.loading orders for d=10, w= 1. 1000. 2000. 3000orders done….data loading completed successfully.$ cd ../../install$ lsorabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sqlorabm_cache.sql orabm_query_cache.sql orabm_tab.sql orabm_user.sql$ sqlplus “/ as sysdba” @orabm_indsql*plus: release 9.2.0.4.0 – production on sat sep 25 18:31:05 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productiondoc> *doc> * same indexes as used by oracle record breaking 32-cpudoc> * rac tpc-c benchmark on linux – sept 2002doc> *doc> * geoff ingram (geoff@dbcool.com)doc> */session altered.index created.index created.index created.index created.index created.index created.index created.index created.index created.index created.disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production$ sqlplus “/ as sysdba” @orabm_analyzesql*plus: release 9.2.0.4.0 – production on sat sep 25 18:32:17 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productionsession altered.table analyzed.table analyzed.table analyzed.table analyzed.table analyzed.table analyzed.table analyzed.table analyzed.table analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.index analyzed.disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production$ sqlplus “/ as sysdba” @orabm_serverside_stresssql*plus: release 9.2.0.4.0 – production on sat sep 25 18:35:50 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productiondoc> *doc> * v2.0doc> *doc> * copyright (c) 2002, geoff ingram (geoff@dbcool.com) – proton technology ltddoc> *doc> * orabm_serverside_stress.sql: oracle package for cpu stress test benchmarkdoc> *doc> * you may distribute orabm_serverside_stress.sql under the terms of either thedoc> * widely available gnu general public license or the artistic licensedoc> * with the exception that it cannot be placed on a cd-rom or similar mediadoc> * for commercial distribution without the prior approval of the author.doc> *doc> */procedure created.procedure created.procedure created.procedure created.disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production$ sqlplus “/ as sysdba” @orabm_cachesql*plus: release 9.2.0.4.0 – production on sat sep 25 18:36:07 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – productiontable altered. count(*)———- 30000table altered. count(*)———- 10table altered. count(*)———- 30000table altered. count(*)———- 299952table altered. count(*)———- 100000 count(*)———- 30000 count(*)———- 30000 count(*)———- 100000 count(*)———- 299952 count(*)———- 30000 count(*)———- 30000 count(*)———- 100000disconnected from oracle9i enterprise edition release 9.2.0.4.0 – 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 – production
至此安装完成.
