Monitoring MongoDB using Oracle Enterprise Manager Cloud Control

Scott Wardrop from AIDEV told me that they produced a plugin for Oracle Enterprise Manager Cloud Control 12c to monitor MongoDB. We use MongoDB in our production systems, so I decided to examine the plugin and write a blog post about it. Unfortunately version of our MongoDB databases are too old (2.4.x series) so the plugin didn’t work. Of course, it didn’t stop me. We created a simple MongoDB Cluster environment to test (more...)

If EMD_MAINTENANCE.DISABLE_EM_DBMS_JOBS Hangs When Deconfiguring Plug-In from Management Repository

Today, I tried to remove a plugin from Management Server but I see that undeployment process was hung at step 5:

----------------------------- ----------------------- -------------------------
Step                          Start Time              End Time                  
----------------------------- ----------------------- -------------------------
Submit job for undeployment   6/26/15 8:39:07 AM EEST 6/26/15 8:39:07 AM EEST Success

Initialize                    6/26/15 8:39:23 AM EEST 6/26/15 8:39:24 AM EEST Success

Validate plug-in home         6/26/15 8:39:25 AM EEST 6/26/15 8:39:27 AM EEST Success

Delete plug-in's metadata     6/26/15 8:39:28 AM EEST 6/26/15  (more...)

Oracle Enterprise Manager Cloud Control 12c Release 5 ( is Ready to Download

Enterprise Manager Cloud Control 12c Release 5 is avaliable to download. The new release is designed to monitor and manage both your on-premise and Oracle Cloud deployments which is called “Hybrid Cloud” by Oracle. You can deploy Management Agents onto the Oracle Cloud virtual hosts to manage Oracle Cloud targets just as you would any other targets. EM12c R5 also supports data cloning between on-premise and Oracle Cloud. Integration with Oracle Enterprise Manager Ops Center (more...)

EM12c: Metric Extensions Adapters

It’s for sure that Metric Extensions provide great flexibility to define your own metrics and enhance the monitoring abilities of Oracle Enterprise Manager Cloud Control. There are different adapters for different target types. You can see the available adapters when you pick a target at the “create new metric extension” page.


There are about 130 different target types, so I wondered if it’s possible to write a query to show available adapters for each target (more...)

Oracle Enterprise Manager EMCLI on Mac OS X

EMCLI is not certified or supported on Mac OS X, but I wondered if it is possible to run on my new macbook. I searched metalink, googled and couldn’t found any useful information. I thought it should be easy because EMCLI is a java application certified to run almost all enterprise operating systems including HP-UX, AIX, Linux, Windows, Solaris, and we all remember “write once, run everywhere” slogan of Java. Unfortunately it wasn’t as easy (more...)

Oracle Enterprise Manager EMCLI and Java 1.8

Java 1.8 is the current version and you probably use it on your personal computer. Although EMCLI says it will work on Java 1.6 and newer versions, if you install it using Java 1.8, you get an error when you try to setup or synchronize it with the Enterprise Manager Cloud Control OMS server. The reason is that Java 1.8 will use TLS 1.2 as default protocol for secure connections.


How to Recover Weblogic Administration Password of Enterprise Manager

As you may know, Weblogic is a part of Enterprise Manager Cloud Control environment, and it’s automatically installed and configured by the EM installer. The Enterprise Manager asks you to enter a username and password for Weblogic administration. This information is stored in secure files, and you usually do not need them unless you need to use Weblogic console. So it’s easy to forgot these username and password, and that’s what happened to me. Fortunately (more...)

EM12c: How to Retrieve Passwords from the Named Credentials

In my previous post, I have showed how to list all named credentials in Enterprise Manager Cloud Control. As you see, it was not possible using regular user interface, so we connected to the repository database to get the information. Now let’s keep digging and see if we can retrieve “encrypted information” saved in named credentials.

The username, password and role information of named credentials are stored in em_nc_cred_columns table. When we examine it, we (more...)

EM12c: How to View All of the Credentials Exist for All Users

In another question on OTN forum, someone says that there are multiple (EM12c) users and they can create their own credentials. They ask how to view all of the credentials that exist for all users. A valid answer is already given: An EM administrator, including sysman, cannot view the named credentials owned by other administrators unless an explicit grant is provided.


I logged in as SYSMAN to Enterprise Manager Cloud Control console and checked the (more...)

EM12c: Using Metric Extensions to Generate Composite Alerts

There was a question on OTN forums about how to generate alerts when 2 different events are triggered. The user wants to get alert if the warning threshold is over 80% “AND” there is less then 20Gb of free space. Of course, he can set different thresholds for each tablespace: He can set percentage threshold for small tablespaces and set free space threshold for bigger ones. I do not know how many databases he monitors (more...)