Friday, March 6, 2015

Golden Gate: ERROR OGG-01224 Address already in use

PROBLEM:

ERROR OGG-01224 Address already in use.

GGSCI (dc174.ora.com) 34> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
EXTRACT     STOPPED     EXTORA1     00:00:00      00:01:08
EXTRACT     STOPPED     PUMPORA1    00:00:00      00:01:06
GGSCI (dc174.ora.com) 35> start mgr

Manager started.

GGSCI (dc174.ora.com) 37> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
EXTRACT     STOPPED     EXTORA1     00:00:00      00:01:16
EXTRACT     STOPPED     PUMPORA1    00:00:00      00:01:14


GGSCI (dc174.ora.com) 38> view report mgr

Operating System Version:
Linux
Version #1 SMP Mon Sep 30 16:34:30 PDT 2013, Release 2.6.18-371.el5
Node: dc174.ora.com
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: 13933

Parameters...

PORT 7809
SYSLOG NONE


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


Source Context :
  SourceModule            : [mgr.main]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc41502
56/oggcore/OpenSys/src/app/mgr/mgr.c]
  SourceFunction          : [init_functions]
  SourceLine              : [3264]
  ThreadBacktrace         : [8] elements
                          : [/u01/app/gg_home/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b7eee20106e]]
                          : [/u01/app/gg_home/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2b7eee1fd44c]]
                          : [/u01/app/gg_home/libgglog.so(_MSG_ERR_TCP_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2b7eee1e251f]]
                          : [./mgr(init_functions(int, char**)+0x7f5) [0x448235]]
                          : [./mgr(main_loop(int, char**)+0x4c) [0x44e13c]]
                          : [./mgr(main+0xdc) [0x44e8bc]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x
3f5a01d9c4]]
                          : [./mgr(__gxx_personality_v0+0x14a) [0x43a49a]]

2015-01-09 15:20:57  ERROR   OGG-01224  Address already in use.

2015-01-09 15:20:57  ERROR   OGG-01668  PROCESS ABENDING.

PROBLEM:

mgr cannot start. "ERROR   OGG-01224  Address already in use and ERROR   OGG-01668  PROCESS ABENDING." appear in mgr.rpt

CAUSE:

Previous mgr process is still runing, which used port 7809 according to parameter file.

SOLUTION:

as root or Goldengate owner:

# netstat -nap | grep 7809

(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)

tcp        0      0 :::7809                     :::*
LISTEN      29478/./mgr



# kill -9 29478

Restart MGR process.

GGSCI (dc174.ora.com) 1> start mgr
MGR is already running.

GGSCI (dc174.ora.com) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     EXTORA1     00:00:00      00:21:32
EXTRACT     STOPPED     PUMPORA1    00:00:00      00:21:30






No comments:

Post a Comment