Home -> Mailing Lists -> Oracle-L -> RE: Can't get GG Extract restarted

RE: Can't get GG Extract restarted

From: <curtisbl_at_gmail.com>
Date: Thu, 4 Aug 2022 17:17:40 -0400
Message-ID: <016401d8a847$a15b9df0$e412d9d0$_at_gmail.com> 








Is the extract Integrated or Non-Integrated?  Also what is the STREAMS_POOL_SIZE set to?  It should be set to 1.25G for Integrated Extracts (per extract).

 



Please let me know.

 



Thanks



Bobby

 



From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sandra Becker
Sent: Thursday, August 4, 2022 4:15 PM


To: oracle-l <oracle-l_at_freelists.org>
Subject: Can't get GG Extract restarted

 






Oracle EE 12.1.0.2



GG 12.2



RHEL 6.10


 

We were having issues  with the EXTRACT process consuming large amounts of memory and swap to the point we had 0 swap left and 6GB of memory.  This was not normal behavior.  We decided to bounce the EXTRACT process.  It stopped without any errors, but now it won't restart.  I've searched everywhere I can think of on the error we're getting, but haven't found a solution yet.  We don't have Oracle support, we use Rimini Street.  I have opened a ticket with them, but no answers yet.  Has anyone seen this error before:

 



2022-08-04 19:39:59  ERROR   OGG-00446  No positions processed.



2022-08-04 19:39:59  ERROR   OGG-01668  PROCESS ABENDING.


 

I would appreciate any assistance you can provide.



-- 




Sandy B.





--



http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 04 2022 - 23:17:40 CEST












Original text of this message