Recently I’ve been combating a high water mark enqueue wait (enq: HW – contention) on a single node within an Exadata I’m supporting. I first noticed the wait when I was looking at the performance page for the node in Oracle Enterprise Manager 12c. What I noticed was the a lot of brown looking spikes (Image 1). These spikes correspond to a Configuration wait.
When I clicked on Configuration in (more...)
Oracle Enterprise Manager 12c is a great monitoring tool for the enterprise, I think I’ve said that more than once over the last two years; however, with every release small yet simple things change. It is always the small things that will get you. I had setup monitoring for a client using monitoring templates within OEM12c; everything was being monitored, so I thought! I got a call from my client asking why (more...)
Ever have one of those days when someone calls and says “We/I accidently deleted the whole directory; can you get it back for me”? Well, over the weekend I had that happen with an OEM 12c agent on an Exadata, where the core directory for the agent was deleted by mistake. Before I could evaluate the situation, I had to reassure the end user that the removal of the core directory under the (more...)
From time to time, when working at various sites I have to check connections to a database. If you have been an Oracle DBA for some time, you already know that the listener has to be up and services have to be registered before you can connect from a remote host. If the listener is up and services are registered, then you should be able to get to the database; so why the (more...)
Recently, I have had conversations with users about Oracle Database 12c. One question that often comes up is, how does the database manage the parameters between a container database (CDB) and a pluggable database (PDB)? In order to answer this question, I had to work with my pluggable database setup in a test environment. Before changing anything within my database setup I first made a backup of the current parameters using a (more...)
Let the conference season begin!
I will be presenting at RMOUG Training Days 2014 this month in Denver, CO. The presentation that I will be presenting is a revised version of my OOW 2014 presentation on Oracle Enterprise Manager 12c, Database 12c and You! This presentation will cover a few basics of Database 12c and how Oracle Enterprise Manager 12c can be used to monitor a Database 12c environment.
Being that this (more...)
Thought I would write a quite tip on how to find what versions of databases you have in your environment. Oracle Enterprise Manager 12c provides a quick and easy way to find this information once it is configured within your environment.
Starting at with the Enterprise menu, you will go to Configuration and then Inventory and Usage Details (Enterprise –> Configuration – Inventory and Usage Details) (Figure 1).
Figure 1: Inventory and Usage (more...)
When adding an Exadata to Oracle Enterprise Manager 12c (OEM), it is pretty easy yet at times you may run into a problem or two. Many of these problems can be minimized by using the Oracle Enterprise Manager 12c: Exadata Discovery Cookbook (cookbook). The cookbook can be found here, so you don’t have to search to far for it.
As with adding any target in OEM, you add the Exadata the same (more...)
Warning: This one may be longer than normal
How many times have you ran an exachk, produced the text file, and then had to either read the file on the compute node or copy it to your local machine? Well there is another way to view the report of the EXACHK; it can even be ran on a timely basis so you have current EXACHK information on a regular basis. What I’m talking (more...)
In a recent post on monitoring Oracle GoldenGate, I talked about how to configure the JAGENT to use Oracle Enterprise Manager 12c to monitor Oracle GoldenGate. If you would like to review that post, you can find it here. For this post, I’ll show you how you can use Metric Extensions within Oracle Enterprise Manager 12c to monitor Oracle GoldenGate.
Note: Another good post on this topic can be found from my (more...)
In order to upgrade out OEM environment from 22.214.171.124 to 126.96.36.199 we need to download the latest version of OEM from either http://otn.oracle.com or from http://edelivery.oracle.com. Once we have the files needed to upgrade, we need to stage them in (more…)