原文链接:
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.tar'Resolving 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
至此安装完成.
