At the end of this post we should have a working Goldengate environment where we can replicate a dummy table. High level steps: Install an Oracle database (19c) Install Goldengate 21c (source and destination will be on the same machine in my case) (You can follow this post: ora-base.com/how-to-install-goldengate-21c-in-silent-mode Create the source and destination pluggable…
Usually we do the installation using the graphical interface. Let’s try this time the silent mode: This is my environment: Download the software from: https://www.oracle.com/middleware/technologies/goldengate-downloads.html#license-lightbox Copy the file to a staging location on the server. In my case will be “/u01/software”: Step 1) Unzip the software Step 2) Create Response File This is my response…
Let’s create the sample schema HR in a new PDB Step 1 ) Navigate to the DEMO folder Step 2 ) Connect to the PDB and execute the “hr_main.sql” This is going to create the HR user into the PDB Step 3 ) Let’s connect as HR and check the tables
