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!

Replicat Abending ora:24344- success with compilation error

938450Jul 9 2012 — edited Jul 13 2012
Hi Friends

We are doing a database migration from Hp-ux oracle 10.2.0.4 to exadata machine oracle 11.2.0.3. We are using oracle goldengate 11.2.1.0.1 on both source and target. The replication was fine. On friday evening 7/6/2012 the replicat got abended when it was trying to execute a DDL[Error code [24344], ORA-24344: success with compilation error SQL create or replace PACKAGE BODY xxxxxxx."xxxx".
The error is "Body 652 5 PL/SQL: ORA-00933: SQL command not properly ended".
The package body got recreated fine on source database with no compliation error but when the replicat is trying to execute the same on target it is able to but with compilation error

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 9 2012
3 comments
1,056 views