Tuesday, February 17, 2015

Goldengate Extract is not moving?

Hi guys,
 when your extract is not collecting transactions against source table (or) it is not moving against database ? 


 To find out resolution..Kindly investigate following steps
step1: check trandata is enabled for your source table?
ggsci> dblogin userid ggsuser password XXXXXggsci> info trandata schema.tablename


step2: check there is any long running transactions on your database or blocking sessions, try to skip transactions using XID 
 After making sure these 2 steps
 using logdump utility, kindly validate extract is collecting data and writing data on  local trail

Thank you --- Nikhil Tatineni ---

By -

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...

  • Skip transaction GoldenGate replicat 12c
    syntax for skipping transaction # ggsci> start replicat skiptransaction  GGSCI (red.gg.ora.com) 14> info all Program     St...
  • ORA-24324, ORA-24323, ORA-01090
    scenario # trying to startup / shutdown database encountered with following error # ORA-24324: service handle not initialized ORA-243...
  • ERROR OGG-01454
    Today GoldenGate Extract abended on Servers During my initial investigation,  goldengate error report says as follows  2016-02...