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 12.1.0.1 its repository must be removed when upgrading to Oracle Database 12c or later. The following MOS Notes offer plenty of information:

Continue reading...

New Cloud Control 12.1.0.5 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:

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.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 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

Continue reading...

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

The certification for Oracle Database 12.1.0.2 as Repository Database underneath of Oracle Enterprise Manager Cloud Control 12.1.0.4 (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 12.1.0.2

Oracle Database 12.1.0.2 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...