• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

GoldenGate

Script to Automatically Start GoldenGate

by admin

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, […]

Filed Under: GoldenGate, oracle

Create an output file from GGSCI commands

by admin

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 […]

Filed Under: GoldenGate, oracle

How To Run ggsci In “silent” Mode

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle Golden gate GGSCI commands quick reference (Cheat Sheet)

by admin

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 […]

Filed Under: GoldenGate, oracle

How to pass a value from shell script to GoldenGate replicat for mapping to target table column

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: How to start Extract & Replicat using Shell Script

by admin

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 […]

Filed Under: GoldenGate, oracle

Primary Sidebar

Recent Posts

  • qemu-system-x86_64: command not found
  • timedatectl: command not found
  • mpirun.openmpi: command not found
  • startkde: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright