Oracle Golden Gate Interview Questions
Q.What are some of the key features of GoldenGate 12c?
The following are some of the more interesting features of Oracle GoldenGate 12c:
Q.What are the installation options available in OGG 12c?
- Support for Multitenant Database
- Coordinated Replicat
- Integrated Replicat Mode
- Use of Credential store
- Use of Wallet and master key
- Trigger-less DDL replication
- Automatically adjusts threads when RAC node failure/start
- Supports RAC PDML Distributed transaction
- RMAN Support for mined archive logs
You can install Oracle GoldenGate 12c using in 2 ways:
Q.What is a Credential Store in OGG 12c?
- Interactive Installation with OUI – Graphical interface
- Silent Installation with OUI – Command Interface
OGG Crendential Store manages Encrypted Passwords and USERIDs that are used to interact with the local database and Associate them with an Alias. Instead of specifying actual USERID and Password in a command or a parameter file, you can use an alias. The Credential Store is implemented as an autologin wallet within the Oracle Credential Store Framework (CSF).
Q.How to configure Credentail Store in OGG 12c?
Steps to configure Oracle Credential Store are as follows:
- By Default Credential Store is is located under “dircrd” directory. If you want to specify a different location use can specidy “CREDENTIALSTORELOCATION” parameter in GLOBALS file.
Example: CREDENTIALSTORELOCATION /u01/app/oracle/OGG_PASSWD
- Goto OGG home and connect to GGSCI.
Q.What command is used to create the credential store?
How do you add credentials to the credential store?
ALTER CREDENTIALSTORE ADD USER userid,
Example: GGSCI> ALTER CREDENTIALSTORE ADD USER GGS@orcl, PASSWORD oracle ALIAS extorcl DOMAIN OracleGoldenGate
Q.How do you retrieve information from the Oracle Credential Store?
GGSCI> INFO CREDENTIALSTORE
GGSCI> INFO CREDENTIALSTORE DOMAIN OracleGoldenGate
Q.What are the different data encyption methods available in OGG 12c?
In OGG 12c you can encrypt data with the following 2 methods:
Q.How do you enable Oracle GoldenGate for Oracle database 188.8.131.52?
- Encrypt Data with Master Key and Wallet
- Encrypt Data with ENCKEYS
The database services required to support Oracle GoldenGate capture and apply must be enabled explicitly for an Oracle 184.108.40.206 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.
Q.How does the Replicat works in a Coordinated Mode?
In a Coordinated Mode Replicat operates as follows:
- Reads the Oracle GoldenGate trail.
- Performs data filtering, mapping, and conversion.
- Constructs SQL statements that represent source database DML or DDL transactions (in committed order).
Q.What is the difference between Classic and Coordinated Replicat?
- Applies the SQL to the target through the SQL interface that is supported for the given target database, such as ODBC or the native database interface.
The difference between classic mode and coordinated mode is that Replicat is multi-threaded in coordinated mode. Within a single Replicat instance, multiple threads read the trail independently and apply transactions in parallel. Each thread handles all of the filtering, mapping, conversion, SQL construction, and error handling for its assigned workload. A coordinator thread coordinates the transactions across threads to account for dependencies among the threads.
Q.How do you create a COORDINATED REPLICATE in OGG 12c?
You can create the COORDINATED REPLICATE with the following OGG
ADD REPLICAT rfin, COORDINATED MAXTHREADS 50, EXTTRAIL dirdat/et
Q.If have created a Replicat process in OGG 12c and forgot to specify DISCARDFILE parameter. What will happen?
Starting with OGG 12c, if you don’t specify a DISCARDFILE OGG process now generates a dicard file with default values whenever a process is started with START command through GGSCI.
Q.Is it possible to start OGG EXTRACT at a specific CSN?
Yes, Starting with OGG 12c you can now start Extract at a specific CSN in the
transaction log or trail.
START EXTRACT fin ATCSN 12345
START EXTRACT finance AFTERCSN 67890
contact for more on Oracle Golden Gate Online Training
Oracle Golden Gate interview questions Tags
oracle golden gate interview questions and answers,oracle golden gate online training, oracle golden gate interview questions, oracle golden gate training online, oracle golden gate training, oracle golden gate training institute, latest oracle golden gate interview questions, best oracle golden gate interview questions 2019, top 100 oracle golden gate interview questions,sample oracle golden gate interview questions,oracle golden gate interview questions technical, best oracle golden gate interview tips, best oracle golden gate interview basics, oracle golden gate Interview techniques, oracle golden gate Interview Tips.
For online training videos