Can you migrate your EM Cloud Control Repository to another OS platform? Cross-platform and cross-Endianness?
This question sounds so incredibly simple that you won’t even start thinking I guess. Same for ourselves. Use Data Pump. Or Transportable Tablespaces. Or Full Transportable Export/Import if your source is at least 11.2.0.3 or newer.
But sometimes in life things seem to be simple, but as soon as you unmask them you’ll find a full bunch of issues. It’s a fact that the repository of EM Cloud Control is quite a bit complicated. And uses plenty of databases technologies.
Actually all credits go to Roy here as he has worked with the EM group for the past 6 months on this topic.
You can migrate a EM Cloud Control Repository cross-platform but not cross-Endianness (e.g. HP-UX to OL, big to little Endianness). The latter is scheduled to be supported in EM 13.2.
- EM Cloud Control Repository cross-hardware and/or cross-platform migration:
https://docs.oracle.com/cd/E24628_01/doc.121/e24473/repository.htm#BGBEBBHE - EM Cloud Control Repository cross-Endianness migration is not possible right now.
Please see this link for EM 13.5 which relates to Oracle Database 19c:
Summary:
As EM Cloud Control Repository migrations is possible right now only within the same Endianness group you should decide carefully where you store your EM Cloud Control Repository.
–Mike
Hi, we’re struggling in how to bring the 12cR4 OMR from an 11.2.0.4 database running on Solaris SPARC to the 12.1.0.2 (pluggable or not, but preferrably pluggable) database. The final target is Linux, but we may go through Solaris if required, as an intermediate step. I’ve checked the DOCs below, but there is no mention on being able to do the cross-platform transportable between different endianness, which I was waiting for:
https://docs.oracle.com/cd/E73210_01/EMADM/GUID-58BB1E98-268A-43A6-B526-94EED93D928A.htm#EMADM12806
Zarko,
you may please log an SR. I’m still very unsure if the EM repo can be migrated cross platform. The last document I saw included a very lengthy and complicated process. The EM Group should know better.
Thanks
Mike
Hi Mike,
thanks for your comment and info. Actually, opening an SR is exactly what I have done, here it is for your own internal info, there is no need to publish it here as a public comment:
SR 3-13552923951 : Cloud Control 12cR4 or R5: migrating OMRfrom one machine/db to another, cross-db version
Frankly, I do not think we will get much further via the SR, but let’s wait a bit and see.
Kind regards,
-Zarko
Zarko,
honestly I have not much hope either. We worked together with the EM folks a while back but it turned out that the EM repository is VERY complicated and strangely built in some ways.
Cheers
Mike
Hi – We are in middle of migration OEM env from AIX to Linux and ugrade it from 12c to 13c.
You mentioned that cross-endianness is not supported to migrate OEM repository till 12c but with 13c it will supported.
Can you please point me to a link to migrate OEM repository from AIX to Linux.
Thanks
Krunal
As mentioned above I’m not aware of any supported path to migrate the EM repository cross Endianness (which is AIX to Linux).
Please open an SR and consult with Oracle Support as I won’t be able to provide anything useful beyond the above blog post to you.
Cheers
Mike
Hi Mike,
Is cross Endianness fixed now to migrate OMR ?
Good question:
I think so, yes. But you please need to double-check with Oracle Support.
Cheers
Mike
Hi Mike,
I checked with Oracle support, they give me link:
https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emadm/cross-platform-enterprise-manager-repository-migration.html#GUID-58BB1E98-268A-43A6-B526-94EED93D928A
in there it still say:
The source and target database platform must be at the same endian format.
Do you have any other information regrading cross Endian?
Thanks so much for the help!
Thanks Jun for sharing!
I was not aware that this is boldly painted into the docs now.
If Supports tells you that this is the current situation, and if it’s documented, that seems to be the truth I fear.
Cheers
Mike