Versions Compared

Key

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

...

Each machine has the default Oracle XE database installed it as it's default configuration. The default database installed with Oracle XE always has the ORACLE_SID of XE but to make it less confusing between the source and target databases, two TNS alias have been set up in the tnsnames.ora files of both the source and target machines.

...

Tip
If you want to use these tns TNS entries on your host machine to connect to the databases, you will have to place source and target entries into the hosts file on the host machine or replace the hostnames with the hardcoded IP addresses.

...

These are the same on both the source and target databases. The passwords are set not to expire and are case sensitive in lowercase.

...

One of the requirements for Dbvisit Replicate is that the source database be in ARCHIVELOG mode. The database on the Rep Attack RepAttack source machine has been placed into ARCHIVELOG mode and is using the USE_DB_RECOVERY_FILE_DEST as it's archive destination which is /u01/app/oracle/fast_recovery_area and has been sized at 10 Gb.

...

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 RepAttack source machine in /u01/app/oracle/swingbench. Rep Attack  RepAttack uses SwingBench to generate test data and provide a transaction load for the Dbvisit Replicate. 

...

In the $HOME/replicate directory of the oracle user on the source machine is a script called run_swingbench.bash. This script is used on the source machine to generate DML transactions against the REPOE schema so Dbvisit Replicate has something to do.

...