Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Upgrade Oracle Enterprise Manager Cloud Control 12c Release 3 (12cR3) to Release 4 (12cR4)

This article describes a simple upgrade of Enterprise Manager Cloud Control 12c Release 3 (12cR3) to Release 4 (12cR4). Each upgrade potentially requires additional steps, so this is not meant as a replacement for reading the documentation.

Related articles.

Software

Download the following software:

Additional patches are required for some versions of the database. See here.

Cloud Control 12c Installation and Upgrade

For clarity, my starting 12cR3 installation had the following details.

HOSTNAME  : ol6-em12cr3.localdomain
DB Version: 11.2.0.3 Patched to 11.2.0.4 during this process.
ORACLE_SID: DB11G
PORT      : 1521
URL       : https://ol6-em12cr3.localdomain:7803/em

There are specific patches for different versions of the database prior to 11.2.0.4, as described here. I took the opportunity to patch to 11.2.0.4. and the latest SPU before starting the upgrade.

Make sure the privileges for the DBMS_RANDOM package are as described in the documentation.

export ORACLE_SID=DB11G
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

sqlplus / as sysdba

GRANT EXECUTE ON dbms_random TO dbsnmp; 
GRANT EXECUTE ON dbms_random TO sysman;
REVOKE EXECUTE ON dbms_random FROM public;

Make sure there are no invalid objects in the repository database.

SELECT owner, object_name, object_type
FROM   dba_objects 
WHERE  status = 'INVALID'
AND    owner IN ('SYS', 'SYSTEM', 'SYSMAN', 'MGMT_VIEW', 'DBSNMP', 'SYSMAN_MDS');

In my case, there were several invalid objects, so they were recompiled using the following commands.

EXEC UTL_RECOMP.recomp_serial('SYS');
EXEC UTL_RECOMP.recomp_serial('DBSNMP');
EXEC UTL_RECOMP.recomp_serial('SYSMAN');

Edit the "/etc/security/limits.conf" file, increasing the following entry to 4096 if it is less than that. You will need to reboot after this.

oracle   soft   nofile    4096

Backup your repository. In my case, Cloud Control runs on a VM, so a database backup was performed, as well as a whole VM backup.

Copy the emkey using the following commands, adjust as required. You will have to enter the WebLogic console admin and sysman passwords.

export OMS_HOME=/u01/app/oracle/oms12cr3/oms

$OMS_HOME/bin/emctl config emkey -copy_to_repos_from_file \
  -repos_host ol6-em12cr3.localdomain -repos_port 1521 -repos_sid DB11G \
  -repos_user sysman -emkey_file $OMS_HOME/sysman/config/emkey.ora

Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Enter Admin User's Password : 
Enter Enterprise Manager Root (SYSMAN) 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".
$

Stop the OMS.

$OMS_HOME/bin/emctl stop oms -all

Create a directory for the new installation.

$ mkdir -p /u01/app/oracle/oms12cr4

Unzip the 12cR4 software.

$ mkdir em12cr4
$ unzip -d em12cr4 em12104_linux64_disk1.zip
$ unzip -d em12cr4 em12104_linux64_disk2.zip
$ unzip -d em12cr4 em12104_linux64_disk3.zip
$ cd em12cr4

Run the installer.

$ ./runInstaller

If you wish to receive support information, enter the required details, or uncheck the security updates checkbox and click the "Next" button. Click the "Yes" button the subsequent warning dialog.

My Oracle Support Details

If you wish to check for updates, enter the required details, or check the "Skip" option and click the "Next" button.

Software Updates

If you have performed the prerequisites as described, the installation should pass all prerequisite checks. Click the "Next" button.

Prerequisite Checks

Select the "Upgrade an existing Enterprise Manager System" option. Select the "One System Upgrade" option. Select the OMS to be upgraded, then click the "Next" button.

Install Types

Enter the new middleware home locations, then click the "Next" button.

Installation Details

Enter the database connection details and confirm the repository has been backed up, then click the "Next" button.

Database Connection Details

On the first warning dialog, click the "Yes" button.

Repository Warning 1

If you have any additional warnings, check they don't look like show-stoppers, then click the "OK" button to continue.

If you are happy with the plug-in upgrade information, click the "Next" button.

Plugin Upgrade

Select any additional plug-ins you want to deploy, then click the "Next" button.

Select Plugin

Enter the WebLogic details, then click the "Next" button.

Extend WebLogic Server Domain

If you are happy with the review information, click the "Install" button.

Review

Wait while the installation and configuration take place.

Installation Progress Details

When prompted, run the root scripts, then click the "OK" button.

Root Scripts

Make note of the URLs, then click the "Close" button to exit the installer. A copy of this information is available in the "/u01/app/oracle/oms12cr3/oms/install/setupinfo.txt" file.

Finish

The login screen is available from a browser using the URL provided in the previous screen ("https://ol6-em12cr3.localdomain:7803/em"). Log in with the username "sysman" and the password you specified during your installation.

Login

Once logged in, you are presented with a with the "Accessibility Preference" screen. Click the "Save and Continue" button and you are presented with the startup screen you selected when the installed 12cR3.

Console

Agent Upgrade

Navigate to "Setup > Manage Cloud Control > Upgrade Agents".

Upgrade Agents

Click the "+ Add" button, highlight any agents to upgrade, then click the "OK" button.

Select Agents

When you are happy with your selection, click the "Submit" button.

Upgrade Agents

If you do not have "root" access or sudo configured to allow you to run the root scripts, click the OK on the warning message. The root scripts can be run after the installation completes.

Agent Upgrade Notifications

Wait while the upgrade takes place. Once complete, click the "Done" button.

Agent Upgrade Status

If you need to run any root scripts manually, do so now. They are located in the agent home on each monitored machines (AGENT_HOME/core/12.1.0.4.0/root.sh).

The upgrade is not complete.

Startup/Shutdown

Use the following commands to turn on all components installed by this article. If you have a startup/shutdown script, remember to amend it to take account of the new paths.

#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
export OMS_HOME=/u01/app/oracle/oms12cr4/oms
export AGENT_HOME=/u01/app/oracle/agent12cr4/core/12.1.0.4.0

# Start everything
$ORACLE_HOME/bin/dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

Use the following commands to turn off all components installed by this article.

#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
export OMS_HOME=/u01/app/oracle/oms12cr4/oms
export AGENT_HOME=/u01/app/oracle/agent12cr4/core/12.1.0.4.0

# Stop everything
$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

$ORACLE_HOME/bin/dbshut $ORACLE_HOME

For more information see:

Hope this helps. Regards Tim...

Back to the Top.