Enterprise Manager

Migrate your EM Cloud Control Repository into a PDB

This is a question two customers asked me one or two weeks ago. Is it allowed and supported to Migrate your EM Cloud Control Repository into a PDB? And if it is supported, how do you do it?

Is is supported?

At first, the good news, Migration your Enterprise Manager Cloud Control Repository database into a pluggable database (PDB) is fully supported. You find a section in the Cloud Control Basic Installation Guide saying:

The supported database configuration types are: pluggable database (PDB) and non-container database (non-CDB).

And you can have even …

Continue reading...

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2Enterprise Manager (EM) clean up in Oracle Database 11.2-12.2 is targeting Enterprise Manager Database Control only. EM DB Control does not exist anymore since Oracle Database 12c and got replaced by EM Express, a light-weight EM.

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2As Enterprise Manager Database Control gets replaced by EM Express since Oracle Database its repository must be removed when upgrading to Oracle Database 12c or later. The following MOS Notes offer plenty of information:

Continue reading...

EM 13c – How to Upgrade from EM Cloud Control 12c

I’m not a Cloud Control expert but I use the tool from time to time – and most of my customers are heavy users of it, especially in larger deployments.

If you use Oracle Enterprise Manager Cloud Control 12c (, or and would like to evaluate your options to upgrade to Oracle Enterprise Manager Cloud Control 13c then please consult the following very useful documentation:

If you are searching for the software please …

Continue reading...

New Cloud Control is available

The new version of Oracle’s Cloud Control 12c Release 5 is available for download as of today. Some of the new features include Hybrid Cloud Computing but also the support for RMAN incremental rolling forward backups (cross platform, cross Endianness) to decrease downtime for Transportable Tablespaces and Full Transportable Export/Import migrations.

Find it here on OTN:


Oracle Enterprise Manager Cloud Control 12c Release 5 ( New!

Enterprise Manager Base Platform
(Full Installers for OMS, Agent, Repository, Management Plug-ins)

Download for Linux x86 (32-bit)
Download for Linux x86-64 (64-bit)
Download for Windows x86-64 (64-bit)
Download for Solaris Operating System (SPARC)
Download for Solaris Operating

Continue reading...

Migration of an EM Repository cross-platform?

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 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

Continue reading...

EM Cloud Control (or newer) OMS Repository certified with Oracle Database plus patches

The certification for Oracle Database as Repository Database underneath of Oracle Enterprise Manager Cloud Control (OMS) had been revoked for a while. One reason may have been the potential removal of the SYSMAN user during a DBUA upgrade 😉 But this is just a rumor. I don’t know the exact reasons.

After checking with the certification matrix earlier today I realized:

Cloud Control Repository Database Certification Oracle

Oracle Database is certified as a repository database for Cloud Control resp. OMS.

But … with a few important restrictions (see MOS Note:1987905.112c Database has been Certified as a 12cR4 Repository with Certain Patchset

Continue reading...