ogg for oracle,OGG-01224 Oracle GoldenGate Capture for Oracle, ext1.prm: TCP/IP error 111 (Connect...

GGSCI (primrac1.example.com as [email protected]) 6> view params ./GLOBALSGGSCHEMA ggcwCHECKPOINTTABLE ggcw.CKPTAB

GGSCI (primrac1.example.com as [email protected]) 7> view params mgrPORT 7809AUTORESTART EXTRACT *, RETRIES 150, WAITSECONDS 1, RESETMINUTES 60

Veera-Oracle wrote:Please share the report file of the Extract and Target manager process. Also, below output from the relocated OGG node,ggsci >view params ./GLOBALSggsci >view params mgrRegards,Veera

****************************EXT1.rpt  *******************************************                 Oracle GoldenGate Capture for Oracle    Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO   Linux, x64, 64bit (optimized), Oracle 12c on Sep 29 2018 04:27:52Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.                    Starting at 2019-02-20 10:55:53***********************************************************************Operating System Version:LinuxVersion #1 SMP Fri Jun 15 17:57:37 EDT 2018, Release 3.10.0-862.6.3.el7.x86_64Node: primrac1.example.comMachine: x86_64                         soft limit   hard limitAddress Space Size   :    unlimited    unlimitedHeap Size            :    unlimited    unlimitedFile Size            :    unlimited    unlimitedCPU Time             :    unlimited    unlimitedProcess id: 35269Description: *************************************************************************            Running with the following parameters                  *************************************************************************2019-02-20 10:55:53  INFO    OGG-03059  Operating system character set identified as UTF-8.2019-02-20 10:55:53  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.2019-02-20 10:55:53  INFO    OGG-01360  EXTRACT is running in Integrated mode.2019-02-20 10:55:54  INFO    OGG-01889  Flush size (max message size) is set to 27,985.EXTRACT ext1USERID ggcw, PASSWORD ***RMTHOST gghost.example.com, MGRPORT 7809RMTTRAIL ./dirdat/rtTABLE marik.table1;2019-02-20 10:55:54  INFO    OGG-01815  Virtual Memory Facilities for: BR    anon alloc: mmap(MAP_ANON)  anon free: munmap    file alloc: mmap(MAP_SHARED)  file free: munmap    target directories:    /GG_HOME/home_1/BR/EXT1.Bounded Recovery Parameter:BRINTERVAL = 4HOURSBRDIR      = /GG_HOME/home_1/2019-02-20 10:55:54  INFO    OGG-01851  filecaching started: thread ID: 140081838638848.2019-02-20 10:55:54  INFO    OGG-01815  Virtual Memory Facilities for: COM    anon alloc: mmap(MAP_ANON)  anon free: munmap    file alloc: mmap(MAP_SHARED)  file free: munmap    target directories:    /GG_HOME/home_1/dirtmp.Database Version:Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - ProductionDatabase Language and Character Set:NLS_LANGUAGE     = "AMERICAN" NLS_TERRITORY    = "AMERICA" NLS_CHARACTERSET = "AL32UTF8" 2019-02-20 10:55:55  INFO    OGG-06604  Database ORCLDG CPU info: CPU Count 16, CPU Core Count 16, CPU Socket Count 1.2019-02-20 10:55:56  INFO    OGG-02248  Logmining server DDL filtering enabled.2019-02-20 10:55:57  INFO    OGG-02068  Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.2019-02-20 10:55:57  INFO    OGG-02089  Source redo compatibility version is: 18.0.0.2019-02-20 10:55:57  INFO    OGG-02086  Integrated Dictionary will be used.2019-02-20 10:55:57  WARNING OGG-02905  Replication of OID column in object tables may diverge.Source Context :  SourceModule            : [ggnet.tcprtn]  SourceID                : [/scratch/aime/adestore/views/aime_adc2280123/oggcore/OpenSys/src/gglib/ggnet/tcprtn.c]  SourceMethod            : [opt_negotiate]  SourceLine              : [4669]  ThreadBacktrace         : [12] elements                          : [/GG_HOME/home_1/libgglog.so(CMessageContext::AddThreadContext())]                          : [/GG_HOME/home_1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]                          : [/GG_HOME/home_1/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition))]                          : [/GG_HOME/home_1/extract(opt_negotiate(int, char (&) [2048]))]                          : [/GG_HOME/home_1/extract()]                          : [/GG_HOME/home_1/extract()]                          : [/GG_HOME/home_1/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]                          : [/GG_HOME/home_1/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]                          : [/GG_HOME/home_1/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]                          : [/GG_HOME/home_1/extract(main)]                          : [/lib64/libc.so.6(__libc_start_main)]                          : [/GG_HOME/home_1/extract()]2019-02-20 10:55:57  ERROR   OGG-01224  TCP/IP error 111 (Connection refused), endpoint: gghost.example.com:7809.2019-02-20 10:55:57  ERROR   OGG-01668  PROCESS ABENDING.