Setup Database as a Service using EM12c DB Plugin 12.1.0.3

15 February, an update of some Plugins was released.

The new version of the DB plugin (12.1.0.3) includes several new features in the area of diagnostics, High Availability, Manageability, RAC and Grid Infrastructure, Security etc.

The list of new plugins include the brand new plugin “Oracle Storage Management Framework”, enabling Snap Clone functionality leveraging the “Snapshot” and Copy features of the underlying storage. The new and updated plugins are packaged with new features including “Testing as a Service”, “Snap Clone”, “Schema as a Service” and “RMAN based Database Provisioning”.

This document describes an example of the setup of the Database Cloud, by using a Service Template that is based on a DBCA template. It also shows an example of the execution of a request made by a user in the Self Service Portal, using the newly created Service Template.

Setup Database as a Service using EM12c – DB Plugin 12.1.0.3

Setup Database as a Service using EM12c

I have been struggling for some time to complete this paper on the setup of DBaaS. Actually everything went fine, except for the final step where a Self Service Portal user requested for a new Database. After some analysis it appears that the integration I did immediate after the installation of my EM12c box with OVM Manager 3.1, was the “stand in the way” to successfully complete this final step.

After removing the integration between EM12c and OVM Manager 3.1 I finally managed to execute a successful Database request from the Self Service Portal. So, take care when working in a similar setup and trying to the DBaaS setup!

Resolution was with full assistance of Oracle Support (thanks to them).  A bug was registered and will be subject for a fix.

Anyway, please find here the paper describing the full setup using EM12c – 12.1.0.2 (+PSU1). Have fun reading it.

Setup Database as a Service using EM12c

Oracle Enterprise Manager 12c Facts and Concepts

Oracle Enterprise Manager 12c was released October 2011 and introduced a complete rewritten framework for monitoring and managing Data Centre components.

Where Oracle Enterprise Manager evolved from just a Database Monitoring tool (EM 10.1) to include Middleware targets and targets within the complete Oracle Software Stack and even non-Oracle targets (like MS SQL Server, IBM Websphere, BEA Systems, Storage and Network devices and others…), to a Grid supporting and Database Lifecycle support tool. Enterprise Manager 12c now supports Lifecycle Management throughout the complete Oracle Software and Hardware Stack (Enterprise Manager OPS Center 12c), delivering “Application to Disk” monitoring, advanced management for Oracle Hardware, Virtualized environments and fully supporting Oracle’s Cloud concepts including PaaS (Platform as a Service), IaaS (Infrastructure as a Service), DBaaS (Database as a Service), MWaaS (Middleware as a Service) and several more being announced (Schema as a Service, Testing as a Service).

Even more than before, encouraging Partners to embrace the new Plug-in framework and to deliver additional features to support non-Oracle environments.

This paper will introduce several Facts and Concepts to give a good overview of available features, challenges and ideas coming up when starting implementation of what has become a key part of Oracle’s strategy to deliver hardware and software systems engineered together as appliances and integrated systems.

Oracle Enterprise Manager 12c – Facts and Concepts

Enterprise Manager 12c – Configuration Management

Where in Enterprise Manager 10 and 11g, the Configuration Management Pack provided us with Configuration search and Comparison features; Enterprise Manager 12c provides these features (and more) through packaging in the following Packs:

  • Management Pack for Oracle Coherence
  • Application Management Pack for Fusion Applications
  • Oracle Database Lifecycle Management Pack
  • Configuration Management Pack for Applications
  • WLS Management Pack EE
  • SOA Management Pack EE
  • Oracle BI Management Pack
  • Management Pack for Non-Oracle Middleware

In this document I like to show how easy it is to perform queries on the CMDB within Enterprise Manager, based on the ‘Out of Box’ queries that come along with the package.

Enterprise Manager 12c – Configuration Management

Integrating BI Publisher with Enterprise Manager

As part of Enterprise Manager 12c a complete set of default Reports deployed in BI Publisher is available after integrating BI Publisher with Enterprise Manager.

The paper describes the installation and integration of BI Publisher 11.1.1.6.0 with Enterprise Manager 12.1.0.2 and it is really as easy as 1,2,3…

In this paper I assume that you did a fresh install of EM 12.1.0.2, however if your EM environment is based on an upgrade from 12.1.0.1 to 12.1.0.2 please take notice of the documentation Post-Upgrade Steps to take after upgrading to BI Publisher to 11.1.1.6.0

Integrating BI Publisher with Enterprise Manager

EM12c Monitoring Best Practices

Some weeks ago I posted an article on my blog after attending Ana McCollum’s presentation “Beyond the Basics: Making the Most of Oracle Enterprise Manager Monitoring” at OOW 2012.

In this document I further elaborated my notes to give a good overview of all topics discussed during the presentation. All credits for Ana!

To my opinion this document could very good be the bases for your guys “EM12c Best Practices” document.

I included some snippets of pictures I took of the slides during the presentation. They are bit blurry (sorry for that), but I hope they will give a bit more understanding.

EM12c Monitoring Best Practices