This is Part IV in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level.   You can read Part I, Part II,  Part III and Part IV to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Tracking Warnings through the Incident Manager There were a few changes we made to metrics so that we have moved generic alert log alerts to “warning” only.  We now need to add one rule to create incidents so these are logged in the…

This is Part IV in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level.   You can read Part I, Part II and Part III to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Incident Rule Sets There was a slight mis-communication between development groups when the Incident rules and the metric value settings were configured for the EM12c “out of the box”.  Currently, 90% of metrics are only set with warning thresholds.  The Incident rule sets…

I’ve had a couple peers ask me about this recently-   They’ve attempted to discover targets on a host and experienced failures.  This commonly occurs for the following reasons: 1.  Incorrect information regarding the target exists at the target host level. 2.  The OMS has an unresolved issue, status in pending state, etc. My recommendation on #2 is to always check each step as your implement EM12c, (complete the EM12c installation, adding a new host, adding a new database, etc.)  Your status should be 100% green, if its not, take care of this first before you start attempting to add…

This is part II of the series on effective monitoring with EM12c. You can read Part I of this series to ensure you have the complete setup for your Enterprise Manager 12c for effective monitoring and notifications. Groups and Administration Groups There are two different features that can be used to assign targets to groupings to ease management. Groups were introduced early on and Administration Groups is new to EM12c.  Although Administration Groups is the newer feature, it is limited to one escalation type, as a target can only belong to one administration group and notification type. Administration Groups predecessor,…

Effective Monitoring This is going to be a five part series discussing how to set up EM12c effectively and productively so DBAs are offered critical alert notification and the ability to manage the environment through the incident manager in a (possibly) different way than first conceived. For any DBA who serves an on call schedule, the importance of receiving pages that are production critical outages and contain no “white noise” is essential to your success and your sanity.  Its been a goal that Enkitec has been striving towards regularly and I can attest to this  as a Remote DBA I’ve…

I won’t apologize to Oracle for saying that the new Incident Manager has some quirks to it, but it does, especially when it comes to managing incidents, events and how to clear out both.  I’m going to attempt in this post to explain how to check to see if you have alerts that can be cleared with an EMCLI command and then also take you through clearing out from the GUI, which is available in the Release 2 of EM12c. If you want to know what kinds of stateless alerts that can be cleared manually, then once logged into the…

The Enterprise Manager Diagnostics Kit, (EMDIAG) is a great addition to have installed and be familiar with on your Enterprise Manager 12c, (EM12c) environment BEFORE you need it.  There are three main kits: repvfy – Extracts data from the Grid Control or DB Control Repository to help you to maintain or diagnose problems in your Grid Control or DB Control. The repvfy Kit is partly included in the Cloud Control 12C Support Workbench for the OMS. agtvfy Kit – A set of command lines to help you to maintain and diagnose problems in your Cloud Control, Grid Control or DB…

Sometimes you want to change the way you are managing, monitoring or notifying in your EM12c environment that may require you to delete and recreate you administration groups.  If you are testing out administration groups, then you may very likely create, delete and recreate, as they are not something you can edit as you go along, (the system even warns you of this as you create them. As I was working through a unique notification issue and how to handle it with administartion groups, I experienced a failure on creation after the deletion of a former admin group in EM12c,…

Any of us in the DBA world know that HPUX doesn’t get a “lot of love” from Oracle. It’s one of those Operating Systems that due to the time and resource restraints on Oracle to provide the level of support for their core OS platforms and products, demands that it is “supported” but will not receive the first line of development that Linux or Solaris will. With that said, I have a clients who do prefer HPUX with Oracle products with Windows a close second. They have numerous Windows VM environments for test and non-VM for production which serves them…

Metric settings, alerting, notifications and escalations have been enhanced in EM12c to support the demands that are falling heavier on the DBA and the larger support scale of the database environment, (ASM, Exadata, middle-tier systems, etc…)  As frustrated as I know some folks became when trouble-shooting alerting issues in previous versions of the Enterprise Manager, it should be acknowledged that EM12c has many new features and a new interface for this important part of the Enterprise Manager. I know many times, I’m so busy keeping my eye on the ball, that I can miss what’s stealing third base right under…

This is another little known feature, but one you have to work with to get a solid feel for and find value in. When I came upon it in EM12c, I was not that impressed, but quickly became more impressed with the “just the facts” and “all in one” interface that it is, especially if you are working in a RAC environment. Its another one of those features the DBA can stumble upon as they are working through issues, but to purposefully utilize it, the quickest way is after logging into the Enterprise Manager, click on Targets –> Hosts and…

As many know I’ve been busy trying to bring our many-times patched 10g Enterprise Manager migrated to a new server with EM12c.  I thought it would be interesting to see how fast I could break it, considering my skills, I knew it might not be a challenge. Scenario 1.  Bug with listener refusing to connect dynamically to EM12c repository database. 2.  After releasing code to the database for advanced notification,  the SYSMAN.MGMT_ADMIN_DATA package has gone invalid, which is used to manage much of the repository at the command line. 3.  The repository owner password has become corrupted. These were my…