I have a Test database that is a 2-node RAC system. I am working towards the goal of getting the production database to Oracle 220.127.116.11 in about a month’s timeframe. This of course means that I have to get Grid Infrastructure upgraded prior to the db upgrade. I have upgraded GI on my standby cluster and on my Test database as well. The primary GI upgrade is scheduled for this evening.
Ever since I upgraded GI in Test a few weeks ago, I’ve been getting alerts from EM12c similar to the following:
More and more companies are consolidating environments. Server sprawl has a high cost to any business and finding ways to consolidate to more powerful servers or to the cloud is a productive undertaking for any company.
The Consolidation planner in Enterprise Manager has been around for quite some time, but many still don’t utilize this great feature.
Read about this feature on the DBA Kevlar from Kellyn Pot’Vin-Gorman
This morning, I was reading this article about employees lack of understanding how critical it is to protect business data. The article got me to think about a few different points.
As you may know from a previous post on this blog, or if you follow me on Twitter (BPeaslandDBA), I like Lighty for Oracle, a product by Orachrome. I love this product and how easy it is to obtain performance diagnostic information. I’m very familiar with Oracle’s Enterprise Manager and I use EM12c all the time when I get calls about poor database performance. But I am now hoping that Lighty becomes another tool in my arsenal.
In my group, we work with a lot of customers with very large EM environments. On the range of 2000+ agents. So as you can imagine there’s a little bit of optimizing that needs to get done to account for these numbers.
A few of these standard tweaks have been put into the repvfy execute optimize command. You can make all these changes individually, but if you want to get them all done at once, optimize is your tool.