How to Install ORABM

Source: Internet
Author: User
Tags count header http request log reserved sqlplus linux


Original link:


Http://www.eygle.com/special/How.to.Install.Orabm.TPC.htm

1. First Download ORABM package

You can download from the following address:

Http://www.linxcel.co.uk/orabm/orabm.tar

can also be downloaded from the local area.



[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 ... oklength:1,280,000 [application/x-tar]100%[================================================================= =======================&GT] 1,280,000 26.53k/s ETA 00:0017:47:43 (26.53 kb/s)-' Orabm.tar ' saved [1280000/1280000]

2. View related Documents



$ tar-xvf *.tarx orabm, 0 bytes, 0 tape blocksx orabm/src, 0 bytes, 0 tape blocksx orabm/src/orabmload.pc, 24200 bytes, 4 8 Tape blocksx orabm/src/orabm.c, 9346 bytes, tape blocksx, Orabm/src/init.ora, 1442 bytes, 3 tape blocksx Orabm/src/bui Ld_from_source.txt, 863 bytes, 2 tape blocksx orabm/install, 0 bytes, 0 tape blocksx Orabm/install/orabm_analyze.sql, 1068 Bytes, 3 tape blocksx orabm/install/orabm_cache.sql, 1116 bytes, 3 tape blocksx orabm/install/orabm_ind.sql, 1124 bytes, 3 Tape blocksx orabm/install/orabm_query_cache.sql, 497 bytes, 1 tape blocksx Orabm/install/orabm_serverside_stress.sql , 8528 bytes, tape blocksx orabm/install/orabm_tab.sql, 2321 bytes, 5 tape blocksx Orabm/install/orabm_tab_rm.sql, 197 Bytes, 1 tape blocksx orabm/install/orabm_user.sql, 233 bytes, 1 tape blocksx orabm/bin, 0 bytes, 0 tape blocksx Orabm/bin /orabm_tps.awk, Bytes, 1 tape blocksx orabm/bin/orabm_tps.sh, bytes, 1 tape blocksx orabm/bin/solaris, 0 bytes, 0 t Ape Blocksx Orabm/bin/solarIs/orabmload, 85940 bytes, blocksx orabm/bin/solaris/orabm, 53140 bytes, tape tape blocksx orabm/bin/linux, 0 byte S, 0 tape blocksx orabm/bin/linux/orabm, 42332 bytes, and tape blocksx, Orabm/bin/linux/orabmload, 50741 bytes, tape blo Cksx orabm/bin/orabm.linuxd2.log, 559 bytes, 2 tape blocksx orabm/bin/windows, 0 bytes, 0 tape blocksx orabm/bin/windows/o Rabm.exe, 196653 bytes, 385 tape blocksx orabm/bin/windows/orabmload.exe, 233525 bytes, 457, tape blocksx orabm/orabm.pdf, 239954 bytes, 469 tape blocksx orabm/orabm.htm, 200488 bytes, 392 tape blocksx orabm/orabm_files, 0 bytes, 0 tape blocksx Orabm/orabm_files/image001.jpg, 46143 bytes, tape blocksx orabm/orabm_files/image002.jpg, 8437 bytes, tape blocksx o RABM/ORABM_FILES/_VTI_CNF, 0 bytes, 0 tape blocksx orabm/orabm_files/_vti_cnf/image002.jpg, 724 bytes, 2 tape blocksx Orab M/orabm_files/_vti_cnf/image001.jpg, 725 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/image003.gif, 699 bytes, 2 Tape Blocksx Orabm/orabm_fileS/_vti_cnf/editdata.mso, 708 bytes, 2 tape blocksx orabm/orabm_files/_vti_cnf/filelist.xml, 707 bytes, 2 tape blocksx Orab m/orabm_files/_vti_cnf/header.htm, 1264 bytes, 3 tape blocksx orabm/orabm_files/_vti_cnf/.fp_folder_info, Bytes, 1 Tape blocksx orabm/orabm_files/editdata.mso, 2976 bytes, 6 tape blocksx orabm/orabm_files/filelist.xml, 289 bytes, 1 tape Blocksx orabm/orabm_files/image003.gif, 14667 bytes, tape blocksx, orabm/orabm_files/header.htm, 4705 bytes, tape blo cks$ lsorabm orabm.tar$ cd orabm$ lsbin install orabm.htm orabm.pdf orabm_files src$ lsbin install orabm.htm orabm.pdf ora Bm_files src$ cd install$ lsorabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sqlorabm_ Cache.sql orabm_query_cache.sql orabm_tab.sql orabm_user.sql  



Note: The default ORABM test user will be built in the tools table space, if you want to put the data in other table space can modify the orabm_user.sql to adjust.

3. The installation steps are as follows:

#

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. Installation log and the following



$ sqlplus "/as SYSDBA" @orabm_userSQL *plus:release 9.2.0.4.0-production on Sat Sep 17:55:40 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productionuser 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 D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_tabSQL *plus:release 9.2.0.4.0-PR Oduction on Sat Sep 17:55:56 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiontable 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 productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ CD. $ lsbin Install orabm.htm orabm.pdf orabm_files src$ cd bin$ lslinux orabm.linuxd2.log Orabm_tps.awk orabm_tps.sh Solaris windows$ CD solaris$ lsorabm orabmload$./orabmload Warehouse 1ld.so.1:./orabmload:fatal:/opt/oracle/product/9.2.0/ Lib/libclntsh.so.9.0:wrong ELF class:elfclass64killed$ Ld_library_path=${oracle_home}/lib32:${ld_library_path} Export Ld_library_path $./orabmload warehouses 1Connected to ORACLE as user:orabmusing TIMESTAMP=20040925181524TPCC Data Load started ... Loading Item ............ ... 100000Item done. Loading Warehouse Loading the Stock wid=1 ........ .....100000 done.loading districtloading customer for did=1, Wid=1...customer done.loading customer for did=2, wid=1...cu Stomer done.loading customer for did=3, Wid=1...customer done.loading customer for did=4, Wid=1...customer done.loading Cu Stomer 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.loa Ding Customer for did=10, Wid=1...customer done.loading Orders for d=1, w= 1. 1000.2000. 3000Orders done.loading Orders for d=2, w= 1. 1000.2000. 3000Orders done.loading Orders for d=3, w= 1. 1000.2000. 3000Orders done.loading Orders for d=4, w= 1. 1000.2000. 3000Orders done.loading Orders for d=5, w= 1. 1000.2000. 3000Orders done.loading Orders for d=6, w= 1. 1000.2000. 3000Orders done.loading Orders for d=7, w= 1. 1000.2000. 3000Orders done.loading Orders for D=8, w= 1. 1000.2000. 3000Orders done.loading Orders for d=9, w= 1. 1000.2000. 3000Orders done.loading Orders for d=10, w= 1. 1000.2000. 3000Orders done .... DATA LOADING COMPLETED successfully.$ CD. /.. /install$ lsorabm_analyze.sql orabm_ind.sql orabm_serverside_stress.sql orabm_tab_rm.sqlorabm_cache.sql orabm_query _cache.sql orabm_tab.sql orabm_user.sql$ sqlplus "/As SYSDBA" @orabm_indSQL *plus:release 9.2.0.4.0-production on Sat S EP 18:31:05 2004Copyright (C) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiondoc> *doc> * Same indexes as used to Oracle record breaking 32-CP udoc> * RAC tpc-c benchmark on linux-sept 2002doc> *doc> * Geoff Ingram (geoff@dbcool.com) doc> */session alt Ered. Index created. Index created. Index created. Index created. Index created. Index created. IndexCreated. Index created. Index created. Index created. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_analyzeSQL *plus:release 9.2.0.4.0 -Production on Sat Sep 18:32:17 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productionsession 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 D AtaMining optionsjserver Release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_serverside_stressSQL *plus:release 9.2. 0.4.0-production on Sat Sep 18:35:50 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver Release 9.2.0.4.0-productiondoc> *doc> * v2.0doc> *doc> * Copyright (c) 2002, Geoff Ing RAM (geoff@dbcool.com)-Proton Technology ltddoc> *doc> * orabm_serverside_stress.sql:Oracle package for CPU stres S test benchmarkdoc> *doc> * Distribute Orabm_serverside_stress.sql under the terms of either thedoc> * W Idely available GNU License or the artistic licensedoc> * with the exception, that it cannot is placed on A CD-ROM or similar mediadoc> * for commercial distribution without the prior of the approval. Doc> *doc> */procedure created. Procedure CreaTed. Procedure created. Procedure created. Disconnected from oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle D ATA Mining optionsjserver release 9.2.0.4.0-production$ sqlplus "/As SYSDBA" @orabm_cacheSQL *plus:release 9.2.0.4.0- Production on Sat Sep 18:36:07 2004Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith The partitioning, OLAP and Oracle Data M Ining optionsjserver release 9.2.0.4.0-productiontable altered. COUNT (*)----------30000Table altered. COUNT (*)----------10Table altered. COUNT (*)----------30000Table altered. COUNT (*)----------299952Table altered. COUNT (*)----------100000 count (*)----------30000 count (*)----------30000 count (*)----------100000 count (*)-------- --299952 count (*)----------30000 count (*)----------30000 count (*)----------100000Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0-64bit Productionwith The partitioning, OLAP and Oracle Data Mining optionsjserver release 9.2.0.4.0-production

The installation is complete.




Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.