Migrate OWM-enabled instance from 11.1 on Sparc-64 to 11.2 on Linux-x64?
Because a hardware platform change is involved, I seemingly have to use exp/imp to accomplish the task.
A straightforward attempt to do a full export on the 11.10.7 system (Solaris Sparc-64) and then a full import on 11.2.0.3 (Linux X64), but that yields errors:
IMP-00003: ORACLE error 20000 encountered
ORA-20000: Incompatible version of Workspace Manager Installed
and after the import, workspaces and history are missing, so no go.
It occurs to me that I could install version 11.1.0.7 on Linux and import the Solaris dumpfile into that, and then do an in-place upgrade of that 11.1 $ORACLE_HOME to 11.2.0.3? But that seems like a lot of (time-consuming) steps and then I'm left with a second upgraded 11.2.0.3 ORACLE_HOME instead of the single cleanly installed version I'd prefer.
The documentation and forum postings seem to hint that I might instead downgrade the version of Workspace Manager on 11.2 temporarily in order to get the data imported and then upgrade it back to the current version of OWM, but nowhere have I found explicit step-by-step instructions nor information on how to download older releases of OWM that can be used to accomplis this.
Any advice on the best approach will be much appreciated.
Edited by: user11987684 on Jul 17, 2012 12:49 PM