How Do You Enable Oracle Goldengate For Oracle Database 11.2.0.4?

1.	How Do You Enable Oracle Goldengate For Oracle Database 11.2.0.4?
Answer» The database services REQUIRED to support ORACLE GoldenGate capture and apply must be ENABLED explicitly for an Oracle 11.2.0.4 database. This is required for all modes of Extract and Replicat. To ENABLE Oracle GoldenGate, SET the following database initialization parameter. All instances in Oracle RAC must have the same setting. ENABLE_GOLDENGATE_REPLICATION=true The database services required to support Oracle GoldenGate capture and apply must be enabled explicitly for an Oracle 11.2.0.4 database. This is required for all modes of Extract and Replicat. To enable Oracle GoldenGate, set the following database initialization parameter. All instances in Oracle RAC must have the same setting. ENABLE_GOLDENGATE_REPLICATION=true

Answer»

The database services REQUIRED to support ORACLE GoldenGate capture and apply must be ENABLED explicitly for an Oracle 11.2.0.4 database. This is required for all modes of Extract and Replicat.

To ENABLE Oracle GoldenGate, SET the following database initialization parameter. All instances in Oracle RAC must have the same setting.

ENABLE_GOLDENGATE_REPLICATION=true

The database services required to support Oracle GoldenGate capture and apply must be enabled explicitly for an Oracle 11.2.0.4 database. This is required for all modes of Extract and Replicat.

To enable Oracle GoldenGate, set the following database initialization parameter. All instances in Oracle RAC must have the same setting.

ENABLE_GOLDENGATE_REPLICATION=true

Discussion

No Comment Found

Related InterviewSolutions

We Want To Setup One-way Data Replication For My Online Transaction Processing Application. However There Are Compressed Tables In The Environment. Please Suggest How I Can Achieve It?
I Am Migrating My Oracle Database From Non-exadata To Exadata But My Source Ogg Software And Target Ogg Software Versions Are Different (say Source Is Running Ogg 11.1 And Target Is Running Ogg 11.2). How Can I Configure My Ogg Process To Work In Such Configuration?
What Are The Different Ogg Initial Load Methods Available?
I Have A Table Called ‘test’ On Source And Target With Same Name, Structure And Data Type But In A Different Column Order. How Can You Setup Replication For This Table?
What Is The Best Practice To Delete The Extract Files In Ogg?
What Parameters Can Be Used To Configure Oracle Goldengate To Extract Data From Archived Redo Log Files Only?
I Have A One-way Replication Setup. The System Administration Team Wants To Apply An Os Patch To Both The Ogg Source Host And The Target Servers. Provide The Sequence Of Steps That You Will Carry Before And After Applying This Patch?
What Are The Basic Resources Required To Configure Oracle Goldengate High Availability Solution With Oracle Clusterware?
What Is The Purpose Of The Defgen Utility?
How Do You Create A Csv File From The Extracted Data?