Folks,
I downloaded the VM with OGG+ODI integration demo for 12.1.3, and also the "Getting Started with Oracle Data Integrator 12c" pdf. Trying step 10.3.2 on pg 92: "Running Initial Load Staging Mapping" but it throws error:
ODI-1228: Task Create synonym on target-LKM Oracle to Oracle (DBLINK)- fails on the target connection TRG_ODIDEMO.
Caused By: java.sql.SQLException: ORA-01471: cannot create a synonym with same name as object
It is telling the truth, I tried the code in sqlplus with same error:
SQL> conn odi_staging/oracle;
Connected.
SQL> create synonym ODI_STAGING.C$_0OGG_CUSTOMER1 for ODI_STAGING.C$_0OGG_CUSTOMER1@orcl;
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object
Initially the Data Server Definition did not have the Instance=orcl in it, I added it and got the same error both with and without "orcl". Why is this happening? Another odd piece that may be related: I tried this same mapping earlier, and it got stuck on the line before, trying to create a view but was insufficient privs for ODI_STAGING to select the ogg_customer table. So I simply did "grant dba to odi_staging;" and that was not enough! Tried stopping/starting ODI, and then the DB, no change. Hmmm, dba role not enough??? I also had to "grant select any table to odi_staging;" and then that line worked.
Back to the current problem: I can get other procs to run, like the Clean Up target tables works fine, and the Demo Client works fine.
1) Has anyone else run into this synonym problem?
2) Has anyone else gotten it to work?
--Thanks, Steve F.