一、背景描述

这是最近遇到的一个生产案例，目前一套Oracle 11g RAC要下线，并将部分业务拆分迁移到其它生产库上，业务不允许停机迁移，于是就配置了OGG双向同步，在验证数据迁移配置OGG双向同步时，在源端配置PUMP，执行了如下命令 ADD RMTTRAIL ./dirdat/eb, EXTRACT dpb，并编辑了PUMP进程，在启动pump进程时报了如下错误，导致进程ABENDING

2023-06-08 09:51:19  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start dpb.
2023-06-08 09:51:19  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.4.21]:28513 (START EXTRACT DPB ).
2023-06-08 09:51:19  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #6).
2023-06-08 09:51:19  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT DPB starting.
2023-06-08 09:51:19  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, dpb.prm:  EXTRACT DPB starting.
2023-06-08 09:51:19  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, dpb.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2023-06-08 09:51:19  INFO    OGG-02696  Oracle GoldenGate Capture for Oracle, dpb.prm:  NON-ANSI SQL parameter syntax is used for parameter parsing.
2023-06-08 09:51:19  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, dpb.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2023-06-08 09:51:19  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, dpb.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
2023-06-08 09:51:19  ERROR   OGG-01044  Oracle GoldenGate Capture for Oracle, dpb.prm:  The trail '/ogg/dirdat/rb' is not assigned to extract 'DPB'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /ogg/dirdat/rb, EXTRACT DPB".
2023-06-08 09:51:19  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, dpb.prm:  PROCESS ABENDING.
复制

二、原因分析

查看了PUMP的配置文件，应该是跟配置文件中RMTTRAIL后使用了绝对路径，如下所示：

GGSCI (host501) 10> view param dpb
 
EXTRACT dpb
SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
PASSTHRU
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB, ENCRYPTKEY default
RMTHOST 192.168.xxx.xxx, MGRPORT 8701
RMTTRAIL /ogg/dirdat/eb
REPORTCOUNT EVERY 10 MINUTES, RATE
NUMFILES 5000
DYNAMICRESOLUTION
--AND TABLE AND SEQUENCE
复制

而我为data pump指定远程trail文件地址，是采用了相对路径，./dirdat/eb

三、解决办法

通过delete dpb删除该pump进程，然后执行ADD RMTTRAIL /ogg/dirdat/rb, EXTRACT dpb，PUMP进程的配置文件未修改，重新启动该pump进程，这次正常启动，不再ABENDING.

之前部署OGG也遇到了很多问题，但这是第一次遇因路径产生故障的问题，特整理记录下来。