OGG-01224 Address already in use OGG-01668 PROCESS ABENDING

Hi,

Sometimes you can get ” OGG-01224 Address already in use ” error during the first installation of Goldengate and configuration of manager process.

Details of error are as follows.

                          : [./mgr(init_functions(int, char**))]
                          : [./mgr(main_loop(int, char**))]
                          : [./mgr()]
                          : [./mgr(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [./mgr(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                          : [./mgr(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [./mgr(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [./mgr()]

2020-04-13 20:05:01  ERROR   OGG-01224  Address already in use.

2020-04-13 20:05:01  ERROR   OGG-01668  PROCESS ABENDING.

GGSCI (goldendp01) 6> view params mgr
PORT 7880
DYNAMICPORTLIST 7800-9860

PURGEOLDEXTRACTS /ggate01/dirdat/* , USECHECKPOINTS , MINKEEPHOURS 2
AUTOSTART ER *
AUTORESTART ER * , RETRIES 3, WAITMINUTES 5

Start it, if you got ” OGG-01224 Address already in use ” then it means you used the static PORT parameter, and this port is busy

GGSCI (goldenmsd01) 3> start mgr
Manager started.


GGSCI (goldenmsd01) 4> info mgr

Manager is DOWN!

To solve this problem , remove the PORT 7880 as follows.

GGSCI (goldenmsd01) 6> view params mgr

DYNAMICPORTLIST 7800-9860

PURGEOLDEXTRACTS /ggate01/dirdat/* , USECHECKPOINTS , MINKEEPHOURS 2
AUTOSTART ER *
AUTORESTART ER * , RETRIES 3, WAITMINUTES 5

Now start it again.

GGSCI (goldenmsd01) 2> start mgr
Manager started.

GGSCI (goldenmsd01) 3> info mgr

Manager is running (IP port TCP:goldenmsd01.7809, Process ID 93269).

If you use the static port, and if it is busy, you can find and kill its process as follows.

[ggate@goldenmsd01 GG19cFor18cDB]$ netstat -nap | grep 7880
(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 :::7880                     :::*                        LISTEN      138316/replicat

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/