...
| No Format |
|---|
ttorcl_src =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
ttorcl_trg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = target)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
) |
| Tip |
|---|
| If you want to use these 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. |
Database User Passwords
These are the same on both the source and target databases. The passwords set not to expire and are case sensitive in lowercase.
| Username | Password |
|---|---|
| SYS | change_on_install |
| SYSTEM | manager |
| REPOE | repoe |
| Tip |
|---|
If you want to use these 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. |
ARCHIVELOG Mode
One of the requirements for Dbvisit Replicate is that the source database be in ARCHIVELOG mode. The database on the Rep Attack 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.
| Warning |
|---|
There is no automatic deletion of the archived redo log files from the source database. |
The database on the Rep Attack target machine is not in ARCHIVELOG mode.
SwingBench
SwingBench is a free load generator and benchmark utility designed by Dominic Giles to stress test an Oracle database (10g,11g,12c). Rep Attack . 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 machines come pre-loaded with an application schema and test data generated by SwingBench that you'll be using to perform the Rep Attack exercises.
...
| No Format |
|---|
oewizard -cl -create -cs //source-int/orclXE -scale 0.5 -u repoe -p repoe -ts users -tc 7 -v -dba system -dbap manager |
...