2. Fresh Installation of Enterprise Manger 10g Grid Control
Release 2 and upgrading it to Release 4
3. Upgrading any existing 10.2.0.X.0 Enterprise Manager Grid
Control installations to Enterprise
Manger 10g Grid Control Release 4.
4. Upgrading an existing 10.1.0.4.0 or a higher 10.1.0.X.0
Enterprise Manager Grid Control
installation to the latest Enterprise Manger 10g Grid Control Release 4
This document provides information about installing Enterprise
Manager 10g Grid Control Release for following cases:
- Doing a fresh Enterprise Manager 10g Release 2 Grid Control
installation and upgrading it to latest
Enterprise Manager 10g Release 4.
- Upgrading any existing 10.2.0.X Enterprise Manager 10g Grid
Control installations to latest
Enterprise Manager 10g Release 4.
- Upgrading an existing 10.1.0.4.0 or a higher 10.1.0.X.0
Enterprise Manager 10g Grid Control
installation to the latest Enterprise Manager 10g Release 4.
1.2.1 Download the GridControl_10.2.0.4_<platform name>.zip
patch set installation archive to any directory on the host which has the Oracle
Management Service running on.
1.2.2 Enter the following command to unzip and extract the
installation files:
$ unzip GridControl_10.2.0.4_<platform name>.zip
This will extract following files and directory:
|- p3731593_10204_<platform name>.zip
|- 3731596.zip
|- 3822442.zip
|- p4329444_10104_< platform name >.zip (will not be present for Windows)
|- p4329444_10105_< platform name >.zip (will not be present for Windows)
|- README.txt
|- doc/
*NOTE*: <platform name> will be "LINUX" or
"Win32" depending on the platform.
Refer to READEME.txt and the documents under "doc"
directory for installing 10.2.0.4.0
- p3731593_10204_<platform name>.zip is the zip that
contains 10.2.0.4.0 patch set software.
- 3731596.zip is for patching agent by staging the patch set.
Please look at the Release Notes
section 4.3.3 method 2 under the "doc" directory on how to apply the
agent 10.2.0.4.0 patch set
- 3822442.zip is for patching agent by distributing the full
patch set. Please look at the Release
Notes section 4.3.3 method 1 under the "doc" directory on how to apply
the agent 10.2.0.4.0 patch set
- p4329444_10104_< platform name >.zip is zip that contains
patch for bug 4329444 for "<platform
name>" for RDBMS version 10.1.0.4.0
- p4329444_10105_< platform name >.zip is zip that contains
patch for bug 4329444 for "<platform
name>" for RDBMS version 10.1.0.5.0
In order to install Enterprise Manager 10g Grid Control Release
4, you must install either 10.2.0.1.0 or 10.2.0.2.0 Grid Control environment.
This section describes steps to install Enterprise Manager 10g Grid Control
Release 4 environment starting with 10.2.0.1.0 (10.2.0.2.0 for Windows) install
Installing 10g Grid Control Release 4 requires any previous
releases of Grid Control, that is any 10.2.0.x.0 installation, and upgrade to
10.2.0.4.0 release. If you do not have a previous release, but want to have
a 10.2.0.4.0 Grid Control environment, then first install 10.2.0.1.0 Grid Control
(10.2.0.2.0 for Windows), and then upgrade it to 10.2.0.4.0.
The fast and recommended method is to perform a software
only installation of 10.2.0.1.0 (10.2.0.2.0 for Windows) and then upgrade it
to 10.2.0.4.0. Refer to section 3.3.5 of the Basic Installation and Configuration
Guide available at:
One can also perform the installation using Oracle Universal
Installer as described below:
+ Run runInstaller (setup.exe for Windows) to start installation
+ When asked for "install type" option, choose "Enterprise Manager
using New Database" or
"Enterprise Manager using Existing Database" option
+ Complete installation as per install guide
*Important*: For information about installing 10.2.0.1.0
and 10.2.0.2.0, refer to the installation guides available at:
2.2 Apply required patches to Oracle Enterprise Manager 10g
Release 2 before upgrade
-------------------------------------------------------------------------------------
In the case of Grid Control environment installed via "Enterprise
Manager using New Database" option, repository database version is 10.1.0.4.0.
Before upgrading to 10.2.0.4, apply the patch for bug 4329444 on the Database
Home. In order to apply this patch for the Linux platform:
- Unzip the file p4329444_10104_<platform name>.zip
from the downloaded image described in section
1.2 using following command:
$ unzip p4329444_10104_<platform name>.zip
- Follow the instruction in 4329444/README.txt to apply the
patch to repository database
For Windows platform bug 4329444 might be encountered in
rare cases. Upgrade to Grid Control 10.2.0.4 can be proceeded without this patch.
For more detail on this and for other platforms, refer to
the release note.
- Enter the following command to unzip and extract the installation
files from the downloaded image
described in section 1.2:
$ unzip p3731593_10204_<platform name>.zip
This extracts the files to the "3731593" directory.
- Navigate to the 3731593/Disk1 subdirectory
$ cd 3731593/Disk1
- Set the ORACLE_HOME variable to the Oracle Management Service(OMS)
oracle home.
- Execute the runInstaller (setup.exe for Windows)
$ ./runInstaller
For detailed instructions refer to section 3.2 of the Release
notes under the "doc" directory.
The upgrades process then upgrades the Oracle Management Service (OMS), Oracle
Management Repository and the Management Agent on the same host as the OMS to
the latest Enterprise Manager 10g release 4 version.
*Important*: The same Patch Set can be used for patching OMS,Repository,
and Management Agent. For more detail on installing the patch set, refer to
the release note.
2.4 Optional: Upgrading Repository Database to 10.2.0.4
--------------------------------------------------------
If you installed Grid Control 10.2.0.1.0 (10.2.0.2.0 for Windows)
via "Enterprise Manager using New Database" option, your repository
database version is 10.1.0.4. In order to upgrade your repository database to
10.2.0.4, follow the steps below after upgrading your Grid Control environment
to Enterprise Manager 10g release 4.
Follow the steps below to upgrade an existing 10.2.0.1.0 or
10.2.0.2.0 Enterprise Manager Grid Control installation:
3.1 Roll-back patch 5191377 if it has been applied to the
Oracle Management Service (OMS)
------------------------------------------------------------------------------------------
- To check if this patch had been applied to the Oracle Management
Service (OMS)
a) Set the ORACLE_HOME environment variable to your OMS home
b) Change directory to $<OMS_HOME>/Opatch
$ cd <OMS_HOME>/OPatch
c) Execute following command:
$./opatch lsinv
d) Check the output to see if patch for this bug is applied.
- Rollback the one-off patch 5191377
a) Set your current directory to the directory where the patch
is located
$ cd 5191377
b) Run the following command:
$ opatch rollback -id 5191377
- Login as Repository Owner and execute the following command,
against SQL prompt
SQL>drop index mgmt_current_violation_idx_05;
3.2 Apply patches if required to existing installation before
upgrade
----------------------------------------------------------------------
If Grid Control repository database is DB version 10.1.0.4.0
or 10.1.0.5.0, before upgrading to EM 10204, apply the patch for bug 4329444
on the Database Home.
In order to apply this patch for the Linux platform:
- Copy the p4329444_<version>_<platform name>.zip
file from the DVD to any directory on the host
which has the repository database running on.
- Unzip the file using following command:
$ unzip p4329444_<version>_<platform name>.zip
- Follow the instruction in 4329444/README.txt to apply the
patch
For Windows platform bug 4329444 might be encountered in rare
cases. Upgrade to Grid Control 10.2.0.4 can be proceeded without this patch.
For more detail on this and for other platforms, refer to
the release note.
3.3 Executing required SQLs against repository
----------------------------------------------------------------------
If you are using the corrective actions feature in your existing
10.2.0.X.0 deployment, then you may run into a schema inconsistency which can
cause an upgrade to fail (bug 5855008). If you are using corrective actions,
then execute the following PL/SQL block in the Enterprise Manager repository
using sqlplus (connected as SYSMAN), BEFORE doing the upgrade, in order to clean
up the inconsistent data.
BEGIN
FOR r IN (SELECT job_id
FROM mgmt_corrective_action a
WHERE NOT EXISTS
(SELECT 1
FROM mgmt_job j
WHERE j.job_id = a.job_id)
) LOOP
UPDATE mgmt_policy_assoc_cfg c
SET crit_action_job_id = NULL
WHERE crit_action_job_id = r.job_id
;
UPDATE mgmt_policy_assoc_cfg c
SET warn_action_job_id = NULL
WHERE warn_action_job_id = r.job_id
;
UPDATE mgmt_policy_assoc_cfg c
SET info_action_job_id = NULL
WHERE info_action_job_id = r.job_id
;
DELETE
FROM mgmt_corrective_action
WHERE job_id = r.job_id
;
COMMIT;
END LOOP;
COMMIT;
END;
/
4. Upgrading an existing 10.1.0.4.0 or a higher 10.1.0.X.0
Enterprise Manager Grid Control installation to the latest Enterprise Manger
10g Grid Control Release 4
4.1 Upgrade the existing 10.1.0.4.0 or higher 10.1.0.x.0 installation
to Enterprise Manager Grid Control version 10.2.0.1.0 (10.2.0.2.0 for Windows)
-------------------------------------------------------------------------------------------------
To accomplish this, refer to chapter "Upgrading Enterprise
Manager Grid Control" of the Enterprise Manager Grid Control Installation
and Basic Configuration guide available at: