Original link:
http://www.eygle.com/special/how.to.install.ORABM.TPC.HTM
1. First download the ORABM package
You can download from the following address:
http://www.linxcel.co.uk/orabm/orabm.tar
You can also download from your local.
[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% [================================================ ====================================================================================================================0026.53K / s ETA 00 00
17:47:43 (26.53 kb / s) - `ORABM.TAR 'SAVED [1280000/1280000]
2. View related files
$ 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 Blocksx 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 Blocksx 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
Note: The default ORABM test uses users will be built in Tools tablespace if you want to put data in other tablespaces to modify ORABM_USER.SQL to adjust.
3. The steps to install are as follows:
#
Operation
Command
1
Create the ORABM User (Assums 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 @oramp_analyze
6
Create The Stress-Test Pl / SQL Procedures
Sqlplus system / pwd @orabm_serverside_stress
Seduce
Cache the Table and Index Data in the SGA
Sqlplus system / pwd @orabm_cache
4. Install the log and as follows
$ SQLPLUS "/ as sysdba" @orabm_user
SQL * Plus: 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 ProductionWith The Partitioning, OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.4.0 - Production
$ SQLPLUS "/ as sysdba" @orabm_tab
SQL * Plus: 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
SQL * Plus: 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 buying by Oracle Record Breaking 32-CPU
DOC> * RAC TPC-C Benchmark on Linux - Sept 2002
DOC> *
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 Production
With the partitioning, OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.4.0 - Production
$ SQLPLUS "/ as sysdba" @orabm_analyze
SQL * Plus: 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 ProductionWith The Partitioning, OLAP AND ORACLE DATA MINING OPTIONS
JServer Release 9.2.0.4.0 - Production
$ SQLPLUS "/ as sysdba" @oramp_serverside_stress
SQL * Plus: 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 (geoff@dbcool.com) - 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 T
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 create.
Procedure create.
Procedure create.
Procedure create.
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
SQL * Plus: 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 OPTIONSJSERVER 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
The installation is complete.
