OGG-00446 ,ORA-26947 抽取程式啟動失敗

snowdba發表於2014-09-28
本機環境
Oracle Server - Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)
Database - Oracle Database 11g Enterprise Edition Release 11.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;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29047826/viewspace-1283722/，如需轉載，請註明出處，否則將追究法律責任。

相關文章