Question

1
Replies
146
Views
ANGLINA1 Member since 2005 10 posts
American Express
Posted: 5 years ago
Last activity: 5 years 1 month ago
Closed

Golden Gate Replication across Oracle Database with PRPC7.1.7

I am in the process of installing Oracle GoldenGate replication across two ODA. The following is the configuration and version of the system

Database version: Oracle 12c

Schema type:        Split

GG version:           12

When whe initiate the replication process we receive the following errors

  Replicat 1 :

2015-08-31 10:59:23
WARNING OGG-01154  SQL error 1 mapping GNA_RULES.PR_SYSGEN_STATIC_CONTENT
to GNA_RULES.PR_SYSGEN_STATIC_CONTENT OCI Error ORA-00001: unique constraint
(GNA_RULES.PR_SYSGEN_STATIC_CONTENT_PK) violated (status = 1), SQL <INSERT
INTO "GNA_RULES"."PR_SYSGEN_STATIC_CONTENT"
("PXCOMMITDATETIME","PXCREATEDATETIME","PXCREATEOPNAME","PXCREATEOPERATOR","PXCREATESYSTEMID","PXINSNAME","PXOBJCLASS","PYAPPLICATIONNAME","PYBASEFILENAME","PYFILENAME","PYFILETYPE","PZCACHECONFIGID","PZPACKAGE","PZCLASS","PZINSKEY","PZPVSTREAM")
VALUES
(:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,EMPTY_BLOB())
RETURNING "PZPVSTREAM" INTO :dl0>.

 

Replicat 2 :

2015-08-31 08:06:54
WARNING OGG-01154  SQL error 1403 mapping GNA_DATA.PR_LOG_REPORTSTATS to
GNA_DATA.PR_LOG_REPORTSTATS OCI Error ORA-01403: no data found, SQL <DELETE
FROM "GNA_DATA"."PR_LOG_REPORTSTATS"  WHERE "PZINSKEY"
= :b0>.

 

 

Has anyone ever run across this problem or is using GG for replication on PRPC 7.1.7.

Low-Code App Development Installation and Deployment Data Integration Low-Code App Development System Administration
Moderation Team has archived post
Share this page LinkedIn