Run Oracle OLTP workloads in HP-UX vPars and Integrity VM v6.1.5

Generation of database

An empty database instance is created using the Database Configuration Assistant (DBCA). DBCA creates the default

data files, the redo log groups, and other miscellaneous files. The Datagenerator utility (part of the Swingbench suite) is

used to populate the dataset based on a specified scaling factor.

As indicated earlier, for this benchmark effort with 64 GB of guest memory, we selected a 38 GB database

memory target.

Workload run

The following steps were followed to setup the Oracle client and server.

Setup for Oracle server:

LUNs from (EVA) storage will be connected to native system. The disks seen on the native system should also be

presented to the guests (both vPars and Integrity VMs) via NPIV vFCs. This would be required to do all runs (native,

vPars, and Integrity VM) with same disk/configuration.

For guests:

• Install host with HP-UX September 2012 DC-OE

– Install the HPVM software v6.1.5

• Create a guest using a disk presented via NPIV for its root drive

• Install guest with HP-UX September 2012 DC-OE

– Install VirtualBase guest tool kit

• Install Oracle on a separate SAN disk on the guest

– Present disks from storage via NPIV

– Install Oracle

– Create the database

– Run the tests using Swingbench

• Gather the required test results. The results obtained here are for the guest.

• Get the boot path of the guest root drive. For example, 0/0/0/5/0/0/0.0x217000c0ffd8bee1.0x4006000000000000.

This boot path will be required for bringing up the system in native mode.

• Shutdown the guest

For Native:

• Boot native with the same boot disk which was used by the guest, to have same configuration/Oracle setup as used

with guest.

• Even though we use the same LAN interface card, the LAN IDs seen on the native and the guest will be different. When

booting the system with same disk in the native mode, we may want to manually remove some of the entries from the

network configuration file (and put those entries back when booting the guest OS instance). We may do this by

booting the system in single user mode and edit /etc/rc.config.d/netconf to have an appropriate LAN ID entry.

• Run the tests using Swingbench

• Gather the required test results. The results obtained here are for the native.

Setup for Oracle client:

• Host is installed with HP-UX September 2012 DC-OE

• Install Oracle without database (for client server communication)

• Install Swingbench v2.3

This method of booting the native blade using the vPar/VM guest boot disk can only be accomplished if the guest boot

disk and the Oracle data storage are presented via NPIV. The agile storage addressing built into HP-UX 11i v3 retains the

device special files between Integrity VM test runs and physical Integrity server test runs.