`
wsql
  • 浏览: 12062356 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
文章分类
社区版块
存档分类
最新评论

How to Install Orabm

OracleSQLLinuxSolarisCache 
阅读更多


原文链接:

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.安装的步骤如下:<?XML:NAMESPACE PREFIX = O />

#

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

至此安装完成.

分享到：
| Use orabm To test system CPU
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    How to install Notepad2 in xp?

    标题 "How to install Notepad2 in XP?" 涉及的是在Windows XP操作系统中安装Notepad2这款文本编辑器的过程。Notepad2是一款轻量级、功能强大的替代原生记事本的工具，尤其受到程序员和系统管理员的青睐。下面我们将...

    How To Install Altiris

    How To Install Altiris

    How to install rollup core.doc

    How to install rollup core.doc

    How to install macOS Mojave final 10.14.3 on VirtualBox on Windows

    Have you ever tried to install macOS Mojave on your laptop Windows 10? but, before visiting begin ...So begins our article, to indicate you ways How to install macOS Mojave 10.14.3 final on VirtualBox.

    How to install OMNET++ on Ubuntu 12.10

    How to install OMNET++ on Ubuntu 12.10

    HOWTO: Install Setuptools in Windows

    Setuptools包含了诸如easy_install和pip这样的命令行工具，它们简化了Python库的安装过程。在Python生态系统中，Setuptools与Distutils一起使用，提供更高级的功能，如创建自包含的可执行文件、处理依赖关系和生成元...

    How To Install nginx on CentOS 6 with yum

    如果您看到“Welcome to nginx”的页面，那么您已经成功安装了 Nginx 服务器。现在，您可以继续安装 Lemp Stack 或设置 FTP 服务器等。 小结 在本教程中，我们学习了如何在 CentOS 6 上使用 yum 安装 Nginx 服务器...

    How to Install MATLAB on Mac 如何在 Mac 上安装 MATLAB.pdf

    How to Install MATLAB on Mac 如何在 Mac 上安装 MATLAB.pdf

    linux howto中文合集

    这个是合集~一般是这里最全的了 另外加的 PDF是英文的 .为 GCC4.1的HOWTO &lt;br&gt;目录 &lt;br&gt;ADSM-Backup-...HOWTO-html&lt;br&gt;ZIP-Install&lt;br&gt;

    linux uuid source and how to install in linux

    另外，`how to install.txt`文件可能包含了更详细的安装指南，建议你阅读这个文件以获取更具体的步骤或特殊要求。 了解和使用UUID对于Linux系统管理员来说至关重要，因为许多自动化脚本和配置文件都会用到UUID来...

    How To Listen (Public) 2.0.4 Setup.zip

    "How To Listen"是一款专为提升用户听力敏感度和音质辨识能力设计的训练软件，尤其适用于音乐制作人、音频工程师以及任何对声音有高要求的人群。这个名为"How To Listen (Public) 2.0.4 Setup.zip"的压缩包包含了该...

    HowTo2152.zip_howto2152

    包含了将近100张图表，这些图表能用来根据载流能力和温度限制条件来精确估计导线的宽度，这个Excel工具允许设计者根据不同的叠层结构和设计条件填入不同的数值来计算导线宽度。很简单的在绿色单元格内输入项目的设计...

    最基础的听力训练和测试——哈曼How to listen

    《哈曼How to listen：开启你的听力训练之旅》 听力训练是提升个人听力敏锐度的重要途径，尤其对于音乐爱好者和专业音频工作者来说更是必不可少。哈曼How to listen是一款专为耳朵训练而设计的软件，旨在帮助用户...

    How to install NiftyReg - Linux and MacOs

    niftyreg_build 文件夹将包含 NiftyReg 的 build，niftyreg_install 文件夹将包含最终的安装文件。 配置和编译 NiftyReg 使用 CMake 配置和编译 NiftyReg： 1. 进入 niftyreg_build 文件夹：`$ cd niftyreg_build...

    C++ How to Program, 10th Edition

    C++ How to Program (10th Edition) By 作者: Harvey M. Deitel Paul Deitel ISBN-10 书号: 9332585733 ISBN-13 书号: 9789332585737 Edition 版本: 10th 出版日期: 2017 Format: Paperback C++ How to Program ...

    Linux Howto 中文文档

    Linux HOWTO(中文版) BootPrompt-HOWTO (28KB) 启动提示说明 CDROM-HOWTO (27KB) 如何安装, 设定及使用光驱,同时列出支援的硬体. Chinese-HOWTO (39KB) 如何在 Linux 的系统上使用中文?/TD&gt; Config-...

    How to install python on eclipse

    详细介绍了第一次使用eclipse时，在Eclipse中配置python的IDE教程，图文并茂

    C++大学教程C++ How to Program(中英文）

    《C++ How to Program》是C++编程领域的一本经典教材，由保罗·戴特尔（Paul Deitel）和哈维·戴特尔（Harvey Deitel）共同编写，提供了全面且深入的C++学习资源。该教程分为第九版（9E）和第十版（10E），并提供中...

    How To Write A Dissertation

    How To Write A Dissertation

    RK3399的DRM-HOWTO测试

    RK3399的DRM-HOWTO测试 最近在学习与调试RK3399的DRM显示架构，网上有很多例程，其中介绍比较多的是来于David Herrmann’s Github的drm-howto.开源代码 但这些源码下载后执行make编译出来的执行文件只能在PC机上测试...

Magicbox
Global site tag (gtag.js) - Google Analytics