Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Initial Load Not Working in 12C - OGG-00053 No extraction maps specified

007Dec 29 2017 — edited Dec 29 2017

Hi,

I am trying an initial load from 12C database with 12C golden gate as source to target 11g database.Details listed below.

Source

*********

Database - 12C Database 12.1.0.2.0

Golden Gate - 12C Golden Gate 12.2.0.2.2

OS - Oracle Enterprise Linux

Target

********

Database - 11g Database 11.2.0.1.0

Golden Gate - 11g Golden Gate 11.2.1.0.1

OS - Oracle Enterprise Linux

My initial load extract param settings at source

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

EXTRACT iload

SETENV  (ORACLE_SID=ORA12C)

SETENV  (ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1")

USERID c##ggate, PASSWORD ggate

RMTHOST 192.168.32.132, MGRPORT 7809

rmttask replicat, group irec12c

SOURCECATALOG ORA12C

TABLE C##GGATE.COUNTY;

My initial load replicat param settings at target

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

replicat irec12c

USERID ggrep, PASSWORD ggrep

ASSUMETARGETDEFS

MAP C##GGATE.COUNTY,TARGET GGREP.COUNTY;

I am getting an error message " OGG-00053  No extraction maps specified.".

Can any one help on this error?

Regards,

007

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2018
Added on Dec 29 2017
1 comment
1,962 views