The documentation for upgrading from ODI 11.1.1.7 to 12.2.1.1 is incomplete and the instructions do not match the screens. As such, I'm having trouble getting my 11g ODI system upgraded. I'm using this document: https://docs.oracle.com/middleware/1221/core/ODIUG.pdf
I have installed ODI 12.2.1.1 in Enterprise mode on my machine on which ODI 11.1.1.7 is already installed and running. Now I'm running the RCU for 12c. I get to the screen to select components. Per the installation document, I select my existing schema prefix (DEV). The installation document does not specifically state that I should select the Data Integrator component, so I have excluded it. I am selecting the default components, plus the OPSS. The RCU completes normally.
When I go to run the Upgrade Assistant and get to the screen where we put in the credentials for the Oracle instance, I get this message when I click Connect:
- UPGAST-00224: The specified database does not contain any schemas for Oracle Data Integrator or the database user lacks privilege to view the schemas. Cause: The database you have specified does not contain any schemas registered as belonging to the component you are upgrading, or else the current database user lacks privilege to query the contents of the schema version registry. Action: Verify that the database contains schema entries in schema version registry. If it does not, specify a different database. Verify that the user has DBA privilege. Connect to the database as DBA.
I am connecting as sys, therefore I certainly have the privileges. So the logical inference is that the ODI schemas don't exist - the Upgrade Assistant isn't finding any ODI schemas. Well, OK, perhaps that's because I didn't create them with the RCU, because the documentation didn't say that I should.
So I go back to the RCU and this time I install the ODI schemas, again using the existing prefix. Should I change the Schema Owner to the name of the existing schema (DEV_BIA_ODIREPO) or accept the new schema name (DEV_ODI_REPO)? Who knows - the documentation certainly is NO HELP WHATSOEVER.
OK, I'll take a wild guess that I should not use the same schema name as I did in 11g. If that turns out to be wrong, I can always come back and run the RCU again. For now, I'm going to keep the new name of the Schema Owner (DEV_ODI_REPO) as suggested on the installer screen. The RCU runs and completes normally.
NOW when I run the Upgrade Assistant and select the Oracle Data Integrator component, I get past the connection credential verification and I am able to select the DEV_ODI_REPO schema for upgrade, only to be told this: Oracle Data Integrator (DEV_ODI_REPO) 12.2.1.1.0 upgrade not necessary. That makes sense - I installed that schema using 12c.
Once more I go back to the RCU to install the ODI schema, again using the existing prefix, but this time setting the schema name to my existing DEV_BIA_ODIREPO schema. I first drop the existing ODI component (the DEV_ODI_REPO schema), then install the ODI component into the existing DEV_BIA_ODIREPO schema. Something tells me that this isn't going to work either, but it seems to be my only remaining option. On the screen where I am entering Custom Variables, the question for Work Repository name is throwing me: do I use the existing work repository name from my 11g system (BIAPPS_WORKREP), or use a new one (WORKREP)? Again, the documentation offers zero support in that regard. I will take a guess and use WORKREP (new name).
The RCU process has finished installing the DEV_BIA_ODIREPO schema. Can I run the Upgrade Assistant against it? The Upgrade Assistant again tells me that the schema is already 12.2.1.1, and there is nothing to do.
Well, how about opening ODI Studio 12c and seeing if there are any projects in the repository? Is it possible that something magical happened without running the Upgrade Assistant? The Repository Connection Information screen is already filled out, so I presume that came over from 11g. I changed the USER name to SUPERVISOR. When I try to connect, the default repository in the connection screen - BIAPPS_WORKREP - does not exist. I changed that to just WORKREP and tried to connect again. The connection is successful, but there are no projects. Again, that makes sense, because WORKREP was brand new.
(By the way, at this point I thought of just trying to export my existing project from 11G then importing it into 12c, but it is apparently too large to export. No matter how much Java memory I configure in the appropriate .cmd files, the process fails with 'Not enough Java memory, increase the -xmx parameter". It runs for over 7 hours then fails.)
OK, there's only one thing left to try. I started with a fresh machine from my backup, then installed the RCU with the existing schema prefix, existing schema name (DEV_BIA_ODIREPO) and specified the existing BIAPPS_WORKREP repository name. The Upgrade Assistant once again tells me that there is nothing to do, because the DEV_BIA_ODIREPO schema is already at release 12.12.1.1.0.
Just for kicks, I restarted all BI Services - Admin Server, BI Server, ODI Server - and accessed the 11g ODI Studio. When I attempted to connect, I got this: "ODI-26168: Client requires a repository with version 04.03.04.02, but the repository version found is 05.02.02.04". So 11g says that the BIAPPS_WORKREP repository has already been upgraded. That's a good thing (I think).
What about 12c Studio? When I launch ODI 12c Studio and try to connect to the BIAPPS_WORKREP repository, the connection is successful, but there are NO PROJECTS in it!! What happened to the projects? My guess is that they got zapped when I ran the RCU - either the BIAPPS_WORKREP repository or the DEV_BIA_ODIREPO schema schema got wiped out and recreated by the RCU.
In summary: I can't run the Upgrade Assistant without first running the RCU to install the ODI schemas. Once I run the RCU to install the ODI schemas, the Upgrade Assistant finds nothing to upgrade.
I am at a loss to know what to try next. Help!!