$ cd tools
$ ls
orabm      orabm.tar
$ cd orabm
$ 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
$ sqlplus '/ as sysdba' @orabm_user

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 30 14:40:57 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.sql

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 30 14:41:18 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 ../bin/solaris
$ ls
bm.hsbill.log  orabm          orabmload
$ LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH} export LD_LIBRARY_PATH 
$ orabmload Warehouses 5

Connected to ORACLE as user: ORABM
using timestamp=20040930144302
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 Stock Wid=2
.................... 20000
.................... 40000
.................... 60000
.................... 80000
.................... 100000
 Stock Done.
Loading District
Loading Stock Wid=3
.................... 20000
.................... 40000
.................... 60000
.................... 80000
.................... 100000
 Stock Done.
Loading District
Loading Stock Wid=4
.................... 20000
.................... 40000
.................... 60000
.................... 80000
.................... 100000
 Stock Done.
Loading District
Loading Stock Wid=5
.................... 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 Customer for DID=1, WID=2
...Customer Done.
Loading Customer for DID=2, WID=2
...Customer Done.
Loading Customer for DID=3, WID=2
...Customer Done.
Loading Customer for DID=4, WID=2
...Customer Done.
Loading Customer for DID=5, WID=2
...Customer Done.
Loading Customer for DID=6, WID=2
...Customer Done.
Loading Customer for DID=7, WID=2
...Customer Done.
Loading Customer for DID=8, WID=2
...Customer Done.
Loading Customer for DID=9, WID=2
...Customer Done.
Loading Customer for DID=10, WID=2
...Customer Done.
Loading Customer for DID=1, WID=3
...Customer Done.
Loading Customer for DID=2, WID=3
...Customer Done.
Loading Customer for DID=3, WID=3
...Customer Done.
Loading Customer for DID=4, WID=3
...Customer Done.
Loading Customer for DID=5, WID=3
...Customer Done.
Loading Customer for DID=6, WID=3
...Customer Done.
Loading Customer for DID=7, WID=3
...Customer Done.
Loading Customer for DID=8, WID=3
...Customer Done.
Loading Customer for DID=9, WID=3
...Customer Done.
Loading Customer for DID=10, WID=3
...Customer Done.
Loading Customer for DID=1, WID=4
...Customer Done.
Loading Customer for DID=2, WID=4
...Customer Done.
Loading Customer for DID=3, WID=4
...Customer Done.
Loading Customer for DID=4, WID=4
...Customer Done.
Loading Customer for DID=5, WID=4
...Customer Done.
Loading Customer for DID=6, WID=4
...Customer Done.
Loading Customer for DID=7, WID=4
...Customer Done.
Loading Customer for DID=8, WID=4
...Customer Done.
Loading Customer for DID=9, WID=4
...Customer Done.
Loading Customer for DID=10, WID=4
...Customer Done.
Loading Customer for DID=1, WID=5
...Customer Done.
Loading Customer for DID=2, WID=5
...Customer Done.
Loading Customer for DID=3, WID=5
...Customer Done.
Loading Customer for DID=4, WID=5
...Customer Done.
Loading Customer for DID=5, WID=5
...Customer Done.
Loading Customer for DID=6, WID=5
...Customer Done.
Loading Customer for DID=7, WID=5
...Customer Done.
Loading Customer for DID=8, WID=5
...Customer Done.
Loading Customer for DID=9, WID=5
...Customer Done.
Loading Customer for DID=10, WID=5
...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.
Loading Orders for D=1, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=2, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=3, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=4, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=5, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=6, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=7, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=8, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=9, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=10, W= 2
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=1, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=2, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=3, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=4, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=5, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=6, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=7, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=8, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=9, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=10, W= 3
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=1, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=2, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=3, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=4, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=5, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=6, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=7, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=8, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=9, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=10, W= 4
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=1, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=2, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=3, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=4, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=5, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=6, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=7, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=8, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=9, W= 5
. 1000
. 2000
. 3000
Orders Done.
Loading Orders for D=10, W= 5
. 1000
. 2000
. 3000
Orders Done.

...DATA LOADING COMPLETED SUCCESSFULLY.
$ cd ../../install
$ sqlplus '/ as sysdba' @@orabm_ind

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 30 15:27:52 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

SP2-0310: unable to open file "hsbillorabm_ind.sql"
SQL> exit
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
$ 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 Thu Sep 30 15:28:06 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 (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 Thu Sep 30 15:30:38 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
$