Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The 64 bit version of the minimal install of Centos 6.5 is used for the Rep Attack RepAttack operating system. This is a minimal install with no X Windows software or graphical user interface. The ISO image used for the install can be found by following the links on the Centos isoredirect page.

...

Oracle Express Edition has already been installed via it's RPM package using all default values.
An additional tablespace called REPOE_DATA has been added to hold the application data used by Rep AttackRepAttack

It can be downloaded from the Oracle Database Express Edition 11g Release 2 downloads page. It requires you to sign up for a (free) Oracle Account if you don't already have one.

...

Warning

There is no automatic deletion of the archived redo log files from the source database.

The database on the Rep Attack RepAttack target machine is not in ARCHIVELOG mode.

...

SwingBench is a free load generator and benchmark utility designed by Dominic Giles to stress test an Oracle database (10g,11g,12c).  SwingBench version 2.5.0.932 has been installed on the Rep Attack source machine in /u01/app/oracle/swingbench. Rep Attack uses SwingBench to generate test data and provide a transaction load for the Dbvisit Replicate. 

REPOE Schema

The Rep Attack RepAttack machines come pre-loaded with an application schema and test data generated by SwingBench that you'll be using to perform the Rep Attack RepAttack exercises.

The schema is called REPOE and it's based on the Order Entry (OE) example schema that comes with Oracle. It's Entity Relationship diagram is shown below.

...

For example, this is the output of the script at the start of Rep AttackRepAttack. The source schema (REPOE) has been created with the tables and loaded with the initial data, while the target schema (also called REPOE) has been created but contains no tables.

...

Info

Sounds funny, but the Rep Attack RepAttack machines don't come with Dbvisit Replicate installed! The first exercise after you have the source and target machines running is to install Dbvisit Replicate.