How to Install Orabm

原文链接:

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 OK > Length: 1,280,000 [application/x-tar] > > 100%[========================================================================================>] 1,280,000 26.53K/s ETA 00:00 > > 17:47:43 (26.53 KB/s) - orabm.tar' saved [1280000/1280000] >
>

2.查看相关文件

> > $ tar -xvf *.tar > x orabm, 0 bytes, 0 tape blocks > x orabm/src, 0 bytes, 0 tape blocks > x orabm/src/orabmload.pc, 24200 bytes, 48 tape blocks > x orabm/src/orabm.c, 9346 bytes, 19 tape blocks > x orabm/src/init.ora, 1442 bytes, 3 tape blocks > x orabm/src/BUILD_FROM_SOURCE.txt, 863 bytes, 2 tape blocks > x orabm/install, 0 bytes, 0 tape blocks > x orabm/install/orabm_analyze.sql, 1068 bytes, 3 tape blocks > x orabm/install/orabm_cache.sql, 1116 bytes, 3 tape blocks > x orabm/install/orabm_ind.sql, 1124 bytes, 3 tape blocks > x orabm/install/orabm_query_cache.sql, 497 bytes, 1 tape blocks > x orabm/install/orabm_serverside_stress.sql, 8528 bytes, 17 tape blocks > x orabm/install/orabm_tab.sql, 2321 bytes, 5 tape blocks > x orabm/install/orabm_tab_rm.sql, 197 bytes, 1 tape blocks > x orabm/install/orabm_user.sql, 233 bytes, 1 tape blocks > x orabm/bin, 0 bytes, 0 tape blocks > x orabm/bin/orabm_tps.awk, 182 bytes, 1 tape blocks > x orabm/bin/orabm_tps.sh, 70 bytes, 1 tape blocks > x orabm/bin/solaris, 0 bytes, 0 tape blocks > x orabm/bin/solaris/orabmload, 85940 bytes, 168 tape blocks > x orabm/bin/solaris/orabm, 53140 bytes, 104 tape blocks > x orabm/bin/linux, 0 bytes, 0 tape blocks > x orabm/bin/linux/orabm, 42332 bytes, 83 tape blocks > x orabm/bin/linux/orabmload, 50741 bytes, 100 tape blocks > x orabm/bin/orabm.linuxd2.log, 559 bytes, 2 tape blocks > x orabm/bin/windows, 0 bytes, 0 tape blocks > x orabm/bin/windows/orabm.exe, 196653 bytes, 385 tape blocks > x orabm/bin/windows/orabmload.exe, 233525 bytes, 457 tape blocks > x orabm/orabm.pdf, 239954 bytes, 469 tape blocks > x orabm/orabm.htm, 200488 bytes, 392 tape blocks > x orabm/orabm_files, 0 bytes, 0 tape blocks > x orabm/orabm_files/image001.jpg, 46143 bytes, 91 tape blocks > x orabm/orabm_files/image002.jpg, 8437 bytes, 17 tape blocks > x orabm/orabm_files/_vti_cnf, 0 bytes, 0 tape blocks > x orabm/orabm_files/_vti_cnf/image002.jpg, 724 bytes, 2 tape blocks > x orabm/orabm_files/_vti_cnf/image001.jpg, 725 bytes, 2 tape blocks > x orabm/orabm_files/_vti_cnf/image003.gif, 699 bytes, 2 tape blocks > x orabm/orabm_files/_vti_cnf/editdata.mso, 708 bytes, 2 tape blocks > x orabm/orabm_files/_vti_cnf/filelist.xml, 707 bytes, 2 tape blocks > x orabm/orabm_files/_vti_cnf/header.htm, 1264 bytes, 3 tape blocks > x orabm/orabm_files/_vti_cnf/.fp_folder_info, 58 bytes, 1 tape blocks > x orabm/orabm_files/editdata.mso, 2976 bytes, 6 tape blocks > x orabm/orabm_files/filelist.xml, 289 bytes, 1 tape blocks > x orabm/orabm_files/image003.gif, 14667 bytes, 29 tape blocks > x orabm/orabm_files/header.htm, 4705 bytes, 10 tape blocks > $ ls > orabm orabm.tar > $ cd orabm > $ ls > bin install orabm.htm orabm.pdf orabm_files src > $ ls > bin install orabm.htm orabm.pdf orabm_files src > $ cd install > $ ls > orabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sql > orabm_cache.sql orabm_query_cache.sql orabm_tab.sql orabm_user.sql >

注意:缺省的orabm测试用用户会建立在tools表空间,如果你想把数据放在其他表空间可以修改orabm_user.sql来调整.

3.安装的步骤如下:

** # **

** Operation **

** Command **

---|---|---

create the ORABM user (assumes TOOLS tablespace, TEMP temporary tablespace)

sqlplus system/pwd @orabm_user

create the tables

sqlplus system/pwd @orabm_tab

load the data

$ orabmload Warehouses 1

create the indexes

sqlplus system/pwd @orabm_ind

analyze the tables and indexes

sqlplus system/pwd @orabm_analyze

create the stress-test PL/SQL procedures

sqlplus system/pwd @orabm_serverside_stress

cache the table and index data in the SGA

sqlplus system/pwd @orabm_cache

4.安装日志及如下

> > $ sqlplus "/ as sysdba" @orabm_user >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 17:55:40 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
>
> User created. >
>
> Grant succeeded. >
>
> User altered. >
>
> User altered. >
>
> Revoke succeeded. >
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production > $ sqlplus "/ as sysdba" @orabm_tab >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 17:55:56 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
>
> Table 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 Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
> $ cd .. > $ ls > bin install orabm.htm orabm.pdf orabm_files src > $ cd bin > $ ls > linux orabm.linuxd2.log orabm_tps.awk orabm_tps.sh solaris windows > $ cd solaris > $ ls > orabm orabmload > $ ./orabmload Warehouse 1 > ld.so.1: ./orabmload: fatal: /opt/oracle/product/9.2.0/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 > Killed >
> $ LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH} export LD_LIBRARY_PATH >
> $ ./orabmload Warehouses 1 >
> Connected to ORACLE as user: ORABM > using timestamp=20040925181524 > TPCC Data Load Started... > Loading Item > .................... 20000 > .................... 40000 > .................... 60000 > .................... 80000 > .................... 100000 > Item Done. > Loading Warehouse > Loading Stock Wid=1 > .................... 20000 > .................... 40000 > .................... 60000 > .................... 80000 > .................... 100000 > Stock Done. > Loading District > Loading 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 > . 3000 > Orders Done. > Loading Orders for D=2, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=3, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=4, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=5, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=6, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=7, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=8, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=9, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. > Loading Orders for D=10, W= 1 > . 1000 > . 2000 > . 3000 > Orders Done. >
> ...DATA LOADING COMPLETED SUCCESSFULLY. > $ cd ../../install > $ ls > orabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sql > orabm_cache.sql orabm_query_cache.sql orabm_tab.sql orabm_user.sql > $ sqlplus "/ as sysdba" @orabm_ind >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 18:31:05 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
> DOC> * > DOC> * same indexes as used by Oracle record breaking 32-CPU > DOC> * RAC TPC-C benchmark on Linux - Sept 2002 > DOC> * > DOC> * Geoff Ingram ([email protected]) > 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 Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production > $ sqlplus "/ as sysdba" @orabm_analyze >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 18:32:17 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
>
> Session 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 Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production > $ sqlplus "/ as sysdba" @orabm_serverside_stress >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 18:35:50 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
> DOC> * > DOC> * v2.0 > DOC> * > DOC> * Copyright (c) 2002, Geoff Ingram ([email protected]) - Proton Technology Ltd > DOC> * > DOC> * orabm_serverside_stress.sql: Oracle package for CPU stress test benchmark > DOC> * > DOC> * You may distribute orabm_serverside_stress.sql under the terms of either the > DOC> * widely available GNU General Public License or the Artistic License > DOC> * with the exception that it cannot be placed on a CD-ROM or similar media > DOC> * 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 Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production > $ sqlplus "/ as sysdba" @orabm_cache >
> SQLPlus: Release 9.2.0.4.0 - Production on Sat Sep 25 18:36:07 2004 >
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. >
>
> Connected to: > Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >
>
> Table altered. >
>
> COUNT() > ---------- > 30000 >
>
> Table altered. >
>
> COUNT() > ---------- > 10 >
>
> Table altered. >
>
> COUNT() > ---------- > 30000 >
>
> Table altered. >
>
> COUNT() > ---------- > 299952 >
>
> Table altered. >
>
> COUNT() > ---------- > 100000 >
>
> COUNT() > ---------- > 30000 >
>
> COUNT() > ---------- > 30000 >
>
> COUNT() > ---------- > 100000 >
>
> COUNT() > ---------- > 299952 >
>
> COUNT() > ---------- > 30000 >
>
> COUNT() > ---------- > 30000 >
>
> COUNT() > ---------- > 100000 >
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.4.0 - Production >

至此安装完成.