The Middle Tier upgrade from Oracle Identity Manager 18.104.22.168.0 to Oracle Identity Manager 11.1.2 fails with the following error:
INFO: Log file can be found at :C:\oim9xPS1R2\mw\Oracle_IDM1\server\upgrade\logs\MT\OIMUpgrade120719101140-06 00.log
The workaround for this issue is as follows:
Run the following command using SYS/SYSTEM schema:
CREATE OR REPLACE PUBLIC SYNONYM “SCHEMA_VERSION_REGISTRY” FOR “SYSTEM”.”SCHEMA_VERSION_REGISTRY”
Run the Middle Tier again.