swingbench运行在linux里面,Swingbench安装前的准备工作（代码）

1.确认安装的平台与java，oracle相关配置

2.oracle@SZDB:~> cat /etc/issue #查看系统版本

3.

4.Welcome to SUSE Linux Enterprise Server 10 SP3 (x86_64) - Kernel \r (\l).

5.

6.oracle@SZDB:~> java -version #使用这个方式即可确认jave当前的版本

7.java version "1.5.0_22"

8.Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_22-b03)

9.Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_22-b03, mixed mode)

10.

11.SZDB:/ # find / -name java |grep jdk #查看java路径

12./usr/java/jdk1.5.0_22/bin/java

13./usr/java/jdk1.5.0_22/jre/bin/java

14./users/oracle/OraHome10g/jdk/bin/java

15./users/oracle/OraHome10g/jdk/jre/bin/java

16.

17.oracle@SZDB:~> env | grep ORACLE_HOME

18.ORACLE_HOME=/users/oracle/OraHome10g

19.

20.2、安装配置swingbench

21.使用ftp工具将下载的zip文件上传导linux服务器，本文使用的为winscp。

22.上传解压后的路径及文件如下：

23.oracle@SZDB:~/robinson/swingbench> pwd

24./users/oracle/robinson/swingbench

25.oracle@SZDB:~/robinson/swingbench> ls

26.bin lib README.txt source sql swingbench.env swingbenchenv.bat winbin

27.oracle@SZDB:~/robinson/swingbench> vi swingbench.env

28.#!/bin/bash

29.# Set the following to reflect the root directory of your Java installation

30.export JAVAHOME=/usr/java/jdk1.5.0_22 #修改此路径为正确的路径

31.# Set the following to the directory where you installed swingbench

32.export SWINGHOME=/users/oracle/robinson/swingbench #修改此路径为正确的路径

33.# Set the following to the location of your TimesTen install (optional)

34.export TTHOME=/opt/TimesTen/tt70

35.# If you don't have the ORACLE_HOME environment variable set uncomment the following and change it to reflect your environment

36.export ORACLE_HOME=/users/oracle/OraHome10g #修改此路径为正确的路径

37.#

38.export ANTHOME=$SWINGHOME/lib

39.export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib:$TTHOME/lib

40.export CLASSPATH=$JAVAHOME/lib/rt.jar:$JAVAHOME/lib/tools.jar:$SWINGHOME/lib/mytransactions.jar:

41.${SWINGHOME}/lib/swingbench.jar:$ANTHOME/ant.jar:

42.# The following is needed for 10g environments

43.export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/opmn/lib/ons.jar

44.# The following is only needed for 11g environments

45.export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/ojdbc5.jar

46.# The following is only needed for TimesTen environments

47.export CLASSPATH=$CLASSPATH:$TTHOME/lib/classes15.jar

48.

49.3、安装soe schema

50.启动Xmanager - Passive，也可以直接remote到linux后执行命令以期用GUI界面

51.oracle@SZDB:~/robinson/swingbench> export DISPLAY=192.168.7.133:0.0

52.oracle@SZDB:~/robinson/swingbench> cd bin

53.oracle@SZDB:~/robinson/swingbench/bin> ./oewizard #使用GUI向导安装oe schema

54.soe@SYBO2SZ> @dba_tables_user #检查安装soe的结果

55.

56.Table Name Tablespace Last Analyzed # of Rows

57.------------------------------ ---------------------------- -------------------- ------------

58.CUSTOMERS SOE 16-NOV-2012 16:11:31 1,000,411

59.INVENTORIES SOE 16-NOV-2012 16:11:48 5,760

60.LOGON SOE 16-NOV-2012 16:11:48 0

61.ORDERS SOE 16-NOV-2012 16:11:55 1,000,000

62.ORDER_ITEMS SOE 16-NOV-2012 16:12:13 3,503,005

63.PRODUCT_DESCRIPTIONS SOE 16-NOV-2012 16:12:20 288

64.PRODUCT_INFORMATION SOE 16-NOV-2012 16:12:20 288

65.WAREHOUSES SOE 16-NOV-2012 16:12:20 20

66.

67.#Author : Robinson

68.#Blog : http://blog.csdn.net/robinson_0612

69.oracle@SZDB:~/robinson/swingbench/bin> ./swingbench #开始实施swingbench

70.Started Swingbench, Version 2.3.0.422. Using config file swingconfig.xml

71.BI Beans Graph version [2.7.5.32] Engine version [2.7.5.32]toad for oracle 11

阅读(2219) | 评论(0) | 转发(0) |