Re: Can't get GG Extract restarted

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 4 Aug 2022 15:18:08 -0600
Message-ID: <CAJzM94AwiPKgy6n=4MmG8xCbw22svcB=Zj9Zfs-F_cN4oENhWQ_at_mail.gmail.com>



I'm not sure.

On Thu, Aug 4, 2022 at 3:17 PM <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 <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.
>

-- 
Sandy B.

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

Original text of this message