Most of you know I don’t like pink, but I also am not a fan of yellow. Yellow houses Yellow flowers Yellow in my EM12c summary page You know what yellow I’m talking about: Now I’m just as disturbed by the red section of that graph, but today, we’re going to focus on the unknown, the yellow. If something is down, then you know it isn’t uploading data and is most definitely a critical issue, but what about the unknown?  Why is Enterprise Manager reporting something is unknown? To first tackle this type of summary, we need to know the…

I’m often asked what management pack is used by what feature and there is actually a very easy way to find out this information in the EM12c console. Let’s say we are in ASH Analytics and want to view what management packs are required as part of this feature utilization: Click on the global Setup menu in the upper right, then click on Management Packs and Packs for this Page– You will quickly see a pop up page that shows you what management pack(s) are required to use the ASH Analytics feature: If we jumped to SQL Monitor and did…

So back at the end of the EM CAB, I’d received an email stating I had an over-sized database and too many hits to continue on Go Daddy as the host for my website.  I called into tech support to understand what options I had, but was never told that I had any option but leaving Go Daddy as my hosting service.  I was told I had two weeks per the email, but asked for three and was told on the phone that wasn’t a problem.  I then did some research and decided that Blue Host had done well supporting…

This is the first of many posts I’ll do where we take a particular issue and trouble-shoot.  I’ll go through multiple scenarios to show the common steps to take via the Enterprise Manager 12c from discovery to identification to research to explanation. This blog will use the following features: ASH Analytics SQL Details ASH Report The first thing we need is an issue- Note the CPU red line-  the IO is considerably over that and quite a lot of IO, along with Commit and Concurrency waits.  We’ll start with this as our issue that we can see, has quickly escalated…

There are a number of Verification Utilities for Enterprise Manager 12c, (EM12c) and I’ve written about them before, but today I’m going to start on the Repository Verification Utility, (REPVFY).  This will be an ongoing series, as there are so many valuable features rolled into the utility and new ones that will be added as new patches and releases happen. For this post, I’m going to be reviewing a level 2 diagnostics report from a new repository database.  This is going to offer us all kinds of valuable data about the environment and should be considered by any EM12c administrator…

Now that we learned in Part I how to create a notification schedule for a specified user so that it will only page one individual on an oncall rotation, I’ll now show you how to use this in conjunction with rulesets to complete the process of modernizing and automating your oncall. In my Test scenario, I’ve already made copies of the main rule sets, have deviated rules by three rules and four groups, (mission critical, production, test and development.) Mission critical are all systems that I WANT to be paged for after hours and need to know immediately if there…

I came across a discussion on Oracle-l on how after hours paging was handled for many companies and was kind of surprised how many DBAs still carry around a secondary pager/cell phone or are just expected to be woke up if on call or not.  I’m not one to go back to sleep once I’m woke, so I’ve been a proponent of EM notification schedules for after hours paging.  Now there are other ways to handle this in Enterprise Manager 12c as well, but we’ll use this method, as it is backward compatible to OEM 10g, too. The requirement of…

Lately I’ve been having more discussions on securing the EM12c environment.  All of IT has a tendency to treat the Enterprise Manager as a afterthought in both hardware allocation, as well as security best practices.  No one is sure of exactly why this is-  they all have their theories, but we do know it happens often. Today we are going to go over some of the auditing options within EM12c.  Basic auditing is turned on by default in the environment, but only covers basics processes.  There are over 150 auditing options and extensive information can be collected, retained within the…