Tuesday, March 22, 2016

GoldenGate ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031


Problem Summary & Problem Description 
Developers started to  perform DML operation on Huge Volume tables, 
Oracle Goldengate Extract Abended with Error OGG-00665. 

 Errors in Report File as follows
2016-03-21 09:44:31 ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","SELECT banner FROM v$version","sga heap(1,0)
","kglsim heap")), SQL<Not available>.
2016-03-21 09:44:31 ERROR OGG-01668 PROCESS ABENDING.

 Resolution:
we increased memory structure "SGA" for database, issue is resolved

 --Nikhil Tatineni--
--Oracle GoldenGate--
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...