我把它安装在DG 上

主库也安装了OGG

主库设置了用户和密码 以及

6> dblogin userid ggs,password ggs

7> add trandata shark.*

备库 就是抽取进程起不来

GGSCI (masterdg as ggs@goodg) 31> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EORA        00:00:00      00:08:19

EXTRACT     RUNNING     PUMP_SO     00:00:00      00:00:07

报错:

2015-04-02 18:05:01  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start eora.

2015-04-02 18:05:01  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [127.0.0.1]:41837 (START EXTRACT EORA ).

2015-04-02 18:05:01  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EORA starting.

2015-04-02 18:05:01  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, eora.prm:  EXTRACT EORA starting.

2015-04-02 18:05:01  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, eora.prm:  Operating system character set identified as UTF-8.

2015-04-02 18:05:01  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, eora.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2015-04-02 18:05:02  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, eora.prm:  Setting session time zone to source database time zone 'GMT'.

2015-04-02 18:05:02  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, eora.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.

2015-04-02 18:05:02  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, eora.prm:  Successfully set environment variable ORACLE_SID=goodg.

2015-04-02 18:05:02  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, eora.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.

2015-04-02 18:05:02  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, eora.prm:  Virtual Memory Facilities for: BR

anon alloc: mmap(MAP_ANON)  anon free: munmap

file alloc: mmap(MAP_SHARED)  file free: munmap

target directories:

/u01/app/software/ogg/BR/EORA.

2015-04-02 18:05:02  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, eora.prm:  filecaching started: thread ID: 1248471360.

2015-04-02 18:05:02  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, eora.prm:  Virtual Memory Facilities for: COM

anon alloc: mmap(MAP_ANON)  anon free: munmap

file alloc: mmap(MAP_SHARED)  file free: munmap

target directories:

/u01/app/software/ogg/dirtmp.

2015-04-02 18:05:02  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, eora.prm:  The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).

2015-04-02 18:05:02  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, eora.prm:  PROCESS ABENDING.

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐