Schema Consolidation – Setup

Schema as a Service provides database consolidation by allowing administrators to host multiple application schemas within a single database. This offers Database as a Service to possibly hundreds of application users without creating database sprawl. Users can perform day-to-day actions like provisioning, monitoring, and backup, all from a single Self Service console. Schema as a […]

Complément: Mettre en place AWR Warehouse

Le patch permettant la mise en place d'AWR Warehouse dans Enterprise Manager est disponible ( cf note 1907335.1) !

Pour activer AWR Warehouse, l'administrateur d'Enterprise Manager doit :
  • Créer une instance de base de données Oracle Database (recommandé) ou pour le référentiel AWR
  • Découvrir l'instance dans EM12c
  • Appliquer le patch sur l'OMS (cela permet d'avoir AWR Warehouse dans le menu)
  • Appliquer le (more...)

Using the Self Service Portal with PDBaaS in EM

Following on from my earlier blog post on setting up Pluggable Database as a Service (PDBaaS) in EM, this post will cover how you actually use the Self Service Portal to create on demand an empty pluggable database within the container database I created for that earlier post. You’ll no doubt be pleased to […]

Complément : EM12c pour mettre en place une solution MWaaS

Database Consolidation (PDBaaS) – Setup

Introduction This is an almighty long post, because it walks you step-by-step through the setup of Pluggable Database as a Service (PDBaaS) in Enterprise Manager so there are a lot of screenshots. The actual setup doesn’t take long at all, so don’t be put off by the length of the post. :) Just as […]

Complément : AWR Warehouse (ODTUG Webinar)

AWR Warehouse Webinar from ODTUG

The webinar is over, but you haven’t missed out on everything I presented on the console feature, under the hood and behind the scenes!

You can access the slides from today’s presentation, as I’ve uploaded them to slideshare and the scripts are easy to locate on the scripts page here on DBAKevlar.

Thanks to everyone who attended and a big thanks to GP for doing the introduction and ODTUG for hosting us! :)


Del.icio. (more...)

Delivering DBaaS using EM12c

One of the jobs I’m currently working on is writing a technical whitepaper on Delivering DBaaS using EM12c. I realized as I was starting it that a technical whitepaper really isn’t the place for a step-by-step how-to sort of description, so I thought I’d better blog about it instead. Actually, I’m going to write a […]

Granting Access to BI Publisher in EM

In my Configuring Highly Available BI Publisher in EM post, I covered how you configured BI Publisher in a highly available environment. When BI Publisher is configured, by default only the super-administrator accounts you have defined in your EM12c environment have access to the tool. That means that none of your normal administrator level […]

Tuning EM12c, the OMS, Part II

We went over a few of the Java “tuning” options last time, so let’s go onto the OMS tier for this post.

Location, Location, Location

High latency issues between the OMS(Service) and the OMR, (Repository) when separated by geographical location is common.  It’s important when designing the Enterprise Manager environment that you keep your OMS hosts close to the repository hosts geo-locationally.  Your agents can be global, with minor network considerations, but the (more...)

Cloud Control: How a Camel can make you cross a Data Guard Mountain

In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. And it doesn’t have to be.

But first a short description of the situation. I have a working Data Guard broker configuration between two Cluster Databases running Oracle on linux x86-64. Both clusters have an Cloud Control agent ( (more...)

How to add your Standby Cluster Database to Cloud Control

The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider myself part of the people who like to work with the command line. That way you really get to understand what you are doing and you won’t have to panic when you don’t have a GUI at your disposal. Once that’s an acquired skill I will (more...)

Tuning EM12c- Onto the Next Tier, JAVA

I’ve already talked about the recommendations we make for properly sizing an Enterprise Manager 12c and many already know about tuning a database, but let’s look at the tuning that may be a bit foreign to DBAs.  We’ll start with Java.

We all know that it’s part of the EM12c architecture, but we often don’t realize that it requires attention to assist in Enterprise Manager running efficiently.

JAVA Updates

The Java component of the (more...)

Configuring Highly Available BI Publisher in EM

Those of you that have been around Enterprise Manager 12c for some time will recall the joy (for want of a better word!) we used to have configuring BI Publisher to work with Enterprise Manager. For those of you that haven’t looked at it yet, BI Publisher is the replacement for the now deprecated Information […]

Blog : Oracle DBA Blog 2.0

Un blog intéressant à consulter : Oracle DBA Blog 2.0 

On y trouve des articles intéressants; par exemple sur Enterprise Manager & CMDB : 

EM12c and Hardware

I often hear, “My EM12c environment is slow!” and I just as often am granted access to the environment and find out that EVERYTHING is running on an old single core server with 2Gb of RAM someone found lying around.  Enterprise Manager is often an after thought to many IT organizations.  After all the work has gone into the production environments that build revenue, there is often a disconnect on how important (more...)

EM12c Rel. 4, the Security Console

Why is the Security Console an important new feature?  I was contacted by three people just this last week on how to secure an EM12c environment.  How many of you are still logging in to the EM12c console or CLI with the SYSMAN account?

Bad DBA, BAD!!  :)


Security Console

The Security Console helps the administrator set clear expectations for security standards for database administration and EM12c environment security.  It provides read (more...) Middleware Management Features

Probably the last area for me to touch on in this series of blog posts about the Enterprise Manager release is the middleware management enhancements. That’s by no means because middleware management is the least important areas of enhancement, but rather simply a reflection of the fact it’s the area I know least about. […]

Annonce : Enterprise Manager Extensibility Exchange

La nouvelle version d' Enterprise Manager Extensibility Exchange est disponible.

(Si vous préférez l'ancienne version, utilisez la vue "classique")

The *New and Improved* Extensibility Exchange is Here!

How many of you use Oracle Enterprise Manager 12c, recognize it can do so much more than just taking it out of the box and plugging it in, then proceed to start building metric extensions, plug-ins, writing EM CLI scripts, etc? How cool would it be if you could peruse a library of plug-ins to support the extensibility framework for you to check out and use for the benefit of your company and you?

If (more...)