A030
Oracle GoldenGate 19c on Two Oracle Databases
An Oracle GoldenGate environment on two databases: Oracle 12c database and Oracle 19c database. They are running on Linux 7 VMs.
Full File size: 21 G
Single File Download:
Readme File:
**********************
* About the VM *
**********************
A two-host environment of Oracle GoldenGate 19c
Source host (ogg1) is an Oracle database 12c on Linux 7
Destination host (ogg2) is an Oracle database 19c
Oracle GoldenGate software installed in each host.
All the databases (12c and 19c) are CDB with one pluggable database in it (pdb1).
It was built and tested using Oracle VirtualBox version 6.0.22
Swingbench schema (soe) installed in the source database.
root password: baraka@2020
oracle password: baraka@2020
system database user password: oracle
By: Ahmed Baraka
Upload version: 1.2
Upload date: 30-Jan-2021
Note: ogg2 is an Oracle 19c built on a 4GB-memory machine. This is less than the minimum acceptable memory for Oracle 19c. If you face memory issues on it, you need to increase its dedicated memory to 6GB.
Note: ogg1 is an Oracle 12c built on a 4GB-memory machine. It is recommended to increase the VM memory to 6 GB.
****************************************
* The Requirements to use the System *
****************************************
Memory: 16 GB free RAM
HDD Free space: 57 GB
Oracle VirtualBox version 6.0.22 or later
*****************************
* HOW TO USE THE MACHINES *
*****************************
1. In the VirtualBox Manager, import ogg1 machine. Initializa the Mac Addresses of the machine.
2. In the VirtualBox Manager, import ogg2 machine. Initializa the Mac Addresses of the machine.
3. Open the settings of ogg1 and change the Adapter name in the Network Adapter to match the network card in your environment.
4. Open the settings of ogg1 and configure a Shared folder in it.
5. Open the settings of ogg2 and change the Adapter name in the Network Adapter to match the network card in your environment.
6. Open the settings of ogg2 and configure a Shared folder in it. Preferably the same one as in ogg1.
7. Start ogg1
8. Start ogg2
9. If you are using a VirtualBox release later than 6.0.22, update the Guest Additions in the machines
10. Make sure the IP address in each host is seen by the other host. To check the IP address of a host, click on Applications -> System Tools -> Settings -> Network -> click on the gear button under the “Wired” box.
11. If you should change the IP address of a host, perform the following:
11.1 Open the network settings and change the IP address of the host in it. Click on Apply button and close the window.
11.2 Turn off the network wired connection then turn it on again.
11.3 Fix the IP address in the /etc/hosts file in EACH host.
*********************************************
* Actions Performed after OS installation *
*********************************************
– Set SELINUX=permissive in /etc/selinux/config
– Disable firewall
– set “UseDNS no” and “GSSAPIAuthentication no” in /etc/ssh/sshd_config (to fix the delay in the login to the system from Putty)