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...)
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
About 2 months ago I wrote an article about setting up user authentication in Cloud control, based on their account in the Active Directory. As promised, here is the second part describing Cloud Control authorization with Active Directory.
A small recap about why this could be useful:
If your company is preferring Microsoft Active Directory (further named AD) as a source of truth (or at least you´re trying to) you should be using the AD (more...)
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...)
Depuis quelques semaines, la nouvelle version d' Oracle Enterprise Manager (220.127.116.11) 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.
Pour activer AWR Warehouse, l'administrateur d'Enterprise Manager doit :
- Créer une instance de base de données Oracle Database 18.104.22.168 (recommandé) ou 22.214.171.124+ 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...)
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!
Thanks to everyone who attended and a big thanks to GP for doing the introduction and ODTUG for hosting us!
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...)
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.
The Java component of the (more...)
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