Datapump is not starting
OGG Report showing:
WARNING OGG-01221 Connect failed to 10.20.30.40:7819, error 111:Connection refused.
WARNING OGG-01221 Connect failed to 10.20.30.40:7819, error 111:Connection refused.
What to check
=====================
Site A
=====================
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 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 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.
No comments:
Post a Comment