案例一：ogg 删除 REPLICAT进程遇OCI Error ORA-00942: table or view does not exist (status = 942)错误解决办法

一、问题描述

在测试OGG双向同步时，在目标端配置了应用进程，在启动应用进程时发现有报错，打算删除该应用进程，在执行delete REPLICAT rtb删除时报如下错误，导致无法删除。

ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

使用force也同样报错：

GGSCI (xsky-node4) 34> delete rtb force
ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

二、解决办法

通过查阅资料，添加 ！符合可以删除

GGSCI (xsky-node4) 38> delete replicat rtb !
WARNING: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

GGSCI (xsky-node4) 39> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING DPA 00:00:00 00:00:04
EXTRACT RUNNING EXA 00:00:00 00:00:05

此时再没rtb那个replicat进程了。

真的没想到通过 添加 ！感叹号可以删除，又学到一招,特此记录下。

案例二：OGG配置PUMP因绝对路径和相对路径导致进程PROCESS ABENDING问题记录

一、背景描述

这是最近遇到的一个案例，目前一套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也遇到了很多问题，但这是第一次遇因路径产生故障的问题，特整理记录下来。