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

Enterprise 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 As 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: MOS Note: 278100.1 – How To Drop, Create And Recreate the Database Control (DB Control) Release 10g +11g MOS Note:…

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) for Linux x86 (32-bit) for Linux x86-64 (64-bit) for Windows x86-64 (64-bit) for Solaris Operating System (SPARC) for Solaris Operating System (x86-64)…

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…

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: 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.1 – 12c Database has been Certified as a 12cR4 Repository with Certain Patchset…