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.安装的步骤如下:<?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

至此安装完成.

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏Linyb极客之路

你该怎么做?当你发现springboot扫描controller没有生效

加上@SpringBootApplication为啥就能扫描到,其实我也不知道。那就看下这个注解到底是个啥样的奇葩,它的注解构造了解一下

3.3K3
来自专栏Android 开发学习

Android studio 2.2 JNI ffmpeg 简单的播放器(这里只有视频解码)include "libavcodec/avcodec.h"include "libavformat/avf

3883
来自专栏算法修养

FZU 2105 Digits Count

 Problem 2105 Digits Count Accept: 444    Submit: 2139 Time Limit: 10000 mSec ...

2915
来自专栏闵开慧

hive启动后相关操作

hadoop@ubuntu118:~$ $HIVE_HOME/bin/hive WARNING: org.apache.hadoop.metri...

3528
来自专栏我的博客

Zend Framework自动加载、简单路由配置(Bootstrap.php)

<?php class Bootstrap extends Zend_Application_Bootstrap_Bootstrap { /* * 自动加...

3418
来自专栏H2Cloud

Tips for thrift

Introduction I have designed and developed game servers successfully with thrift...

3555
来自专栏技术小黑屋

Package Stopped State Since Android 3.1

Since Android 3.1, Android has introduced a LaunchControl mechanism. It’s call S...

961
来自专栏醉梦轩

Linux上C语言写的简易telnet客户端

1582
来自专栏一个会写诗的程序员的博客

$ gradle packageDebug --stacktrace error: top-left corner pixel must be either opaque white or trans

$ gradle packageDebug --stacktrace error: top-left corner pixel must be either ...

1102
来自专栏编程坑太多

springboot (三)JdbcTemplate

1354

扫码关注云+社区