RE: Can't get GG Extract restarted

show parameter streams_pool_size;
select * from dba_capture;

Binh Le

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sandra Becker Sent: Thursday, August 4, 2022 5:18 PM
To: curtisbl_at_gmail.com
Cc: oracle-l <oracle-l_at_freelists.org> Subject: Re: Can't get GG Extract restarted

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** I'm not sure.

On Thu, Aug 4, 2022 at 3:17 PM <curtisbl_at_gmail.com<mailto:curtisbl_at_gmail.com>> wrote: 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<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto: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<mailto: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.

--

Sandy B.
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 05 2022 - 02:53:17 CEST