–//19.1投递进程报错
GGSCI (dm01) 54> view report exppint
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:58
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2021-01-06 16:08:09
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Thu Oct 29 17:29:29 EDT 2015, Release 3.10.0-327.el7.x86_64
Node: dm01
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: 123726
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2021-01-06 16:08:10 INFO OGG-03059 Operating system character set identified as UTF-8.
2021-01-06 16:08:10 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2021-01-06 16:08:11 INFO OGG-01360 EXTRACT is running in Data Pump mode.
2021-01-06 16:08:12 INFO OGG-01889 Flush size (max message size) is set to 27,985.
EXTRACT exppint
passthru
rmthost 192.168.40.170, mgrport 7810
rmttrail /home/oracle/OGG/19ctrails/pi,format release 11.2
2021-01-06 16:08:15 WARNING OGG-00254 FORMAT RELEASE is a deprecated parameter.
SOURCECATALOG pdb1
table pg.*;
2021-01-06 16:08:15 INFO OGG-02623 Default source catalog name pdb1 will be used for source table name pg.* mapping.
2021-01-06 16:08:15 INFO OGG-01851 filecaching started: thread ID: 139817144317696.
2021-01-06 16:08:15 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/ogg/dirtmp.
2021-01-06 16:08:23 INFO OGG-01888 TCP network is configured as
OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP 0 N/A 0
IP_TOS 0 N/A 0
TCP_NODELAY 0 N/A 0
TCP_QUICKACK 1 N/A 1
TCP_CORK 0 N/A 0
SO_SNDBUF 8192 N/A 8192
SO_RCVBUF 43690 N/A 43690.
Source Context :
SourceModule : [gglib.ggtrail.LegacyTrailDataTarget]
SourceID : [er/LegacyTrailDataTarget.cpp]
SourceMethod : [complete_tcp_msg]
SourceLine : [2225]
ThreadBacktrace : [14] elements
: [/ogg/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/ogg/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/ogg/ogg/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition)
)]
: [/ogg/ogg/extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::complete_tcp_msg(extract_def*))]
: [/ogg/ogg/extract(ggs::gglib::ggtrail::LegacyTrailDataTarget::flush_tcp(extract_def*, bool))]
: [/ogg/ogg/extract()]
: [/ogg/ogg/extract(EXTRECOVERY_initialize(ggs::gglib::ggapp::ReplicationContext&))]
: [/ogg/ogg/extract()]
: [/ogg/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/ogg/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::Threa
dArgs*))]
: [/ogg/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ogg/ogg/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ogg/ogg/extract()]
2021-01-06 16:08:24 ERROR OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is 'GSOutput file /ho
me/oracle/OGG/19ctrails/pi000000 is not in any allowed output directories.'.).
2021-01-06 16:08:24 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (dm01) 55>
查询MOS
Goldengate Pump Is Abending With ERROR OGG-01224 Connect failed to <IP_ADDRESS> , error 111:Connection refused – retries exceeded (Doc ID 2538811.1)
APPLIES TO:
Oracle GoldenGate – Version 12.3.0.1.3 and later
Generic (Platform Independent)
SYMPTOMS
Goldengate Pump Is Abending With ERROR OGG-01224 Connect failed to <IP_ADDRESS> , error 111:Connection refused – retries exceeded
CHANGES
New Setup
CAUSE
wrong directory was specified for ALLOWOUPUTDIR , replaced it with new one , now everything is working fine
Error code may be misleading as no where in the error it is mentioned the issue is with ALLOWOUPUTDIR
Even telnet was not connecting to target server port as no dynamic port was spawned which was not allowing the connection to go through , which is expected
SOLUTION
Please try to start dynamic collector process by using following command at target OGG home
./server -p <port_name> <—– any available port other than the port which manage is using
Then edit pump parameter file and replace MGRPORT with PORT <port_number_used_above>, and start the pump
It will provide right error message as below
OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is ‘GSOutput file <trail_file> is not in any allowed output directories.’.)
Correct the ALLOWOUTPUTDIR and restart the pump process
–//在目标端设置ALLOWOUTPUTDIR参数,GLOBALS添加
[oracle@QXY OGG_19C]$ cat GLOBALS
ggschema goldengate
checkpointtable goldengate.ggscheckpiont
ALLOWOUTPUTDIR /home/oracle/OGG/19ctrails/
[oracle@QXY OGG_19C]$
–//再次在源端启动投递进程
GGSCI (dm01) 55> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXINT 00:00:00 00:00:00
EXTRACT ABENDED EXPPINT 00:00:00 01:41:27
GGSCI (dm01) 56> start exppint
Sending START request to MANAGER ...
EXTRACT EXPPINT starting
GGSCI (dm01) 57> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXINT 00:00:00 00:00:04
EXTRACT RUNNING EXPPINT 00:00:00 01:41:30