Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted April 23, 2012

Oracle Enterprise Manager 12c Cloud Control - New Features Part One

By Karen Reliford

As the Oracle family of products continues to expand and evolve, management and maintenance continues to be a big chore for administrators.  Since the days of 9i when Oracle first introduced the stand-alone java tool (Oracle Enterprise Manager), Oracle has focused on creating a robust tool to help administrators with the increasingly complex and challenging job of keeping on top of their Oracle "world".   With Oracle 10g they introduced Enterprise Manager Grid Control, a centralized tool to manage not only Oracle objects, but also third party products.  This tool was enhanced greatly with 11g Grid Control, especially in the area of functionality.  As Oracle continues to add more and more functionality and tools into their web-centric DBA management tool, it is fast becoming the preferred tool of database administrators

Oracle's newest release of Enterprise Manager is 12c Cloud Control.  Cloud Control has a multitude of new features and lots of very interesting new functionality.  So much so, that it would be impossible to cover all of the significant improvements in one single article.

Oracle looked at ten key focus areas and incorporated new functionality and features in each of them.  The ten key areas are:

1) The infrastructure or framework behind Cloud Control
2) Cloud Control Management
3) Capacity Planning
4) Exadata/Exalogic Management
5) Configuration Management
6) Provisioning/Patching, Application Management
7) Database Management
8) Fusion Middleware Management
9) Middleware Management and
10) Application Quality Management    whew...what a list!

This article is going to focus on the first of these areas, changes to the infrastructure behind Cloud Control.  In my next few articles, I will look at several of these key focus areas and share what are my favorite new features and/or new functionality in each of them.

12c Cloud Control Infrastructure/Framework New Features

Let's start with changes to the basic infrastructure of 12c Cloud Control.  Below is a simple diagram of the key pieces.

Cloud Control Infrastructure

Cloud Control Infrastructure

Essentially, like its predecessor, Grid Control, 12c Cloud control has four key parts.  First, we have the Oracle Management Repository (OMR), where all of the data/metadata for 12c Cloud Control is stored. 

Second, we have the Oracle Management Service (OMS).  Essentially the OMS consists of a set of J2EE applications that run on an Oracle WebLogic Server. 

Third, we have the Oracle Management Agents (now with plug ins) on each of our managed hosts. 

Fourth, we have the web interface itself, the Cloud Control Console.

Let's explore what's changed in each of these areas....

OMR

The OMR is actually a set of some 4000 objects owned by the SYSMAN account in the database and is now stored in three different tablespaces (used to be two tablespaces).  These are MGMT_ECM_DEPOT_TS, MGMT_TABLESPACE and MGMT_AD4J_TS.  Also, when installing Cloud Control the database must already exist (this actually changed in 11gR2).

By the way, for installing 12c Cloud Control, if you had created the database using DBCA with Database Control, you should use the enterprise manager configuration assistant (emca) to remove the existing repository from the database prior to installing 12c.  The following is the basic syntax of the emca command to remove database control and its repository objects.

$ORACLE_HOME/bin/emca -deconfig dbcontrol -repos drop \
SYS_PWD <password> SYSMAN_PWD <password>

Also, the database should be 100% dedicated to the OMR and not shared, even for an RMAN repository.  This is for a combination of performance, ongoing maintenance and patching and the fact that Cloud Control now comes with a restricted-use database license that can only be used for the OMR.

Cloud Control also has a new installation feature, which is a command line utility called emprereqkit (EM Prerequisite Utility Kit) which is run against the database you intend to use to house the OMR.  It makes recommendations on (and may change) database configuration settings to ensure it will be properly configured to be the OMR database.

OMS

In previous versions, the installation of additional OMSes required that the Oracle WebLogic Server had to be already installed.  Now in 12c that is no longer the case, additional OMSes and the corresponding WLS can be deployed directly from the Cloud Control Console.

A second change, is the fact that metrics in 12c are now gathered by the plug-ins rather than the agents as was the case in both 10g and 11g.

However, I think the most significant change is the new user interface. (More on that in future articles).  One of the new features that affects the user interface is that you can now customize what you see on the various target home pages either based on the target itself or the user logged into Cloud Control

OMA

The OMA is a Java applet that runs on the host machine that services any target that is to be monitored and managed using Cloud Control. 

The new definition of a target is "any software or system for which a plug-in exists". Cloud Control targets include Oracle Databases, listeners, Exadata/Exalogic servers, Oracle Application Server, Oracle WebLogic Server, SOA and E-Business Suite.  Third party (non-Oracle) products can also be managed by Cloud Control by creating or using customized plug-ins.

Plug-ins actually have components that reside in both the OMS and the OMA and two of them are installed into the OMS by default.  These are the Oracle Database plug-in and Oracle Fusion Middleware plug-in.  Other plug-ins can be installed as required in the OMS.  The corresponding plug-in components for the OMA would be added to the agent as matching targets are discovered on the managed host systems.

This move to plug-ins for all target types including even Oracle Databases is new in 12c, and offers a very interesting advantage to us.  Let's assume that Oracle introduces a new release of the database.  In the past, we would have to wait until a new version of Cloud Control was introduced to be able to fully have all functionality incorporated.  Now, with this new plug-in technology - all we would have to is download and install the updated plug-in for the target type...have to love this concept!

While none of these may seem "huge" in the grand scheme of things, the new features of the basic infrastructure, especially the plug-ins concept, look like they're going to be a nice benefit to us as administrators.

Until the next article...

See all articles by Karen Reliford



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM