Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OGG 18.1 passive pump

user2326348Mar 13 2019

Hi,

I'm using passive pump in classic architecture (yes, I've read it will not be supported in future versions, but it should work in 18.1)

I've just downloaded the last OGG for windows

ERROR   OGG-00433  No RMTHOST has been specified yet

when starting the pump from the target, it abends immediately.

Source Context :

  SourceModule            : [er.extract.init]

  SourceID                : [er/extract/extinit.cpp]

  SourceMethod            : [EXTINIT_get_ext_params]

  SourceLine              : [1714]

  ThreadBacktrace         : [11] elements

                          : [C:\OGG\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ)]

                          : [C:\OGG\gglog.dll(?_MSG_@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z)]

                          : [C:\OGG\extract.exe(_ggTryDebugHook)]

                          : [C:\OGG\extract.exe(<18\extract.exe)]

                          : [C:\OGG\extract.exe(<18\extract.exe)]

                          : [C:\OGG\extract.exe(_ggTryDebugHook)]

                          : [C:\OGG\extract.exe(<18\extract.exe)]

                          : [C:\OGG\extract.exe(CommonParserNewSSD)]

                          : [C:\OGG\extract.exe(_ggTryDebugHook)]

                          : [C:\WINDOWS\System32\KERNEL32.DLL(BaseThreadInitThunk)]

                          : [C:\WINDOWS\SYSTEM32\ntdll.dll(RtlUserThreadStart)]

2019-03-13 16:43:13  ERROR   OGG-00433  No RMTHOST has been specified yet.

2019-03-13 16:43:13  ERROR   OGG-01668  PROCESS ABENDING.

it was working on OGG 12.2 and 12.3

workaround : I've deleted this line in the pump parameter file :

RMTHOSTOPTIONS timeout 60

18.1 documentation is still saying that RMTHOSTOPTIONS is for passive pump and can't be used with RMTHOST

Can you give me a method to set the timeout, so I don't have to wait 5 minutes for some networks problems ?

ERROR: STOP is not allowed against a passive group.

I've got this error when on the source I run a stop command on the passive extract

It was working with OGG 12.2 and 12.3, I use it in case of change of configuration.

I understand why I've got such an error on a start (you don't know the host to be join), but not for the stop.

I haven't found a change in documentation about this... can you give me a better workaround than using the kill command instead of stop ?

Thanks a lot

Pierre

configuration

version

Oracle GoldenGate Command Interpreter for Oracle

Version 18.1.0.0.0 OGGCORE_18.1.0.0.0PHASE2_PLATFORMS_RELEASE_FBO

Windows x64 (optimized), Oracle 11g on Feb 23 2019 13:04:42

Operating system character set identified as windows-1252.

source server (ip 192.168.1.1, manager running on port 7809)

mkdir dirdat\x2

.\ggsci.exe

GGSCI > view param pd1

EXTRACT PD1

USERID GG@oggSrc, PASSWORD GG

RMTTRAIL dirdat\PD1\pd

RMTHOSTOPTIONS timeout 60

table hr.emp;

GGSCI > view param x2

EXTRACT X2

USERID GG@oggSrc, PASSWORD GG

EXTTRAIL dirdat\X2\x2

table hr.emp;

ADD EXTRACT X2, TRANLOG, BEGIN NOW

ADD EXTTRAIL dirdat\X2\x2, EXTRACT X2

ADD EXTRACT PD1, TRANLOG, BEGIN NOW,EXTTRAILSOURCE dirdat\X2\x2, PASSIVE

ADD RMTTRAIL dirdat\PD1\pd, EXTRACT PD1

target server

mkdir dirdat\Pd

.\ggsci.exe

ADD EXTRACT PD1, rmthost 192.168.1.1,mgrport 7809

Comments
Post Details
Added on Mar 13 2019
0 comments
477 views