Search This Blog

Total Pageviews

Wednesday 10 November 2010

Oracle swingbench installation

Load generator for Oracle

Swingbench installation on oracle 10g




download swingbench230422.zip

from http://dominicgiles.com/downloads.html

unzip swingbench230422.zip in oracle user home dir

in my case /home/oracle

pwd

/home/oracle


then

unzip swingbench230422.zip

it will create swingbench




download jre-6u22-linux-i586-rpm.bin

and install


apt-lnxtst-01:/tmp # sh jre-6u22-linux-i586-rpm.bin
Unpacking...
Checksumming...
Extracting...
UnZipSFX 5.50 of 17 February 2002, by Info-ZIP (Zip-Bugs@lists.wku.edu).
inflating: jre-6u22-linux-i586.rpm
Preparing... ########################################### [100%]
1:jre ########################################### [100%]
Unpacking JAR files...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...
plugin.jar...
javaws.jar...
deploy.jar...

Done.

find the installation path

apt-lnxtst-01:/tmp # find /|grep rt.jar
/usr/java/jre1.6.0_22/lib/rt.jar
/usr/java/jre1.6.0_22/lib/alt-rt.jar


and change JAVAHOME accordingly ...

in my case /usr/java/jre1.6.0_22

oracle@apt-lnxtst-01:~/swingbench> cat swingbench.env

#!/bin/bash
export ORACLE_HOME=/opt/oracle/product/10.2
export JAVAHOME=/usr/java/jre1.6.0_22
export SWINGHOME=/home/oracle/swingbench
export ANTHOME=$SWINGHOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
export LOADGENHOSTS='localhost'
export LOADGENUSER=oracle
export CLASSPATH=$JAVAHOME/lib/rt.jar:$JAVAHOME/lib/tools.jar:$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$SWINGHOME/lib/mytrations.jar:${SWINGHOME}/lib/swingbench.jar:$ANTHOME/ant.jar




anujs@apt-amd-02:~> ssh -Y oracle@192.168.2.232
Password:
Last login: Wed Nov 10 14:20:14 2010 from apt-amd-02.aptus.co.uk
oracle@apt-lnxtst-01:~> pwd
/home/oracle
oracle@apt-lnxtst-01:~> cd swingbench/
oracle@apt-lnxtst-01:~/swingbench> cd bin
oracle@apt-lnxtst-01:~/swingbench/bin> ./swingbench



and connect through

Oracle 10g Type II jdbc driver(oci)

Oracle DBA

anuj blog Archive