Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South
and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't
make it this year, check out TidalScale at www.tidalscale.com. Be
sure to click on the Solutions link and look through the Oracle resources.
The concept behind this page is to combine documentation for GoldenGate installations for Oracle 220.127.116.11
through 18.104.22.168 databases with information about command syntax and examples.
GoldenGate configuration is primarily a matter of putting the correct parameters into .prm files in the correct order and the number of parameters is far too voluminous to cover here at this time.
In the future this will stabilize on just Oracle Database 18c and GoldenGate 12.3 or above.
Pre-Installation Environment Prep
GG software owner's environment
Unzipped install files
Post installation GGHOME directory files
Installation Step 1 of 6
Installation Step 2 of 6
Even when the GGHOME environment variable is set the software location ignores it and must be fixed
Installation Step 3 of 6
Review to make sure things are configured properly. Then save the response file to document your installation choices.
Installation Step 4 of 6
A good practice is to save the response files into the directory /home/oracle and then to place a copy into your change control
Installation Step 5 of 6
Installation Step 6 of 6
Unzipped install files
SQL> conn / as sysdba
ALTER DATABASE FORCE LOGGING;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER SYSTEM SET enable_goldengate_replication=TRUE
COMMENT='Enabled GG Replication 15-MAR-2105 DAM'
GGSCI> info PONLINE4, showch
GGSCI (dc2sfdb02) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
Create a new pump process where the extract process already exists
ADD EXTRACT <pump_process_name>, exttrailsource <path>, begin now
GGSCI> add extract uwpumpdb, exttrailsource /u01/app/oracle/product/gg/dirdat/a1, begin now
-- edit the parameter file for the pump process to have the following contents:
userid gg, password gg
rmthost ggtargethost, mgrport 7809
-- execute the following ggsci commands on the source server:
GGSCI> add rmttrail /u01/app/oracle/product/gg/dirdat/a1, extract uwpumpdb
GGSCI> start uwpumpdb
/* After executing the above, start the manager process on the target server (ggtargethost) and the pump process will started
propagating data to the rmttrail files */