oracle抽取进程,OGG-00446 ,ORA-26947 抽取进程启动失败

本机环境

Oracle Server - Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)

Database - Oracle Database 11g Enterprise Edition Release11.2.0.4.0- 64bit Production

OGG - Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

source端的提取进程extract启动后很快就变成stop状态，启动失败。

GGSCI (node1) 41> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     DP1         00:00:00      00:43:06

EXTRACT     STOPPED     EX1         00:00:00      00:01:41

查看错误日志

GGSCI (node1) 42> view report ex1

***********************************************************************

Oracle GoldenGate Capture for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:42:16

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Starting at 2014-09-28 14:32:44

***********************************************************************

…..略去….

2014-09-28 14:33:06  ERROR   OGG-00446  Opening ASM file +DATA/prod/onlinelog/group_1.261.859325521 in DBLOGREADER mode: (26947)ORA-26947: Oracle GoldenGate

replication is not enabled.

Not able to establish initial position for begin time 2014-09-28 14:31:42.

2014-09-28 14:33:06  ERROR   OGG-01668  PROCESS ABENDING.

此次遇上了Oracle11.2.0.4所需的一个配置ENABLE_GOLDENGATE_REPLICATION。之前在11.2.0.3版本Oracle运行OGG从来没遇到过这个状况。在source端执行下面的语句问题解决。

ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;