• 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

Oracle GoldenGate: GLOBALS Sample Parameter File

by admin

This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup in line with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. The GLOBALS file stores parameters that relate to the GoldenGate […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Replicat Sample Parameter File

by admin

This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Replicat Process The replicate process is the apply process within an Oracle […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Pump (Extract) Sample Parameter File

by admin

This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Pump (Extract) Process The data pump group is a secondary extract group […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Extract Sample Parameter File

by admin

This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Extract Process The extract process of Oracle GoldenGate is used to perform […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Manager Sample Parameter File

by admin

This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Manager Process The manager process is not the most talked about […]

Filed Under: GoldenGate, oracle

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

Next Page »

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright