Creating an 11g R2 (11.2.0.3.0) Oracle Management Repository Database for Use with OEM Cloud Control 12c (12.1.0.3.0)

Oracle Enterprise Manager Cloud Control 12c (OEM CC 12c) is a web-based application that stores and retrieves the metadata about all of the targets in the cloud infrastructure from its very own database called the Oracle Management Repository. The question that arises is that which Oracle database versions are supported by OEM CC 12c, so that one of these databases can be used as an Oracle Management Repository database.

In my tutorial below, I will demonstrate to you how to create an Oracle Management Repository database. I will also demonstrate in a subsequent tutorial as to how the database can be configured with OEM CC 12c.

To begin with, there are multiple Oracle database versions that are supported by OEM CC 12c (12.1.0.3.0) -

A. 11g Release 11.2.0.3.0
B. 11g Release 11.2.0.2.0
C. 11g Release 11.2.0.1.0
D. 11g Release 11.1.0.7.0
E. 10g Release 10.2.0.5.0

In my tutorial, I will be creating an Oracle 11g Release 11.2.0.3.0 database as the Oracle Management Repository database for OEM CC 12c.

Time Duration: 30 to 60 Minutes (45 Minutes on an Average!)

Migrating an Enterprise Edition Oracle Database from 11.2.0.3.0 (11g R2) to 12.1.0.1.0 (12c) on Redhat Enterprise Linux Server 6.0 x86-64

Oracle Database 12c (12.1.0.1.0) is Oracle's first pluggable database that brings a completely new level of efficiency into the existing database platform and that makes database consolidation much more easier and optimal, while a melange of other new features address performance, availability and many more attributes of the product line.

In this tutorial, I will demonstrate to you how to migrate an existing Oracle database from version 11.2.0.3.0 (11g R2) to version 12.1.0.1.0 (12c) -

Time Duration: At least 3 to 4 hours ( at least 3.5 hours on an average!)