This guide helps you get started with installing, configuring, and running Oracle GoldenGate on an Oracle database system. With Oracle GoldenGate for Oracle, you can:

  • Map, filter, and transform transactional data changes between similar or dissimilar supported Oracle versions, and between supported Oracle versions and other supported types of databases.

  • Replicate and filter Oracle DDL operations between heterogeneous Oracle databases.

  • Perform initial loads to target tables in Oracle or other databases to instantiate a synchronized replication environment.

This documentation is meant to be a step by step guide in establishing a basic Oracle GoldenGate configuration, from source to target, that is tailored to the Oracle environment. It should be followed in a linear fashion, as appropriate for the capture and apply methods that you select, so that you benefit from important information in previous sections. It is not meant to be used as a reference document. Where needed, it points you to other documentation where you can find additional information to expand the configuration to suit your needs.


This guide is intended for installers, database administrators, and system administrators who are installing, configuring and running Oracle GoldenGate.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.


The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, such as "From the File menu, select Save." Boldface also is used for terms defined in text or in the glossary.


Italic type indicates placeholder variables for which you supply particular values, such as in the parameter statement: TABLE table_name. Italic type also is used for book titles and emphasis.


Monospace type indicates code components such as user exits and scripts; the names of files and database objects; URL paths; and input and output text that appears on the screen. Uppercase monospace type is generally used to represent the names of Oracle GoldenGate parameters, commands, and user-configurable functions, as well as SQL commands and keywords.
UPPERCASE Uppercase in the regular text font indicates the name of a utility unless the name is intended to be a specific case.
{ } Braces within syntax enclose a set of options that are separated by pipe symbols, one of which must be selected, for example: {option1 | option2 | option3}.
[ ] Brackets within syntax indicate an optional element. For example in this syntax, the SAVE clause is optional: CLEANUP REPLICAT group_name [, SAVE count]. Multiple options within an optional element are separated by a pipe symbol, for example: [option1 | option2].