Sample script to start Oracle GoldenGate processes in an automated way. This script can come in handy to DBA/admins who are a little lazy like me to run multiple commands to start the GoldenFate processes. 1. Here is an example of simple script: $ cat start_goldengate.sh cd /home/oracle/goldengate ./ggsci < EOF OBEY /home/oracle/goldengate/startup.txt EOF Here, […]
GoldenGate
Create an output file from GGSCI commands
1. Create a shell script: ggsci_out.sh. It should contain the following: ./ggsci < {parameter file} >{output file} example: $ vim ggsci_out.sh ./ggsci >ggsci_out.list 2. The shell script access mode must be executible $ chmod +x ggsci_out.sh 3. Create a parameter file that contains the desired ggsci command. Example for INFO TRANDATA command: $ vim ggsci.prm […]
How To Run ggsci In “silent” Mode
Question: Like sqlplus -S, how does one suppress the ggsci banner and extraneous output? Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise. It moves committed transactions from redo logs and maintains transaction integrity with sub-second latency. Its reliability is especially critical for enabling […]
Oracle Golden gate GGSCI commands quick reference (Cheat Sheet)
Oracle GoldenGate Components Manager: Is required to start and stop the other processes, but is not required for the ongoing operation of another process. That is, you can start the Manager, use the Manager to start the Extract, and then stop and restart the Manager (perhaps to pick up new Manager configuration parameters) without affecting […]
How to pass a value from shell script to GoldenGate replicat for mapping to target table column
The value must be assigned to an environment variable and the replicat must be started from the OS command line and not within GGSCI. Example: Start the replicat via the command line as part of the script and not calling GGSCI inside the script. If GGSCI is called to start replicat it will not recognize […]
Oracle GoldenGate: How to start Extract & Replicat using Shell Script
For simple commands, you can “pipe” the output of one command to GGSCI’s input; for example: $ echo “start EAIOU” | ggsci will issue the “start EIAOU” command to GGSCI. GGSI’s messages will appear on the terminal. For more than one command, you can either use the above with an OBEY command, or redirect the […]