Wednesday, November 11, 2015

Delete Unused Process in Goldengate

Scenario: When you are  decommissioning goldengate, we need to purge unused process in goldengate. In order to decommission the goldengate process we need to perform dblogin and delete the process from goldengate home 

For example:  decommissioning replicat from goldengate home 
GGSCI (tnc61.ffdc.com) 8> dblogin USERID GGSUSER, PASSWORD oracle
Successfully logged into database.

GGSCI (tnc61.ffdc.com as GGSUSER@bond07p) 9> delete REORD117
Deleted REPLICAT REORD117.


----Nikhil Tatineni--
----Oracle In-memory--





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...