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--
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...
-
syntax for skipping transaction # ggsci> start replicat skiptransaction GGSCI (red.gg.ora.com) 14> info all Program St...
-
we use goldengate to replicate data at transaction level :) Goldengate manager: When we configure goldengate replication f...
-
C reate New Linux account: ggs01 SOURCE & TARGET: Verify ggs01 is part of these groups: ggsoper, dba [root@z1p12c ...