当前位置: 首页 > GoldenGate, Oracle > 正文

OGG-00446错误解决

部署OGG的时候,REPLICAT进程启动失败。

GGSCI (tsycodsdb) 16> info all

Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
REPLICAT    RUNNING     REPJJ       00:00:00      00:00:09
REPLICAT    RUNNING     REPYY       00:00:00      00:00:04
REPLICAT    STOPPED     TREPLVC     00:00:00      00:04:37

经查看,发现遇到OGG-00446错误。

2013-04-28 19:53:12  ERROR   OGG-00446  Could not open checkpoint file /app/oracle/product/10.2.0/ogg/dirchk/TREPLVA.cpr, mode 1 (error 2, No such file or directory).

2013-04-28 19:53:12  ERROR   OGG-01668  PROCESS ABENDING.
2013-04-28 19:53:11  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start TREPLVC aftercsn 12335663166653.
2013-04-28 19:53:11  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.157.165.241 (START REPLICAT TREPLVC AFTERCSN 12335663166653).
2013-04-28 19:53:11  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT TREPLVC starting.
2013-04-28 19:53:12  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, treplvc.prm:  REPLICAT TREPLVC starting.
2013-04-28 19:53:12  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, treplvc.prm:  Could not open checkpoint file /app/oracle/product/10.2.0/ogg/dirchk/TREPLVA.cpr, mode 1 (error 2, No such file or directory).
2013-04-28 19:53:12  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, treplvc.prm:  PROCESS ABENDING.

查看TREPLVC进程,明明使用的是/app/oracle/product/10.2.0/ogg/dirpcs/TREPLVC.pcr文件,为什么提示TREPLVA.pcr文件未找到呢?

GGSCI (tsycodsdb) 17> info TREPLVC DETAIL

REPLICAT   TREPLVC   Initialized   2013-04-28 19:51   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:05:33 ago)
Log Read Checkpoint  File ./dirdat/VC000000
First Record  RBA 0
Extract Source                          Begin             End
./dirdat/VC000000                       * Initialized *   First Record
Report file          /app/oracle/product/10.2.0/ogg/dirrpt/TREPLVC.rpt
Parameter file       /app/oracle/product/10.2.0/ogg/dirprm/treplvc.prm
Checkpoint file      /app/oracle/product/10.2.0/ogg/dirchk/TREPLVC.cpr
Process file         /app/oracle/product/10.2.0/ogg/dirpcs/TREPLVC.pcr
Stdout file          /app/oracle/product/10.2.0/ogg/dirout/TREPLVC.out
Error log            /app/oracle/product/10.2.0/ogg/ggserr.log

以上信息说明在ADD REPLICAT的时候指定的进程名字是TREPLVC,那么有可能是在TREPLVC进程的配置文件中,写错了进程的名字,经排查,的确如此。

GGSCI (tsycodsdb) 18> edit params treplvc
REPLICAT TREPLVA
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID=yyjc)
USERID ogguser, PASSWORD ogguser
HANDLECOLLISIONS
SOURCEDEFS ./dirdef/sdcw.def
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID=yyjc)
USERID ogguser, PASSWORD ogguser
HANDLECOLLISIONS
SOURCEDEFS ./dirdef/sdcw.def

原来是进程名字写错了,修改成正确的名字TREPLVC后,问题解决。

GGSCI (tsycodsdb) 1> start treplva aftercsn 12354995266226

Sending START request to MANAGER ...
REPLICAT TREPLVA starting
GGSCI (tsycodsdb) 2> info all
Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
REPLICAT    RUNNING     REPJJ       00:00:00      00:00:09
REPLICAT    RUNNING     REPYY       00:00:00      00:00:04
REPLICAT    RUNNING     TREPLVC     00:00:00      00:00:04

本文固定链接: http://www.dbdream.com.cn/2013/05/ogg-00446%e9%94%99%e8%af%af%e8%a7%a3%e5%86%b3/ | 信春哥,系统稳,闭眼上线不回滚!

该日志由 dbdream 于2013年05月17日发表在 GoldenGate, Oracle 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: OGG-00446错误解决 | 信春哥,系统稳,闭眼上线不回滚!
关键字:

OGG-00446错误解决:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter