GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Get error when run "register extract PPC_E08 database"

Hi all,

We have database Oracle 12.1 with classic extract. I want to upgrade classic capture to integrated capture. When I run "register extract PPC_E08 database" I got error:

ERROR  OGG-15415 Log archive destination at the source database must be configured with the NOREGISTER attribute for destination id '1'.

We have configured DG.

DGMGRL> show configuration;
Configuration - *****
 Protection Mode: MaxPerformance
 Members:
 ***_s2 - Primary database
  ***_s1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS  (status updated 46 seconds ago)

In parameters:

dg_broker_config_file1	/u01/app/oracle/product/12.1.0.2/dbs/dr1***_s2.dat
dg_broker_config_file2	/u01/app/oracle/product/12.1.0.2/dbs/dr2***_s2.dat
dg_broker_start	TRUE

log_archive_dest_1 = LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=***_s2
log_archive_dest_1 = service="***_s1", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="***_s1" net_timeout=30, valid_for=(online_logfile,all_roles)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center