Find us on Google+ Google+

October 20, 2012

Oracle GoldenGate Interview Questions/FAQs

Oracle Golden Gate (OGG) Interview Questions/FAQs


1. What is GoldenGate and how to setup Golden Gate?


2. What are processes/components in Golden Gate?

Manager, Extract, Replicat, Data Pump

3. What is Data Pump process in Golden Gate?

4. What is the command line utility in GoldenGate (or) what is ggsci?


5. What is the default port for Golden Gate Manager process?

7809

6. What are important files Golden Gate?

GLOBALS, ggserr.log, dirprm, etc ...

7. What is checkpoint table?


8. How can you see Golden Gate errors?

ggsci> VIEW GGSEVT
ggserr.log file

9. What is the difference between classical extract and integrated extract?


10. What is the difference between classical replicat and coordinated replicat?

11. How you will check whether replication is bidirectional or not?

Related Articles: Oracle DBA Interview Questions/FAQs – Part3   Oracle PL/SQL Interview Questions/FAQs   Oracle Performance related interview Questions/FAQs

1 comment:

  1. Merhaba,

    I’ve often thought about this Oracle GoldenGate Interview Questions/FAQs. Nice to have it laid out so clearly. Great eye opener.

    I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So, if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be beginning to show 3-11-16. Is that possible?
    A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that cannot be accessed by other procedures.

    Appreciate your effort for making such useful blogs and helping the community.

    Obrigado,
    John

    ReplyDelete