ogg 传输进程启动报错 Missing filename opening checkpoint file.

最新推荐文章于 2023-05-30 00:32:56 发布

msdnchina

最新推荐文章于 2023-05-30 00:32:56 发布

阅读量4.7k

点赞数

CC 4.0 BY-SA版权

文章标签： goldengate Missing filename ope

本文链接：https://blog.youkuaiyun.com/msdnchina/article/details/41208921

Oracle GoldenGate 专栏收录该内容

101 篇文章

订阅专栏

本文记录了一次 Oracle GoldenGate 在 Linux 环境下启动时遇到的问题及初步诊断过程。故障表现为 Extract 进程读取检查点文件时失败，并抛出了“Missing filename opening checkpoint file”错误。通过分析日志文件和配置参数，提供了可能的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

GGSCI (hosta) 48> view report dpfull

***********************************************************************
                 Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.27 19591627 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_141006.1156_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Oct 6 2014 16:57:47

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

                    Starting at 2014-11-17 22:14:12
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Tue Mar 16 21:52:39 EDT 2010, Release 2.6.18-194.el5
Node: hosta
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: 4077

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2014-11-17 22:14:12 INFO    OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.

2014-11-17 22:14:12 INFO    OGG-02696 NON-ANSI SQL parameter syntax is used for parameter parsing.
passthru
rmthost 192.168.1.129, mgrport 7809
rmttrail /u02/ggs/dirdat/td
gettruncates
table scott.*;
sequence scott.*;

2014-11-17 22:14:12 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:
    /u02/ggs/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                               64G
CACHEPAGEOUTSIZE (normal):                8M
PROCESS VM AVAIL FROM OS (min):         128G
CACHESIZEMAX (strict force to disk):     96G

Source Context :
SourceModule            : [er.checkpoint]
SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/checkpoint.cpp]
SourceFunction          : [get_checkpoint_context]
SourceLine              : [45]
ThreadBacktrace         : [12] elements
                          : [/u02/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b54dc286d2e]]
                          : [/u02/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x2b54dc27f88c]]
                          : [/u02/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2b5
4dc270d35]]
                          : [/u02/ggs/extract(get_checkpoint_context(time_elt_def*, time_elt_def*)+0x200) [0x54ec00]]
                          : [/u02/ggs/extract(readCheckpoint()+0x39) [0x54ed69]]
                          : [/u02/ggs/extract(extract_main(int, char**)+0xa75) [0x57e7a5]]
                          : [/u02/ggs/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x63309f]]
                          : [/u02/ggs/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6332f4
]]
                          : [/u02/ggs/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6333fb]]
                          : [/u02/ggs/extract(main+0x2c) [0x57dc5c]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x39f101d994]]
                          : [/u02/ggs/extract(__gxx_personality_v0+0x3b2) [0x4f64aa]]

2014-11-17 22:14:12 ERROR   OGG-00446 Missing filename opening checkpoint file.

2014-11-17 22:14:12 ERROR   OGG-01668 PROCESS ABENDING.

查找mos文章：
Extract / Replicat abends with "Missing filename opening checkpoint file" (Doc ID 1308722.1)

[oracle@hosta dirprm]$ more dpfull.prm
passthru --------------------------------->此行(第一行)应该是extract dpfull
rmthost 192.168.1.129, mgrport 7809
rmttrail /u02/ggs/dirdat/td
gettruncates

table scott.*;

sequence scott.*;