Hi guys,
I'm looking for some help on out-of-place ODI migrations.
I have installed and patched ODI 12.2.1.4 and I have created the Master and Work repositories.
I want to perform an out of place migration from a 11g instance, into the new installed 12c instance, so I used expdp and impdp to create dmp files from the ODI 11g Master and Work repositories. After that I imported the dmp files into the new environment with the ODI_MASTER_OLD and ODI_WORK_OLD schema names.
Since I have also created the ODI 12c schemas with the RCU, I have now 6 schemas:
ODI_STB,ODI_WLS,ODI_WLS_RUNTIME and ODI_MASTER_WORK - all created with RCU 12c
ODI_MASTER_OLD and ODI_WORK_OLD - exported from 11g instance, imported to the new database of the 12c environment.
The Upgrade Assistance only sees the ODI_MASTER_WORK repository, which is already upgrade to the latest patch. The *_OLD schemas does not appear as options.
I have checked several posts, and they all seem to perform in-place upgrades. So I'm kinda stuck. I am also thinking in trying using Smart Export / Import but I've read it has issues.
Any similar experiences on this issue are welcome.
Thank you,
Pedro