Datapump is not starting. WARNING OGG-01221 Connect failed to 10.10.51.38:7819, error 111:Connection refused.

Datapump is not starting

OGG Report showing:
WARNING OGG-01221  Connect failed to 10.20.30.40:7819, error 111:Connection refused.

What to check
=====================
Site A

=====================
oracle@qa-1-dbs-1b>% lsof -i TCP | grep 7819
extract    6917 oracle   17u  IPv4 4553207      0t0  TCP qa-1-dbs-1b:30163->qa-2-dbs-01:7819 (ESTABLISHED)
server    19087 oracle    6u  IPv4 4535342      0t0  TCP *:7819 (LISTEN)
server    19087 oracle   14u  IPv4 4533293      0t0  TCP qa-1-ora-01:7819->qa-2-dbs-01:51406 (ESTABLISHED)

oracle@qa-1-dbs-1b>% lsof -i TCP | grep 51406
server    19087 oracle   14u  IPv4 4533293      0t0  TCP qa-1-ora-01:7819->qa-2-dbs-01:51406 (ESTABLISHED)

oracle@qa-1-dbs-1b>% ps -ef | grep 19087
oracle   19087 15558  0 19:46 ?        00:00:01 ./server -w 300 -p 7819-12818 -m 7809 -k -l /software/ogg/191/ggserr.log

oracle@qa-1-dbs-1b>% ps -ef | grep 6917
oracle    6917 15558  0 19:52 ?        00:00:00 /software/ogg/191/extract PARAMFILE /software/ogg/191/dirprm/dpm_i_01.prm REPORTFILE /software/ogg/191/dirrpt/DPM_I_01.rpt PROCESSID DPM_I_01
oracle    7124  6917  0 19:52 ?        00:00:00 oracleigt (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

=====================
Site B

=====================
oracle@qa-2-dbs-01>% lsof -i TCP | grep 7819
extract   70353 oracle   17u  IPv4 1204012      0t0  TCP qa-2-dbs-01:51406->qa-1-ora-01:7819 (ESTABLISHED)
server    70832 oracle    6u  IPv4 1208335      0t0  TCP *:7819 (LISTEN)
server    70832 oracle   14u  IPv4 1208369      0t0  TCP qa-2-dbs-01:7819->qa-1-dbs-1b:30163 (ESTABLISHED)

oracle@qa-2-dbs-01>% lsof -i TCP | grep 30163
server    70832 oracle   14u  IPv4 1208369      0t0  TCP qa-2-dbs-01:7819->qa-1-dbs-1b:30163 (ESTABLISHED)

oracle@qa-2-dbs-01>% ps -ef | grep 70832
oracle     70832    2703  0 19:52 ?        00:00:00 ./server -w 300 -p 7819-12818 -m 7809 -k -l /software/ogg/191/ggserr.log

oracle@qa-2-dbs-01>% ps -ef | grep 70353
oracle     70353    2703  0 19:46 ?        00:00:01 /software/ogg/191/extract PARAMFILE /software/ogg/191/dirprm/dpm_i_01.prm REPORTFILE /softwar/ogg/191/dirrpt/DPM_I_01.rpt PROCESSID DPM_I_01
oracle     70358   70353  0 19:46 ?        00:00:00 oracleigt (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

What to check

The server process is running with parameters:

./server -w 300 -p 7819-12818 -m 7809 -k -l /software/ogg/191/ggserr.log

oracle@qa-2-dbs-01>% ls -l /software/ogg/191/ggserr.log

-rw-r----- 1 oracle dba 3337659 May 19 20:01 /software/ogg/191/ggserr.log

File /software/ogg/191/ggserr.log must be owned by oracle, else the server process would not start.

Incase this file owner is root, without write permissions to user oracle, Golden Gate process cannot start, and it does not listen to incoming calls from the remote gate.

Solution

as root

chown oracle:dba /software/ogg/191/ggserr.log