Blog - comments

Hi Olivier,DELAYED_DURABILITY doesn't change the SQL Server behavior of opening the data and log fil...
Hi David,Thanks for this demo with write functions. As much I know, SQL Server always access files (...
Olivier Berthommé
Thank you for your feedback. I will build a test environment and realize a guide to deploy Grid Infr...

Hi Greg,

Thanks

great job Dave ! thanks

greg
Blog Pierre Sicot Migrating to Oracle OEM Cloud Control 12.1.0.2.0

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 12.1.0.2.0

I recently upgraded from Enterprise Manager Cloud Control 12.1.0.1.0 to the most recent version 12.1.0.2.0. 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 12.1.0.1.0 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:

 

blog1

 

The next screen is asking for the new Middleware home:

 

blog2

 

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.

 

blog3

 

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 12.1.0.1.0Copyright (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 12.1.0.2.0 runs successfully in less than an hour.

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

 

blog4

 

You have to select the different management agents you need to migrate to the 12.1.0.2.0 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 12.1.0.1.0 agent and to reinstall it with the agentDeploy.sh procedure, but I also could have used the Cloud 12c console. More precisely, if you have your agent in release 12.1.0.1 with the AGENT_HOME as /u00/app/oracle/agent12c/core/12.1.0.1.0, the upgrade procedure will install in /u00/app/oracle/agent12c/core/12.1.0.2.0

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 deploy.sh.

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="vmtestoraem12c.it.dbi-services.com:3872" -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="vmtestoraem12c.it.dbi-services.com:3872" -type="oracle_emd" -delete_monitored_targetsTarget "vmtestoraem12c.it.dbi-services.com:3872:oracle_emd" 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 12.2.0.2.0 …

Just a few days after the migration, I observed the newly upgraded agent in 12.1.0.2.0 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:

 

blog5

 

After some research, I found the Metalink Note 1472085.1, which describes the problem about the agent stopping intermittently the monitoring with the 12.1.0.1.0 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                               11.1.0.7.0[---]

 

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

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

 

blog6

 

Conclusion

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

Rate this blog entry:
1

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.

Comments

  • 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 Thursday, 02 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

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