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.
If you don’t know how to install and configure of Oracle Goldengate, then read the following post.
Display the manager parameters.
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/