WARNING OGG-01752 Cannot Register EXTRACT <name> With Database (Doc ID 1352864.1)

Last updated on JULY 21, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On adding an extract you get the following message:

YYYY-MM-DD HH:MI:SS WARNING OGG-01752 Cannot register EXTRACT PREXTGP1 with database because no database login was provided. You can manually register this group later with the REGISTER EXTRACT <GROUP NAME> LOGRETENTION command. Issue DBLOGIN first.
EXTRACT added.

Or you may see:

2011-11-17 23:11:46 WARNING OGG-01756 Cannot register EXTRACT EXTORA with database because of the following SQL error: OCI Error ORA-00439: feature not enabled: Streams Capture
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 141
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 244
ORA-06512: at line 1 (status = 0). See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide. You can manually register this group with the REGISTER EXTRACT command.
EXTRACT added.

Changes

OGG 11.1.1.1.x provided integration between RMAN in ORACLE Enterprise Edition and OGG allowing for additional logs to be maintained for a recovery beyond the Bounded recovery window if required by the customer.

You will find more details of this in the Oracle Goldengate v11.1.1.1.0 release notes related to the LOGRETENTION parameter


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms