OGG-02091 Oracle GoldenGate Delivery for Oracle

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.