Total Pageviews

Saturday 30 July 2016

ERROR OGG-01232 Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: node2:7819.

GGSCI (node1.localdomain) 2> view report dphr01 , detail


***********************************************************************
                 Oracle GoldenGate Capture for Oracle
   Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Aug  7 2014 09:31:26

Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2016-07-30 06:55:59
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Fri Feb 22 18:16:18 PST 2013, Release 2.6.39-400.17.1.el6uek.x86_64
Node: node1.localdomain
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 8384

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2016-07-30 06:55:59  INFO    OGG-03059  Operating system character set identified as UTF-8.

2016-07-30 06:55:59  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT DPHR01
PASSTHRU
RMTHOST node2 , MGRPORT 7809
RMTTRAIL dirdat/hr
TABLE HR.* ;

2016-07-30 06:55:59  INFO    OGG-01851  filecaching started: thread ID: 139969427404544.

2016-07-30 06:55:59  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:
    /data01/oracle/ggs/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                               64G
CACHEPAGEOUTSIZE (default):               8M
PROCESS VM AVAIL FROM OS (min):         128G
CACHESIZEMAX (strict force to disk):     96G

2016-07-30 06:56:04  INFO    OGG-01226  Socket buffer size set to 27985 (flush size 27985).

2016-07-30 06:56:04  INFO    OGG-01052  No recovery is required for target file dirdat/hr000000, at RBA 0 (file not opened).

2016-07-30 06:56:04  INFO    OGG-01478  Output file dirdat/hr is using format RELEASE 12.1.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

Opened trail file dirdat/hr000000 at 2016-07-30 06:56:04

Switching to next trail file dirdat/hr000001 at 2016-07-30 06:56:04 due to EOF, with current RBA 1411
Opened trail file dirdat/hr000001 at 2016-07-30 06:56:04


Switching to next trail file dirdat/hr000002 at 2016-07-30 06:56:04 due to EOF, with current RBA 1472
Opened trail file dirdat/hr000002 at 2016-07-30 06:56:04


Source Context :
  SourceModule            : [er.extrout]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/app/er/extrout.c]
  SourceFunction          : [complete_tcp_msg]
  SourceLine              : [1663]
  ThreadBacktrace         : [17] elements
                          : [/data01/oracle/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f4d37239dce]]
                          : [/data01/oracle/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f4d37234ae0]]
                          : [/data01/oracle/ggs/libgglog.so(_MSG_ERR_TCP_RECEIVE_PARAMS_ERROR(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [
0x7f4d3721642b]]
                          : [/data01/oracle/ggs/extract(complete_tcp_msg(extract_def*)+0x711) [0x55540d]]
                          : [/data01/oracle/ggs/extract(flush_tcp(extract_def*, int)+0x23a) [0x555660]]
                          : [/data01/oracle/ggs/extract(flush_buffers(int)+0x5c) [0x54f4fc]]
                          : [/data01/oracle/ggs/extract(checkpoint_extract_info(chkpt_context_t*)+0x20) [0x54f520]]
                          : [/data01/oracle/ggs/extract(checkpoint_status(short, short, long)+0x179) [0x5a93d9]]
                          : [/data01/oracle/ggs/extract(check_messages(chkpt_context_t*, short, char const*, bool)+0x1197) [0x58a5c7]]
                          : [/data01/oracle/ggs/extract(process_extract_loop()+0x19a4) [0x5b9854]]
                          : [/data01/oracle/ggs/extract(extract_main(int, char**)+0x418) [0x5b6aa8]]
                          : [/data01/oracle/ggs/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a1e2f]]
                          : [/data01/oracle/ggs/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a2334]
]
                          : [/data01/oracle/ggs/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a26fb]]
                          : [/data01/oracle/ggs/extract(main+0x3f) [0x5b643f]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3a6181ecdd]]
                          : [/data01/oracle/ggs/extract() [0x52ad09]]

2016-07-30 07:06:51  ERROR   OGG-01232  Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: node2:7819.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************


Report at 2016-07-30 07:06:51 (activity since 2016-07-30 06:55:59)
Output to dirdat/hr:
No records extracted.
Last log location read:
     FILE:      dirdat/hr000002
     SEQNO:     2
     RBA:       1472
     TIMESTAMP: Not Available
     EOF:       YES
     READERR:   400

2016-07-30 07:06:51  ERROR   OGG-01668  PROCESS ABENDING.

Cause :

Target site /etc/host file contains an INVALID id for localhost

Solution :

1. Check /etc/hosts and remove the below  highlighted line from and restart MGR process on target :

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6   ---> Remove this entry for localhost 

192.168.10.1 node1-priv.localdomain.com node1-priv
192.168.10.2 node2-priv.localdomain.com node2-priv

192.168.56.71 node1.localdomain node1
192.168.56.72 node2.localdomain node2

192.168.56.81 node1-vip.localdomain node1-vip
192.168.56.82 node2-vip.localdomain node2-vip

192.168.56.91 node-scan.localdomain node-scan
192.168.56.92 node-scan.localdomain node-scan
192.168.56.93 node-scan.localdomain node-scan

2. Restart MGR on target node

3. Start Extract process and check the status :
GGSCI (node1.localdomain) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     DPHR01      00:00:00      00:00:01  
EXTRACT     RUNNING     EXHR01      05:01:28      00:00:01  

1 comment:

  1. Jadwal Pertandingan Ayam SV388 7 Maret 2019 - Jumat, Lombok 8 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete