Blog - comments

Hi Stephane,

In fact at dbi services we have professional material ;-)

Samsung SSD 840 PRO Series

Gregory Steulet

I have a write throughput 10x lower than your test (is it the SSD?)

stephane (ebu)
You obtained :Running the test with following options: Number of threads: 64 Random number generator...
stephane (ebu)

I wrote a benchmark based on your own. I'm so far from your result (which is very good for a laptop)

stephane (ebu)
Hi Stephane,It depends, you can find the stats for MySQL 5.6 below:sysbench 0.5: multi-threaded sys...
Gregory Steulet
Blog Pierre Sicot Migrating to Oracle OEM Cloud Control

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.

Migrating to Oracle OEM Cloud Control

I recently upgraded from Enterprise Manager Cloud Control to the most recent version This document describes the migration procedure and the different problems encountered.

The first point to know when you are about to upgrade an existing Enterprise Manager Cloud Control 12c is that Oracle Installer will create a new Middleware home. Thus, you will need to have enough free disk space (around 7 GB) on your system to be able to upgrade correctly.

The upgrade procedure is easy to run, and as the Cloud has already been installed, you won’t get any problem of failed pre-requisite checks.

I choose to upgrade an existing Enterprise Manager System with one system:




The next screen is asking for the new Middleware home:




After asking for the sys and sysman passwords, it is necessary to stop the Oracle Management Server with the command emctl stop oms - do not use the option –all.

You do not have to stop the repository database and the listener.

The only problem encountered during the upgrade was about the emkey which should be present in the upgraded environment.




To solve this problem you need to run the command:


oracle@server1:/u00/app/oracle/Middleware/oms/bin/ [oms12c] ./emctl config emkey -copy_to_repos_from_file -repos_host server1 -repos_port 1521 -repos_sid EMREP12C -repos_user sysman -repos_pwd manager -emkey_file /u00/app/oracle/Middleware/oms/sysman/config/emkey.oraOracle Enterprise Manager Cloud Control 12c Release (c) 1996, 2012 Oracle Corporation. All rights reserved.Enter Admin User's Password :The EMKey has been copied to the Management Repository. This operation will cause the EMKey to become unsecure.After the required operation has been completed, secure the EMKey by running "emctl config emkey -remove_from_repos".


Finally the upgrade to Enterprise Manager Cloud runs successfully in less than an hour.

The next step consists to upgrade the management agents. This operation is made from the Cloud console by using the Setup Menu, Manage Cloud Control, Upgrade Agents:




You have to select the different management agents you need to migrate to the release. By using the Control key you can select all the remote agents and run the upgrade on all the agents.

For the agent migration itself I experienced some problems. All the remote agents were installed on the same operating system (Linux x86_64), but for only one, the Oracle procedure ran in a recursive loop and created a lot of backup directories which led to a full file system. I chose to uninstall the agent and to reinstall it with the procedure, but I also could have used the Cloud 12c console. More precisely, if you have your agent in release with the AGENT_HOME as /u00/app/oracle/agent12c/core/, the upgrade procedure will install in /u00/app/oracle/agent12c/core/

The management agent on the OMS side is upgraded in the old Middleware home. For example, after the first installation of Oracle Enterprise Manager the management agent is installed under /u00/app/oracle/Middleware/agent by default. When you upgrade this management agent, it will be upgraded in the same directory. You cannot choose the new directory where it will be installed. If you forget about this particular case, think your migration is finished, and delete the old Middleware home, you will delete the management agent!!!

The only way I found to bypass this problem is to uninstall the management agent on the OMS side and to reinstall it with the Cloud 12c console or via the

If you want to deinstall the management agent via the Enterprise Manager Cloud Control 12c console, you have to delete the targets associated to this agent before deleting the agent. The deletion of the targets sometimes does not work very fine, but you can use emcli to delete the targets and the agent in the following way:


oracle@vmtestoraem12c:/u01/app/oracle/Middleware_R2/oms/bin/ [oms12c] emcli delete_target -name="" -type="oracle_emd"Error: This agent is currently monitoring other targets. Please delete the monitored targets before deleting the agent or use delete_monitored_targets option to delete all the monitored targetsoracle@vmtestoraem12c:/u01/app/oracle/Middleware_R2/oms/bin/ [oms12c] emcli delete_target -name="" -type="oracle_emd" -delete_monitored_targetsTarget "" deleted successfully


My last recommendation is to install the management agent outside of the Middleware home (for example /u00/app/oracle/agent12c) in case of a future upgrade to …

Just a few days after the migration, I observed the newly upgraded agent in was in pending state and did not administer the targets anymore. By looking at the Agent Process Statistics I noticed an increase in the number of open files since the migration:




After some research, I found the Metalink Note 1472085.1, which describes the problem about the agent stopping intermittently the monitoring with the agent version. We can see a significant message in the agent log files:


Agent has stopped monitoring, the following errors are reported: Too Many Open Files.


The patch 6895422 is available on Metalink, but before downloading the patch it is necessary to download the correct version of the patch. We have to select the patch release matching the “Oracle JDBC/OCI Instant Client” release in the AGENT_HOME.


To get the current version you run the command:


Opatch lsinventory –details


An Opatch output for example:


[---]Oracle JDBC/OCI Instant Clkient                     [---]


In this last example, you need to download the patch 6895422 release and install it with the classical opatch apply command after the agent has been stopped.

This patch is working correctly for the agent release. After a few days the number of open files gets stabilized around 200 with almost 90 targets monitored by the agent itself.





The Enterprise Manager Cloud 12c upgrade to is recommended, but you have to be particularly careful with the management agents and the generated bugs.

Rate this blog entry:

Pierre Sicot is Senior Consultant at dbi services. He has more than fifteen years of experience in Oracle database administration, engineering, and optimization. His specialty is the installation, migration, optimization, and security of Oracle databases in production environments. Prior to joining dbi services, Pierre was consultant at Trivadis in Lausanne. He also worked at ilem Group as a database administrator and also as a Consultant for different customers. Pierre holds a engineering diploma of ESME Sudria in France. His branch-related experience covers Energy, Banking, Public Administration, etc.


  • Guest
    Seth with Firebox Friday, 12 April 2013

    Thanks a lot Pierre. This covers everything that would be necessary to upgrade the Enterprise Manager Cloud Control.

Leave your comment

Guest Sunday, 02 August 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter