部署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

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