Will the REAL Snap Clone functionality please stand up?

Every so often our competitors like to spread false information about our solutions so as to gain unfair advantage. I wanted to address this for the Enterprise Manager Snap Clone functionality, so this blog post describes the Snap Clone solution as it currently stands (November 2014).

Let’s start by introducing Snap Clone functionality. I blogged on that a few months back, but a few months can be an eternity in software development terms, so here’s (more...)

Annonce : Web Séminaire DBaaS


Accélérer considérablement vos délais de mise à disposition des services DB avec une infrastructure de Cloud Privé pour vos bases de données
(Database as a service).

Mardi 18 novembre 2014 ; de 11h à 12h

Les solutions Oracle (more...)

Setting Up Chargeback in EM 12.1.0.4

Some time back, I posted a blog entry about Metering and Chargeback in Enterprise Manager, where I covered the basic capabilities of the Chargeback Application. It’s taken me some time to get back to the promised followup blog post on setting up Chargeback, what with Oracle Open World getting in the way of things, but that’s what I’m finally doing now.

Chargeback can be setup in EM12c by any user with the EM_CBA_ADMIN role, or (more...)

Complément : Chargeback

A lire, l'article de Cap Gemini sur Enterprise Manager 12c, le Metering et le Chargeback :
http://www.capgemini.com/blog/capgemini-oracle-blog/2014/09/oracle-cloud-billing-with-metering-and-chargeback

OOW14 Session: SQL Tuning Without Trying

Many thanks to all those who attended my session "SQL Tuning without Trying" at Oracle Open World 2014 #oow14. I hope you found the session useful.

If you want to download the slide deck, here it is. As always, I would really, really like to hear from you.

Découverte : Workshop Enterprise Manager

Oracle France propose début octobre un workshop permettant de découvrir; à travers 6 ateliers de manipulation,  la solution Oracle Enterprise Manager 12c Cloud Control.

Annonce : MySQL & Enterprise Manager

Oracle a annoncé l'extension des capacités d'Oracle Enterprise Manager à superviser des bases de données MySQL.

Plus d'informations :

Private Cloud and Lifecycle Management with EM12c at OOW14

Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year! :)

To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If (more...)

Complément : Sauvegarder une instance dans le Cloud Publid Oracle

Depuis avril 2014, Oracle propose une solution de sauvegarde Cloud, appelée Oracle Database Backup Service :

https://cloud.oracle.com/database_backup?lmResID=1394421723860&tabID=1394421714895 


La console Oracle Enterprise Manager 12c vous permet de piloter vos sauvegardes et restaurations directement sur Oracle Database Backup Service.


Plus d'informations :


OOW : Préparer son parcours

Complément : Analyse des performances sur du long terme

Complément : Construire un catalogue de services

Complément : Réduction du temps de patching OMS


Depuis quelques semaines, la nouvelle version d' Oracle Enterprise Manager (12.1.0.4) ainsi que les bundle patches pour OMS sont disponibles.
Si vous prévoyez de d'appliquer ces patches et que la problématique d'arrêt de service vous concerne, il est désormais possible de réduire le temps d'arrêt.
Le document intitulé "Reducing Downtime While Patching Multi-OMS Environments" contient les instructions et les étapes pour cela.

Complément: Mettre en place AWR Warehouse

Le patch permettant la mise en place d'AWR Warehouse dans Enterprise Manager 12.1.0.4 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 12.1.0.2 (recommandé) ou 11.2.0.4+ 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...)

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

Complément : AWR Warehouse (ODTUG Webinar)

EM12c upgrade from 12.1.0.2 to 12.1.0.3

Now that Oracle Enterprise Manager Cloud Control 12c Release 3 (aka EM12cR3!) has been out for a few weeks, I decided to brave it and upgrade our Production stack today. In this post, I’ll be upgrading an EM12cR2 (12.1.0.2) installation which consists of two OMSes, running (more...)

Automatically purging OMS log and trace files in EM12c

Enterprise Manager Oracle Management Server (OMS) installations generate huge amounts of log and trace files under the covers these days, and although the logs are rotated out-of-the-box, they’re not automatically deleted.  Over time (as I was reminded again today ), these logs can amount to a large portion of your (more...)

Upgrade Enterprise Manager Cloud Control 12.1.0.1 to 12.1.0.2

Original Post can be viewed at Upgrade Enterprise Manager Cloud Control 12.1.0.1 to 12.1.0.2

Oracle released 12.1.0.2 Enterprise Manager few days back and have released it for most of platforms. You can directly upgrade Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1) [with or without Bundle Patch 1] to 12.1.0.2 There are no pre patches required for this. But this upgrade requires considerable downtime. Oracle has termed this upgrade [...]

AskDba.org Weblog

Tablespace 195% Full … must be the metric system

I was recently refreshing a test database with production data (using datapump if anyone cares) and had forgotten to check the tablespace sizes between prod and test. During the load, I obviously ran out of space. A quick check in prod showed I needed 4GB of space. The test tablespace was set to grow to 2GB max. To add space, I performed a simple command to add the space.

ALTER DATABASE DATAFILE '/u01/oracle/data01/blah.dbf' RESIZE 8GB;


I resumed the datapump and went on my merry way. A few minutes later I received an email from Grid Control that the tablespace (more...)