Analytics Software

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!

Error while executing Interface in Prod

user10220907Aug 10 2014 — edited Aug 11 2014

Hi All

We have moved our ODI Project from Dev to prod. and configured Physical Arcitecture as of production. Connections tested successful. But while executing teh interface we are getting error as below.

STEP: Drop databaselink on Target

ORA-02024: database link not found

STEP: Create database link on target

ORA-01031: Insufficient previledge

My Datawarehouse schemas are having DBA previledge.

Both My target and source is having Oracle databases 11.2

Can any one tell me what could be the issue??

regards

Gourisankar

This post has been answered by user10220907 on Aug 11 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2014

Added on Aug 10 2014

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

633 views