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 :


Migrating to ASM

On the Maximum Availability Architecture website, there’s a paper on <awful term alert>Best Practices</awful term alert> for Database Consolidation. It’s a great paper, as you’d expect from the MAA guys (well, apart from that awful term alert I had to add! :) ). Since database consolidation is an area I work in a lot, I thought I’d start looking at implementing as much of their recommendations as I could in Enterprise Manager, which of course is (more...)

Change unknown SYSMAN password on #EM12c

When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN.  Without knowing the password for SYSMAN, how can I access the EM 12c interface?  The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.

Note:
Before changing the SYSMAN password (more...)

Monitor Dell PERC when running on Oracle Virtual Server 3.x

In this article I will try to explain how to monitor your Dell Raid Controller with Cloud Control when running Oracle Virtual server 3.x (OVS3.x).

Some time ago a physical drive broke down on one of our Dell PowerEdge Servers. Not causing any problem because it was configured in a raid set using the Dell build in PowerEdge Raid Controller( hereafter PERC). However, we did not notice this breakdown until also a second (more...)

OOW : Préparer son parcours

Complément : Analyse des performances sur du long terme

New Tips and Techniques page

In case you haven’t noticed it – and chances are you haven’t noticed because I just created it! :) – I’ve added a new page called “Tips and Techniques” to the website. It’s where I keep a random collection of odd items I’ve come across that might be of interest yet don’t deserve a full blog post. It’s sort of like a FAQ list, but not necessarily with the “F”. :)

You can reach it either via (more...)

Why am I seeing “Result: Failed. Insufficient resource available” messages?

This is an interesting point that came up recently, where someone had a DBaaS environment running on an Exadata system for a couple of months, with no issues.  It has recently started to return errors on the Database Cloud Self Service portal in the “Placement Algorithm” region:

Constraint : Number Of Databases
Current Resource Usage: 18
Total Resource Available: 10
Maximum Limit Defined: 10
Requested Value: 1
Total Resource that can be used: 10
(more...)

Complément : Construire un catalogue de services

Metering and Chargeback

In the past few posts, I’ve covered setting up PDBaaS, using the Self Service portal with PDBaaS, setting up Schema as a Service, and using the Self Service Portal with Schema as a Service, all of these using Enterprise Manager Cloud Control 12c release 12.1.0.4. Now I want to move on to an area where […]

Using ASH Analytics to View Blocked Sessions

When concurrency is the crippling factor in a database performance issue, often I’m told that viewing blocked sessions in Enterprise Manager is difficult.  The query behind, along with flash image generation in any Enterprise Manager can take considerable time to render and no matter how valuable the view is, the wait is something DBAs just can’t hold out for when needing the answer now.

Blocking Sessions View in OEM

If you’re wondering which feature (more...)

Using the Self Service Portal with Schema as a Service in EM 12.1.0.4

In a previous blog post, I covered setting up Schema as a Service for schema level consolidation. In this post I’m going to cover how to use the Self Service Portal with Schema as a Service in EM 12.1.0.4. Just as it was in my posting on using the Self Service Portal with DBaaS, our […]

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.

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 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...)

Using the Self Service Portal with PDBaaS in EM 12.1.0.4

Following on from my earlier blog post on setting up Pluggable Database as a Service (PDBaaS) in EM 12.1.0.4, 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

Complément : AWR Warehouse (ODTUG Webinar)

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 : http://dbaharrison.blogspot.de/2014/05/on-using-cloud-control-as-cmdb.html