Install Swingbench 2.6 and set up Order Entry schema

Install Swingbench 2.6

To install Swingbench release 2.6, all you need to do is ensure you have a Java 8 JVM available, to check java version use command, you must have Oracle client installed and should be able to access DB through TNS.

java -version

Download Swingbench 2.6 zip file from the following sources

http://www.dominicgiles.com

Extract the zip file. The files will be automatically extracted to the following path. This folder will be referred to as the $SWINGHOME folder.

<disk drive letter>:\swingbench in my case it is D:\ETISAL COM\software\swingbench\winbin

Set up Order Entry schema

Go to the D:\ETISAL COM\software\swingbench\winbin and execute “oewizard”

You might need to rename “oewizard 2” to “oewizard”.

NOTE: If you ran into an error like this oewizard -c oewizard.xml Error occurred during initialization of VM Could not reserve enough space for 2097152KB object heap.

You need to configure a system variable as mentioned below.

Variable name: _JAVA_OPTIONS

Value: -Xmx512m

cd D:\ETISAL COM\software\swingbenchlatest\swingbench\winbin

D:\ETISAL COM\software\swingbench\winbin>oewizard

 

Provide the connection string.

In my case 192.168.56.91 is my RAC scan-ip and rac.localdomain is service name of my DB

Here only provide the location to create the tablespace in my case it is “DATA” DG

In the below screen just change the tablespace type to normal from the big tablespace.

you will be prompted with the below screen once the schema creation is completed, click ok the exit.

Now let’s check the schema from our client.

sqlplus soe/soe@lrac

Size of the schema:

SQL> SELECT ROUND(SUM(BYTES)/1024/1024/1024,3) GB FROM USER_SEGMENTS;

GB

----------

1.675

List of tables created:

SQL> select tname from tab;

TNAME
--------------------------------------------------------------------------------
CUSTOMERS
ADDRESSES
CARD_DETAILS
WAREHOUSES
ORDER_ITEMS
ORDERS
INVENTORIES
PRODUCT_INFORMATION
LOGON
PRODUCT_DESCRIPTIONS
ORDERENTRY_METADATA

TNAME
--------------------------------------------------------------------------------
PRODUCTS
PRODUCT_PRICES

13 rows selected.

 341 views last month,  5 views today

Mughees Ahmed

Over 2-year experience of Administration in Oracle, SQL Server, and MySQL databases using various tools and technologies. Keen on learning new database technologies having very good analytical skills. Working knowledge of Red Hat Linux, UNIX, Solaris and Windows Server 2012 is a valuable addition to my knowledge desk. KNOWLEDGE & SKILLS • Oracle Database Server 10g/11g/12c. • Oracle RAC, Data guard. • Oracle Golden Gate (Oracle to Oracle, Oracle to MySQL and MySQL to Oracle) • Oracle Enterprise Manager Grid Control, Toad, SQL developer. • SQL Server 2005/2008/2012/2016. • SQL Server Failover clustering, mirroring & log shipping, Always On availability groups. • MySQL 5 Administration, MySQL Workbench, MySQL Enterprise Monitor, SQLyog • MySQL NDB Cluster Installation,Administration. • MySQL Asynchronous/Semi-synchronous replication. • Oracle OEM Contact me on mughees52@gmail.com

Leave a Reply