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

OGG启动REPLICAT进程遇到OGG-00212错误

今天在给客户安装OGG的时候,EXTRACT进程无法启动。

GGSCI (ycods1) 4> start EXTBAM

Sending START request to MANAGER ...
EXTRACT EXTBAM starting

GGSCI (ycods1) 5> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
EXTRACT     STOPPED     EXTBAM      00:00:00      02:59:08
EXTRACT     STOPPED     PUMPBAM     00:00:00      02:56:41
REPLICAT    RUNNING     REPCIMXB    00:00:00      00:00:02
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:05

观察日志,发现OGG-00664错误。

2013-05-08 15:07:07  ERROR   OGG-00664  OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or invalid environment specified)

这个报错很明显是由于NLS_LANG环境变量设置的不对,观察EXTRACT进程配置文件,发现NLS_LANG部分用了全角的双引号。

EXTRACT extbam

SETENV (NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”)
SETENV (ORACLE_SID=yyjc1)
USERID ogguser,PASSWORD AACAAAAAAAAAAAHAVEMFFBTCODIDNHRD,ENCRYPTKEY default
DYNAMICRESOLUTION

删除双引号,问题解决。

GGSCI (ycods1) 12> start EXTBAM

Sending START request to MANAGER ...
EXTRACT EXTBAM starting

GGSCI (ycods1) 13> info all
Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     EXTBAM      00:00:00      03:02:48
EXTRACT     STOPPED     PUMPBAM     00:00:00      03:00:21
REPLICAT    RUNNING     REPCIMXB    00:00:00      00:00:01
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:03

通过观察,EXTRACT进程正常,已经这确连接2个RAC实例。

GGSCI (ycods1) 18> info EXTBAM,showch

EXTRACT    EXTBAM    Last Started 2013-05-08 15:10   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint  Oracle Redo Logs
2013-05-08 15:12:05  Thread 1, Seqno 1039, RBA 136134144
Log Read Checkpoint  Oracle Redo Logs
2013-05-08 15:11:34  Thread 2, Seqno 706, RBA 149851136
Current Checkpoint Detail:
Read Checkpoint #1
Oracle RAC Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 1039
RBA: 44683776
Timestamp: 2013-05-08 12:08:01.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 1039
RBA: 136133136
Timestamp: 2013-05-08 15:12:05.000000
SCN: 2878.4099253078 (12365015130966)
Redo File: +DATA/yyjc/onlinelog/group_5.259.805634579
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 1039
RBA: 136134144
Timestamp: 2013-05-08 15:12:05.000000
SCN: 2878.4099253078 (12365015130966)
Redo File: +DATA/yyjc/onlinelog/group_5.259.805634579
Read Checkpoint #2
Oracle RAC Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 706
RBA: 84888064
Timestamp: 2013-05-08 12:08:01.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 706
RBA: 149850640
Timestamp: 2013-05-08 15:11:34.000000
SCN: 2878.4099253074 (12365015130962)
Redo File: +DATA/yyjc/onlinelog/group_4.268.805635511
Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 706
RBA: 149851136
Timestamp: 2013-05-08 15:11:34.000000
SCN: 2878.4099253074 (12365015130962)
Redo File: +DATA/yyjc/onlinelog/group_4.268.805635511
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 954
Timestamp: 2013-05-08 15:12:09.130906
Extract Trail: ./dirdat/SG_BAM/BA
Write Checkpoint #2
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: 2013-05-08 12:12:06.444958
Extract Trail: ./dirdat/SG_BAM/XB
Header:
Version = 2
Record Source = A
Type = 6
# Input Checkpoints = 2
# Output Checkpoints = 2
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 4096
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2013-05-08 15:10:54
Last Update Time = 2013-05-08 15:12:09
Stop Status = A
Last Result = 400

经过测试,EXTRACT进程可正常抽取。

 

Start of Statistics at 2013-05-08 15:25:12.

Output to ./dirdat/SG_BAM/BA:
Extracting from SG_BAM.BAM_PROCESSINST to SG_BAM.BAM_PROCESSINST:

*** Total statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Daily statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Hourly statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

*** Latest statistics since 2013-05-08 15:25:10 ***

Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

End of Statistics.

 

本文固定链接: http://www.dbdream.com.cn/2013/05/ogg%e5%90%af%e5%8a%a8replicat%e8%bf%9b%e7%a8%8b%e9%81%87%e5%88%b0ogg-00212%e9%94%99%e8%af%af/ | 信春哥,系统稳,闭眼上线不回滚!

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

OGG启动REPLICAT进程遇到OGG-00212错误:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter