[2021-01-06] Reply received is ‘GSOutput file ＜trail_file＞ is not in any allowed output directories

--//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