Skip to content

Latest commit

 

History

History
106 lines (74 loc) · 2.36 KB

how-to-install-benchmarksql-for-oracle.md

File metadata and controls

106 lines (74 loc) · 2.36 KB
Raw

How to install BenchmarkSQL for Oracle

  1. Install JDK 1.8.

  2. Decompress the downloaded file.

$ cd Downloads
$ tar -zxvf jdk-8u212-linux-x64.tar.gz
  1. Add the two lines below (for setting the environment variables) to ~/.bashrc file.
export JAVA_HOME=/home/mijin/Downloads/jdk1.8.0_211
export PATH=$JAVA_HOME/bin:$PATH
  1. Check the version of Java.
$ java -version
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

  1. Download BenchmarkSQL.

  2. Unzip the downloaded file.

$ unzip benchmarksql-5.0.zip
$ cd benchmarksql-5.0
  1. If you don't have ant package in your Ubuntu, download it first. Then, compile the source code.
$ sudo apt-get install ant
$ ant
  1. Copy 18c drive to benchmark.
$ cp /u01/app/oracle/product/12.2.0/dbhome_1/jdbc/lib/ojdbc8.jar /home/mijin/Downloads/benchmarksql-5.0/lib/oracle/ojdbc8.jar
  1. Create a database user.
$ sqlplus / as sysdba
...

SQL> create user benchmarksql identified by "benchmarksql";
...

SQL> grant dba, connect to benchmarksql;
...

SQL> alter user benchmarksql default tablespace users;
...
  1. Modify the configuration file for BenchmarkSQL.
$ cd /home/mijin/Downloads/benchmarksql-5.0/run
$ cp props.ora myprops.ora
$ vi myprops.ora
...

Change each parameter for your preference. Please change host name or port number according to your environment.

  1. Create tables.
$ ./runSQL.sh myprops.ora ./sql.common/tableCreates.sql

You can skip step 11~13 by just executing the runDatabaseBuild.sh script with your configuration file.

  1. Generate test data with 200 warehouse.
$ ./runLoader.sh myprops.ora numWarehouses 200
  1. Create indices and finish build.
$ ./runSQL.sh myprops.ora ./sql.common/indexCreates.sql
$ ./runSQL.sh myprops.ora ./sql.common/foreignKeys.sql
$ ./runSQL.sh myprops.ora ./sql.oracle/extraHistID.sql
$ ./runSQL.sh myprops.ora ./sql.common/buildFinish.sql
  1. Start running.
$ ./runBenchmark.sh myprops.ora