Skip to Main Content
Forums

LiveLabs & Workshops

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI MP Using ExaCS & ODI Marketplace

Shib Seal-OracleSep 26 2022

We have a customer who would like to use their ExaCS database for the ODI repository. The ODI provisioning will be done in ODI Marketplace
Since the default ODI Marketplace provisioning wizard only lets you only pick an existing ADW/ATP instance or an embedded repo as ODI Repository location choices, I came up with the below options to deploy ODI with ExaCS:

Option 1: ODI MP with DBCS or Exadata db

Set up ODI MP using embedded repo or MySQL
Run RCU in the MP instance to set up the repo in the DBCS instance.
Reconfigure the standalone agent to use the DBCS repo.
This is the documentation on found on this effort:
Configuring ODI Marketplace Repositories on DBCS Instance
https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/odi-marketplace/configuring-odi-marketplace-repositories-dbcs-instance.html#GUID-83D4458E-6B95-4A1D-AA1F-CA25F051897C
Questions:
Can you please confirm if this is a viable option?
Do we have the right documentation listed above to accomplish this?

Option 2: IaaS type install where we install WLS, ODI and run RCU against DBCS or Exadata db.

Questions:
How is the licensing different on this option from option 1? The customer asked this question during the discovery session.
Any further thoughts on this option?
Between the two options, is there one you would recommend and why?

Comments

Jim Smith
It is possible the breakpoints aren't on code lines - sometimes the apparent line numbers are wrong. Try bracketting a line with breakpoints on either side.
311747
Following your suggestion, I put break point on 6 lines following the DBMS_DEBUG_JDWP.CONNECT_TCP call.
3 of those lines are code lines. I also have 2 break points on code lines in a procedure being called at one of those 6 lines.

I have no problem hitting those stops if I 'Run as Debug'... but they are ignored when doing the remote debug.
In the remote debug session I do see all the break points lists in the Breakpoints tab. I'm very confused.....
An experiment -

Tools > Preferences > Debugger

Start Debugging Option:
- Step Over


Try this. This allows you to start a debug session sans breakpoints. You can then step over or into your code once the debugger session 'attaches.' I believe this will work for remote...
311747
Good suggestion, but I already had that debugger property set.

I got it working! What I didn't realize was that you need to be logged into the database with the same credentials in both the local and remote session. I was trying to debug as the package owner and executing the procedure using our 'web' runtime user id.......

I learned that the break points are userid specific.

Thanks for all your great suggestions!
1 - 4

Post Details

Added on Sep 26 2022
#bi, #database, #developer, #odi, #oracle, #oracle-data-integrator
0 comments
228 views