Friday, June 22, 2007

10gGrid v10.2.0.1.0 : Upgrading to Release 3 on Oracle Enterprise Linux

Upgrading the Existing 10.2.0.1.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3

Requirement : Running 10g Grid v10.2.0.X. In my case the version is 10.2.0.1.0

Software Requirement for Upgrade:
Download GridControl_10.2.0.3_Linux.zip
URL: http://www.oracle.com/technology/software/products/oem/index.html

Step by Step Instructions for Upgrading

[root@managementserver 10..3]# unzip GridControl_10.2.0.3_Linux.zip
Archive: GridControl_10.2.0.3_Linux.zip
extracting: 3731596.zip
extracting: 3822442.zip
creating: doc/
inflating: doc/BugList_EMGC_10.2.0.3.pdf
inflating: doc/BugList_EMGC_10.2.0.3.html
inflating: doc/ReleaseNotes_EMGC_10.2.0.3.html
inflating: doc/ReleaseNotes_EMGC_10.2.0.3.pdf
extracting: p3731593_10203_linux.zip
extracting: p4329444_10104_LINUX.zip
extracting: p4329444_10105_LINUX.zip
inflating: README.txt
[root@managementserver 10..3]# cat README.txt
Table of Contents
1.General
2.Fresh Installation of Enterprise Manger 10g Grid Control Release 2 and upgrading it to Release 3
3.Upgrading any existing 10.2.0.X.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3.
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 3


Here I will be doing an upgrade to R3 from 10.2.0.1.0 with option 3 on the Readme
To know the current version access the aboutApplication URL

http://managementserver.grid.com:4889/em/console/aboutApplication
Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.0

em_grid_102010_version:

Upgrading any existing 10.2.0.X.0 Enterprise Manager Grid Control installations to Enterprise Manger 10g Grid Control Release 3.

3.1 Roll-back patch 5191377 if it has been applied to the Oracle Management Service (OMS)
Not executing Step 3.1 as in my case the inventory does not have 5191377

[orgrid@managementserver ~]$ export ORACLE_HOME=/home/orgrid/oms10g
[orgrid@managementserver ~]$ cd $ORACLE_HOME/OPatch
[orgrid@managementserver OPatch]$
[orgrid@managementserver OPatch]$ ./opatch lsinv | grep -i 5191377
[orgrid@managementserver OPatch]$
SQL> select 1 from dba_indexes where index_name=upper('mgmt_current_violation_idx_05');

no rows selected

SQL>

3.2 Apply patches if required
In the case of Grid Control environment installed via "Enterprise Manager using New Database" option or "Enterprise Manager using an existing Database " option with 10.1.0.4 or 10.1.0.5 Database, apply the patch for bug 4329444 on the Database Home. In order to apply this patch for the Linux platform:

In my case it was done using the option "Enterprise Manager using New Database"


[orgrid@managementserver 10..3]$ ls -rlt *4329444*
-rw-r--r-- 1 root root 70783 Jan 31 21:34 p4329444_10105_LINUX.zip
-rw-r--r-- 1 root root 70431 Jan 31 21:34 p4329444_10104_LINUX.zip
[orgrid@managementserver 10..3]$

Database version is 10.1.0.4.0

[root@managementserver 10..3]# unzip p4329444_10104_LINUX.zip
Archive: p4329444_10104_LINUX.zip
creating: 4329444/
creating: 4329444/files/
creating: 4329444/files/lib/
creating: 4329444/files/lib/libserver10.a/
inflating: 4329444/files/lib/libserver10.a/qerix.o
creating: 4329444/etc/
creating: 4329444/etc/config/
inflating: 4329444/etc/config/inventory
inflating: 4329444/etc/config/actions
creating: 4329444/etc/xml/
inflating: 4329444/etc/xml/GenericActions.xml
inflating: 4329444/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 4329444/README.txt
[root@managementserver 10..3]#

[orgrid@managementserver ~]$ export ORACLE_HOME=/home/orgrid/db10g
[orgrid@managementserver ~]$ export ORACLE_SID=emrep
[orgrid@managementserver ~]$ cd /stage/Grid/10..3/4329444/
[orgrid@managementserver 4329444]$

Before proceeding with the Patching SHUTDOWN Services
$OMS_ORACLE_HOME/opmn/bin/opmnctl stopall
$EMAGENT_ORACLE_HOME/bin/emctl stop agent
Shutdown Database and Listener

[orgrid@managementserver 4329444]$ opatch apply
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..


Oracle Home : /home/orgrid/db10g
Central Inventory : /home/orgrid/oraInventory
from : /home/orgrid/db10g/oraInst.loc
OPatch version : 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location : /home/orgrid/db10g/oui
Log file location :
/home/orgrid/db10g/cfgtoollogs/opatch/opatch-2007_Apr_21_10-01-38-IST_Sat.log


ApplySession applying interim patch '4329444' to OH '/home/orgrid/db10g'
Invoking fuser to check for active processes.
Invoking fuser on "/home/orgrid/db10g/bin/oracle"
OPatch finds following executables active:
/home/orgrid/db10g/bin/oracle
Before you proceed, stop all active processes. Press when ready.
Do you want to proceed? [y|n]
y
User Responded with: Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/home/orgrid/db10g')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4329444' for restore. This might take a while...
Backing up files affected by the patch '4329444' for rollback. This might take a while...

Patching component oracle.rdbms, 10.1.0.4.0...
Updating archive file "/home/orgrid/db10g/lib/libserver10.a" with "lib/libserver10.a/qerix.o"
Running make for target ioracle
ApplySession adding interim patch '4329444' to inventory

The local system has been patched and can be restarted.
OPatch succeeded.
[orgrid@managementserver 4329444]$

3.3 Install Oracle Enterprise Manager 10g Release 3
Follow step 2.3 above.

2.3 Install Oracle Enterprise Manager 10g Release 3

2.3.1 Copy the p3731593_102030_.zip patch set installation archive from the DVD to any directory on the host which has the Oracle Management Service running on it.

2.3.2 Perform the installation
- Enter the following command to unzip and extract the installation files from the downloaded image described in section 1.2:
$ unzip p3731593_102030_.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
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 3 version.
Important: The same Patch Set can be used for patching OMS,Repository, and Management Agent. For more detail on installing the patchset, refer to the release note.

[root@managementserver 10..3]# ls -lrt *3731593*
-rw-r--r-- 1 root root 554291128 Feb 1 15:45 p3731593_10203_linux.zip
[root@managementserver 10..3]#

[root@managementserver 10..3]# unzip p3731593_10203_linux.zip

- 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

10g_grid_upgrade_all:

[orgrid@managementserver~]$ emctl getversion
Oracle Enterprise Manager 10g Release 3 Grid Control
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enterprise Manager 10g OMS Version 10.2.0.3.0
Enterprise Manager 10g AS Control Version 10.2.0.0
Enterprise Manager 10g Agent Version 10.2.0.3.0
[orgrid@managementserver~]$

Summary : Installed 10g Grid Release 2 and Upgraded to Release 3 on Oracle Enterprise Linux

Popular Posts