Thursday, February 9, 2017

OGG-01031 There is a problem in network communication. Reply received is Output file is not in any allowed output directories

GG version:  12.2
Oracle DB:  12.1.0.2.0


2017-02-09 10:05:05  ERROR   OGG-01031  Oracle GoldenGate Capture for Oracle, edev.prm:  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Output file /migrate/target/GG/RT000000 is not in any allowed output directories.).
2017-02-09 10:05:05  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, edev.prm:  PROCESS ABENDING.


sourceserver:mydev:/migrate/source/GG/home $ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.



GGSCI (sourceserver) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EDEV      00:00:02      00:00:07
EXTRACT     RUNNING     PDEV      00:00:00      00:00:05


GGSCI (sourceserver) 3> view params PDEV

EXTRACT PDEV
SETENV (ORACLE_SID='mydev')
USERID ggadmin, password ****
RMTHOST targetserver, MGRPORT 7809
RMTTRAIL  /migrate/target/GG/RT
PASSTHRU
TABLE   MYDEV.TEST ;


Solution:

In order to solve this problem, add the parameter ALLOWOUTPUTDIR in the target system GLOBALS file.
The ALLOWOUTPUTDIR parameter was introduced in Oracle GoldenGate 12.2

Go to TARGET side and add “ALLOWOUTPUTDIR /migrate/target/GG” to GLOBALS file because we are not using “dirdat” (12.2 new feature)

GGSCI (targetserver) 1> edit params ./GLOBALS
GGSCHEMA ggadmin
ALLOWOUTPUTDIR /migrate/target/GG


reference:


OGG-01031 There is a problem in network communication. Reply received is Output file is not in any allowed output directories. (Doc ID 2095284.1)

0 comments:

Post a Comment

Auto Scroll Stop Scroll