HowtoInstallOrabm_数据库_领测软件测试网

HowtoInstallOrabm

发表于：2007-05-25来源：作者：点击数：标签：

原文链接: 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

原文链接:

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.安装的步骤如下:MILY: Verdana; mso-bidi-font-size: 10.0pt">

#	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_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 suclearcase/" target="_blank" >cceeded.


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*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 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 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

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 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

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 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

至此安装完成.

原文转自：http://www.ltesting.net

相关文章

HBase技术详细介绍

memcached深度分析

MapReduce实例浅析

Oracle 10G安装步骤

sqlserver 和Oracle中 order by(排序)的区别

几种必知的oracle结构图

周排行

月排行

下载

全网最详细的接口测试实战

先测试再开发？TDD测试驱动

自动化测试架构

软件测试架构师的知识能力

大数据平台测试方法

用不同的测试模型来构建测

当软件测试遇上ChatGPT：软件

全网最详细的接口测试实战

先测试再开发？TDD测试驱动

自动化测试架构

软件测试架构师的知识能力

大数据平台测试方法

用不同的测试模型来构建测

当软件测试遇上ChatGPT：软件

MBT基于模型的测试介绍资料

iso29119相关介绍性资料

HP QTP 10 中文版官方中文补丁

HP QTP 10 英文版下载地址

HP ALM 11 官方中文版下载地址

Quality Center 9.0中文版下载地

HttpWatch Basic Edition Version 7.

WIN2003+ORACLE11G+QC11(ALM11) 安装

WIN2003+SQL2005(SP3)+QC11(ALM11) 安

软件测试沙龙 More>>

新浪微博 More>>

热门标签

功能测试

性能测试

安全测试

本地化测试

游戏测试

web测试

单元测试

敏捷测试

测试用例

测试模版

测试管理

测试工具

《测试团队的招聘与管理

《我们应该如何构建我们

软件测试 > 测试开发技术 > 软件测试开发语言 > 数据库 >

HowtoInstallOrabm