Chinaunix首页 | 论坛 | 博客
  • 博客访问: 57643
  • 博文数量: 9
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 105
  • 用 户 组: 普通用户
  • 注册时间: 2014-05-16 16:45
文章分类
文章存档

2015年(9)

我的朋友

分类: Oracle

2015-05-26 17:02:17

11.2.0.4上的ogg复制进程报错OGG-02091如下: 

 

2015-02-18 14:58:22  WARNING OGG-06471  Oracle GoldenGate Delivery for Oracle, r

_abnb_1.prm:  Unable to disable trigger firing.

2015-02-18 14:58:22  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, r

_abnb_1.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/oracle/product/ogg/dirtmp.

2015-02-18 14:58:23  ERROR   OGG-02091  Oracle GoldenGate Delivery for Oracle, r_abnb_1.prm:  Operation not supported because enable_goldengate_replication is not set to true.

2015-02-18 14:58:23  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, r_abnb_1.prm:  PROCESS ABENDING.

2015-02-18 14:58:25  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start REPLICAT    ABENDED     R_ABNB_2    00:00:00      03:32:15.

2015-02-18 14:58:29  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start REPLICAT.

2015-02-18 14:58:38  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start REPLICAT R_ABNB_2.

 

到数据库中将enable_goldengate_replication设置为true即可。 

 

SQL> alter system set enable_goldengate_replication=true scope=both; 

 

然后重新打开进程即可正常运行

 

2015-02-18 14:58:39  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle, r_abnb_2.prm:  Operating system character set identified as UTF-8.

2015-02-18 14:58:39  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle, r_abnb_2.prm:  ANSI SQL parameter syntax is used for parameter parsing.

2015-02-18 14:58:39  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, r_abnb_2.prm:  Successfully set environment variable ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1.

2015-02-18 14:58:39  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, r_abnb_2.prm:  Successfully set environment variable ORACLE_SID=cqabdt0.

2015-02-18 14:58:39  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle, r_abnb_2.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.


阅读(4880) | 评论(0) | 转发(0) |
0

上一篇:ORA-28040: No matching authentication protocol

下一篇:没有了

给主人留下些什么吧!~~