OEM Cloud Control: Rob Zoeteweij

Oracle Enterprise Manager Cloud / Grid Control

Discover EM12c Repository Database after Installation

After initial installation of Enterprise Manager 12c, you will notice that all EM 12c related targets (Host, Middleware Targets, Agent) have been discovered except for the Repository Database and Listener.

Here is how to discover the EM 12c Repository Database

Discover EM12c Repository Database after Installation

Filed under: Cloud Control 12c, Installation, Oracle Enterprise Manager 10 - 11g - 12c

Provisioning of an Oracle Database using EM 12c

In my previous post I described the creation of an Oracle Database. This procedure assumes the presence of both the Grid Infrastructure and Oracle Database software.

The Provision Oracle Database Deployment Procedure takes care of all of this, so installing the Grid Infrastructure software and configuration, installing the Oracle Database software and the creation of the Database!

Provision Oracle Database using EM 12c

 

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c, Provisioning, White Papers , , , ,

Creation of a SIngle Instance Database using EM 12c

The creation of an Oracle Database using EM 12c is an easy straight through process. If you are familiar with DBCA you might even do this with your eyes closed.

In the example I describe the creation of a Single Instance Database version 11.2.0.3, using the Grid Infrastructure.

Creating Oracle Database using EM 12c

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c, Provisioning, White Papers , , , ,

Creating a Golden Image in the EM 12c Software Library

This example describes the creation of a custom component in the EM 12c Software Library.

I have been using the creation of a “Clusterware Clone” for the example, but creation of any other type will be a simular process.

Creating Golden Images in EM 12c Software Library

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c, Provisioning, White Papers , , , ,

Configuring Oracle VM Manager in EM 12c

Starting with EM 12c, Oracle VM Manager can be seamlessly integrated in the EM 12c console. This document describes the steps that need to be performed, assuming you have an Oracle VM Manager and an Oracle VM Server up and running.

Configuring Oracle VM Manager in EM 12c

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c, White Papers , , , , ,

EM 12c is taking care of Group organization

An Administration Group can be seen as a “Dynamic” Group. Dynamic, because based on Membership Criteria assigned to the Administration Group, Targets will be assigned to the Group automatically on the moment they meet the Criteria.

For instance, Administration Group “All Production Databases” would have automatically assigned a Database Target on the moment Target Property “Deployment Type” for this Database is set to “Production”.

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c , , , ,

Metric Extensions to replace User Defined Metrics

Metric Extensions

In EM 11 (and earlier releases) we could use User Defined Metrics to extend the “out-of-box” monitoring capabilities. One of the drawbacks of User Defined Metrics in pre 12c releases is that they only applied to the Host and Database (Instance and Cluster Database) Target types.

EM 12c introduces Metric Extensions for the same goal, however supports any Target type.

Metric Extension Library

In EM 11 (and earlier releases) there isn’t a central location to store and maintain User Defined Metrics. A User Defined Metric could only be created as a Target related object, meaning you had to pick a certain Target (Host or Database) and create your UDM. Then by including your UDM in a Monitoring Template you would be able to deploy the UDM to other Targets.

By identifying one specific Host and one specific Database we would simulate a Library for our UDM’s. Normally this would be the OMS (Management Service) Server (or 1 of them when using multiple OMS’s) for Host UDM’’s and the OMR (Management Repository) Database Target for Database related UDM’s.

In EM 12c, a Metric Extension Library has been introduced for this purpose!

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c , , , ,

Incident management, EM’s close encounter with ITIL

EM 11 and earlier releases provided us an alerting framework based on Metrics and Thresholds. EM 12c introduces a complete revised framework based on Incidents and Events.

Events

An event is a single occurrence detected by EM and related to a single entity (well that is what the Administrator Guide tells us). Such a single entity could be: a Target, a Configuration File, a Job etc. Examples of an event include: Database Instance is down, Configuration File has been changed, Job executions ended in failure, Host exceeded a given percentage of CPU, Tablespace Space is exhausted etc.
No doubt this immediately makes the comparison with Metric Alerts in EM 11 (and before).

Incidents

When working in an IT environment that uses the ITIL (Information Technology Infrastructure Library) Best Practice processes and procedures, the term Incident does ring a bell doesn’t it? When searching for a definition of “Incidents” according ITIL in Wikipedia, you will find: “Incidents are the result of failures or errors in the IT infrastructure. The cause of Incidents may be apparent and the cause may be addressed without the need for further investigation, resulting in a repair, a Work-around or a request for change (RFC) to remove the error.”

EM 12c now allows us to make a definition of an Incident as a single or closely correlated set of events that identify a disturbance within our Data Center. So an Incident Definition might be as simple as the relation with a single Event “Available space in Tablespace has gone down a specified limit” or as more complex as an Incident “Server is running out of resources” that would be related to a set of Events relating to the usage of CPU, I/O and Memory Resources.

Integration with 3rd Party Helpdesk systems
Like we were used in EM 11 (and earlier release) EM 12c allows you to integrate with 3rd Party systems to for instance create a Ticket as result of an Incident occurrence.

Read the rest of this entry »

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c , , , ,

Had a great time, see you next year…

After my last session today on Data Masking and the wrap up party, it’s all over for this years OOW. Again I learned a lot, talked to a lot of people, met a lot off acquaintances, did some partying and simply had a great time.

I’ll be back….

See you next year at OOW 2012

Filed under: Events, OOW 2011, Oracle Enterprise Manager 10 - 11g - 12c

Why I think Out-of-Place Patching is a very nice new feature in EM 12c

When working with shared Oracle Homes you environment will look like this:

  • One ORACLE_HOME in which installed the most recent release of Oracle DB, for instance 11.2.0.2
  • Several Database Instances running on the Oracle Software installed

If we want to apply a Patch to an environment like this we need to follow a scenario like this:

  1. Download the Patch manually from MOS
  2. Study the documentation
  3. Check if the proper version of OPatch is available and upgrade if necessary
  4. Clone the current ORACLE_HOME (you might be using a Golden Image in the EM Software Library for this)
  5. Install the Patch on the cloned ORACLE_HOME
  6. Stop database per database and copy necessary files (<oracle_home>/dbs/…)
  7. Modify /etc/oratab to modify the path to the cloned ORACLE_HOME
  8. Startup the database in the clone ORACLE_HOME
  9. Execute necessary sql scripts

10. Check and document

Indeed an intensive and error prone scenario.

EM 10.2.0.5 and 11.1 provided us with a Patching procedure that was unable to cover this scenario.

EM 12c however now provide us with a procedure that takes care of this “Out-of-place” Patching procedure.

Starting with the support of Single Instances and RAC on Exadata, the support for RAC on clustered Servers is soon to follow (obviously as this is a more or less same procedure as the support for Exadata).

By this IT departments are able to perform a robust, complete patching procedure in which databases will be patched one by one with a minimum of down time.

Cheers

Filed under: Cloud Control 12c, Oracle Enterprise Manager 10 - 11g - 12c , , , , , ,

Archives

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 30 other followers

Blog Stats

  • 47,576 hits
Follow

Get every new post delivered to your Inbox.

Join 30 other followers