Oracle GoldenGate Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle GoldenGate Interview Questions

Questions Answers Views Company eMail

what command is used to create the credential store?

Oracle,

how do you enable oracle goldengate for oracle database 11.2.0.4?

Oracle,

what is the passthru mode used for?

Oracle,

why would you segregate the tables in a replication configuration? How would you do it?

Oracle,

what is the purpose of the defgen utility?

Oracle,

how do you view the data which has been extracted from the redo logs?

Oracle,

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?

Oracle,

how to configure credential store in ogg 12c?

Oracle,

what are the different password encryption options available with ogg?

Oracle,

how do you retrieve information from the oracle credential store?

Oracle,

my extract was running fine for a long time. All of a sudden it went down. I started the extract processes after 1 hour. What will happen to my committed transactions that occurred in the database during last 1 hour?

Oracle,

How can we report on long running transactions?

Oracle,

what are the steps required to add a new table to an existing replication setup?

Oracle,

what is the minimum database version which supports integrated delivery?

Oracle,

how do you create a coordinated replicate in ogg 12c?

Oracle,

Post New Oracle GoldenGate Questions

Un-Answered Questions { Oracle GoldenGate }

if have created a replicate process in ogg 12c and forgot to specify discardfile parameter. What will happen?

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?

what are the supplemental logging pre-requisites?

what is a credential store in ogg 12c?

what are the basic resources required to configure oracle goldengate high availability solution with oracle clusterware?

what are the steps required to add a new table to an existing replication setup?

what are some of the key features of goldengate 12c?

what are the most common reasons of an extract process slowing down?

list the minimum parameters that can be used to create the extract process?

what parameters can be used to configure oracle goldengate to extract data from archived redo log files only?

how do you retrieve information from the oracle credential store?

I have configured oracle goldengate integrated capture process using the default values. As the data load increases I see that extract starts lagging behind by an hour (or more) and database performance degrades. How you will resolve this performance issue?

is it possible to start ogg extract at a specific csn?

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?

how do you create a coordinated replicate in ogg 12c?

For More Un-Answered { Oracle GoldenGate } Questions Click Here