Home » , , , » Applying OEM Grid Control Patchset 10.2.0.5

Applying OEM Grid Control Patchset 10.2.0.5

Written By Srikrishna Murthy Annam on Wednesday, May 25, 2011 | 6:02 AM

In this article, i will show you how to apply patchset 10.2.0.5 to Oracle Enterprise Manager (OEM) 10.2.0.1. In the present article,we assume that there is already OEM 10.2.0.1 installed on Linux 5. There is no full installation of OEM 10.2.0.5 and all we need to do is install OEM 10.2.0.1 and apply the patchset 10.2.0.5.

Please download the required software from the location : Software Download
Please download the upgrade document from the location : Document Download
  1. Pre-Upgrade Tasks
  2. Upgrading from 10201 to 10205 ( With Video Demo)
  3. Post Upgrade Tasks
1.Pre-Upgrade Tasks:
Version Check Before Upgrade :
SQL> select name,user from v$database;
NAME      USER
--------- ------------------------------
EMREP     SYS
SQL> select comp_name,version,status from dba_registry;
COMP_NAME                           VERSION         STATUS
----------------------------------- --------------- ----------
Oracle Database Catalog Views       10.1.0.4.0      VALID
Oracle Database Packages and Types  10.1.0.4.0      VALID
Oracle Workspace Manager            10.1.0.2.0      VALID
SQL> select component_name,version from sysman.mgmt_versions;
COMPONENT_NAME                   VERSION
-------------------------------- ---------------
CORE                             10.2.0.1.0
DB                               10.2.0.1.0
PP                               10.2.0.1.0
IAS                              10.2.0.1.0
SSO_SERVER                       10.2.0.1.0
BC4J                             10.2.0.1.0
FORMS                            10.2.0.1.0
WIRELESS                         10.2.0.1.0
OCS                              10.2.0.1.0
WORKFLOW                         10.2.0.1.0
PORTAL                           10.2.0.1.0
INTEGRATIONBPM                   10.2.0.1.0
INTEGRATIONBAM                   10.2.0.1.0
DISCOVERER                       10.2.0.1.0
IFS                              10.2.0.1.0
REPSERV                          10.2.0.1.0
INTEGIC                          10.2.0.1.0
INTEGB2B                         10.2.0.1.0
CI                               10.2.0.1.0
19 rows selected.
SQL>

Status Check:
[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/oms10g/bin
[oracle@oemmach01 bin]$ ./emctl status oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle Management Server is Up.
[oracle@oemmach01 bin]$ ./emctl status iasconsole
Oracle Enterprise Manager 10g Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle 10g Application Server Control is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/oem/oms10g/sysman/log
[oracle@oemmach01 bin]$
[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/oms10g/opmn/bin
[oracle@oemmach01 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.oemmach01.localdomain
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status
-------------------+--------------------+---------+---------
DSA                | DSA                |     N/A | Down
HTTP_Server        | HTTP_Server        |    2260 | Alive
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |   10843 | Alive
OC4J               | home               |    2262 | Alive
OC4J               | OC4J_EMPROV        |    2261 | Alive
OC4J               | OC4J_EM            |    2264 | Alive
WebCache           | WebCache           |    2272 | Alive
WebCache           | WebCacheAdmin      |    2265 | Alive
[oracle@oemmach01 bin]$ pwd
/u01/app/oracle/oem/agent10g/bin
[oracle@oemmach01 bin]$ ./emctl status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.1.0
OMS Version       : 10.2.0.1.0
Protocol Version  : 10.2.0.0.0
Agent Home        : /u01/app/oracle/oem/agent10g
Agent binaries    : /u01/app/oracle/oem/agent10g
Agent Process ID  : 3294
Parent Process ID : 3276
Agent URL         : https://oemmach01.localdomain:3872/emd/main/
Repository URL    : https://oemmach01.localdomain:1159/em/upload
Started at        : 2011-04-18 21:37:55
Started by user   : oracle
Last Reload       : 2011-04-18 21:43:15
Last successful upload                       : 2011-04-18 22:33:49
Total Megabytes of XML files uploaded so far :     5.50
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    43.08%
Last successful heartbeat to OMS             : 2011-04-18 22:34:20
---------------------------------------------------------------
Agent is Running and Ready
[oracle@oemmach01 bin]$

Perform Backup:
Backup OMS oracle home ( you can use tar -cvzf <OMS oracle home> to backup the OMS oracle home )
Backup Repository database ( This is database backup. Use your convinient way to backup the database)
Backup the Oracle Inventory Directory.

Verify SGA:
Verify that the Shared pool size of the repository database is set to a min value of 512MB.
SQL> show parameter pool

Other Checks
SQL> sho user
USER is "SYSMAN"
SQL> set timing on
SQL> exec emd_maintenance.analyze_emd_schema('SYSMAN');
PL/SQL procedure successfully completed.
Elapsed: 00:00:04.18
SQL> select object_name, object_type from all_objects where owner='SYSMAN' and status <> 'VALID';
no rows selected
SQL>
The above query should return 0 rows. If there are rows, then run the below SQL statement:
[oracle@oemmach01 bin]$ locate admin_recompile_invalid.sql
/u01/app/oracle/oem/oms10g/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql
[oracle@oemmach01 bin]$
SQL> @admin_recompile_invalid.sql SYSMAN
The admin_recompile_invalid.sql script is available under /sysman/admin/emdrep/sql/core/latest/admin/ Where is the Oracle home directory of the Oracle Management Service (OMS).
SQL> select object_name, object_type from all_objects where status<>'VALID' and object_name like 'DBMS%';
no rows selected
SQL>

Verify The Permission:
If the permission is not set to 664 for the below files, you will get a permission denied error during the upgrade. For example:
Error in writing to file
'/u01/app/oracle/product/10.2.0/oms10g/rdbms/admin/dbmsaw.plb' Permission denied
[oracle@oemmach01 askm]$ locate dbmsaqds.plb  dbmsaw.plb  prvtlmd.plb  prvtpexp.plb  prvtlsby.plb  prvtlms.plb  prvtaqip.plb  prvtstas.plb  prvtsqlt.plb  prvttxfm.plb  prvtaqdi.plb  prvtaqds.plb  prvtcdpu.plb  prvtcdpi.plb  prvtmeti.plb  prvtxdbz.plb  exfeapvs.plb  prvtdupg.plb  prvtupgi.plb  prvtkupc.plb  prvtbpw.plb  prvtaqiu.plb  prvtaqim.plb  prvtbsqu.plb  prvtbut4.plb  prvtmetu.plb  prvtmeta.plb  prvtcdcp.plb  prvtcdcu.plb  >> filelist
[oracle@oemmach01 askm]$ cat filelist
/u01/app/oracle/oem/db10g/rdbms/admin/dbmsaqds.plb
/u01/app/oracle/oem/db10g/rdbms/admin/dbmsaw.plb
....
.....
/u01/app/oracle/oem/oms10g/rdbms/admin/prvtxdbz.plb
[oracle@oemmach01 askm]$
[oracle@oemmach01 askm]$ for i in `cat filelist`; do chmod 644  $i; done
[oracle@oemmach01 askm]$ for i in `cat filelist`; do ls -lrt $i; done
-rw-r--r-- 1 oracle oracle 5697 Feb 21  2005 /u01/app/oracle/oem/db10g/rdbms/admin/dbmsaqds.plb
-rw-r--r-- 1 oracle oracle 10558 Feb 12  2005 /u01/app/oracle/oem/db10g/rdbms/admin/dbmsaw.plb
......
......
-rw-r--r-- 1 oracle oracle 6818 Jul 14  2005 /u01/app/oracle/oem/oms10g/rdbms/admin/prvtxdbz.plb
[oracle@oemmach01 askm]$
SQL> sho user
USER is "SYSMAN"
SQL> execute emd_maintenance.remove_em_dbms_jobs;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> select a.instance_name as sid, b.value as jobqueue from gv$instance a, gv$parameter b where a.inst_id = b.inst_id and b.name='job_queue_processes';
no rows selected
SQL> select count(*) from dba_jobs_running;
COUNT(*)
----------
0
SQL>
SQL> exec dbms_scheduler.set_scheduler_attribute ('SCHEDULER_DISABLED','TRUE');
PL/SQL procedure successfully completed.
SQL> select count(*) from dba_scheduler_running_jobs where SLAVE_PROCESS_ID IS NOT NULL;
COUNT(*)
----------
0
SQL>
2.Upgrading from 10201 to 10205

Unzip the software to any temporary directory and follow the below video to upgrade OEM from 10201 to 10205.

NOTE: This will upgrade only OMS ORACLE_HOME and Agent ORACLE_HOME and will not upgrade the repository database. To upgrade the repository database,we will follow the normal procedure to upgrade a database.


3. Post Upgrade Tasks:
SQL> exec dbms_scheduler.set_scheduler_attribute ('SCHEDULER_DISABLED','FALSE');
PL/SQL procedure successfully completed.
SQL>

Verification :
SQL> select name,user from v$database;
NAME      USER
--------- ------------------------------
EMREP     SYS
SQL> select comp_name,version from dba_registry;
COMP_NAME                                VERSION
---------------------------------------- ---------------
Oracle Database Catalog Views            10.1.0.4.0
Oracle Database Packages and Types       10.1.0.4.0
Oracle Workspace Manager                 10.1.0.2.0
SQL> cl scr
SQL> desc sysman.mgmt_versions
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
COMPONENT_NAME                            NOT NULL VARCHAR2(32)
VERSION                                   NOT NULL VARCHAR2(32)
COMPAT_CORE_VERSION                       NOT NULL VARCHAR2(32)
COMPONENT_MODE                                     VARCHAR2(32)
STATUS                                             NUMBER
SQL> select component_name,version from sysman.mgmt_versions;
COMPONENT_NAME                   VERSION
-------------------------------- ---------------
CORE                             10.2.0.5.0
DB                               10.2.0.5.0
PP                               10.2.0.5.0
IAS                              10.2.0.5.0
SSO_SERVER                       10.2.0.5.0
BC4J                             10.2.0.5.0
FORMS                            10.2.0.5.0
WIRELESS                         10.2.0.5.0
OCS                              10.2.0.5.0
WORKFLOW                         10.2.0.5.0
PORTAL                           10.2.0.5.0
INTEGRATIONBPM                   10.2.0.5.0
INTEGRATIONBAM                   10.2.0.5.0
DISCOVERER                       10.2.0.5.0
IFS                              10.2.0.5.0
REPSERV                          10.2.0.5.0
INTEGIC                          10.2.0.5.0
INTEGB2B                         10.2.0.5.0
CI                               10.2.0.5.0
_UPGRADE_                        0
CONNECTOR                        10.2.0.5.0
PA                               10.2.0.5.0
OCM                              10.2.0.5.0
CONTENT                          10.2.0.5.0
VT                               10.2.0.5.0
BEEHIVE                          10.2.0.5.0
26 rows selected.
SQL>
SQL> cl scr
SQL> !
[oracle@oemmach01 ~]$ cd /u01/app/oracle/oem/oms10g/bin
[oracle@oemmach01 bin]$ ./emctl status oms
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle Management Server is Up.
[oracle@oemmach01 bin]$ ./emctl status iasconsole
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Oracle 10g Application Server Control is not running.
[oracle@oemmach01 bin]$ cd ../opmn/bin
[oracle@oemmach01 bin]$ ./opmnctl status
Processes in Instance: EnterpriseManager0.oemmach01.localdomain
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status
-------------------+--------------------+---------+---------
HTTP_Server        | HTTP_Server        |    5536 | Alive
LogLoader          | logloaderd         |     N/A | Down
dcm-daemon         | dcm-daemon         |    6498 | Alive
OC4J               | home               |    5537 | Alive
OC4J               | OC4J_EMPROV        |    5538 | Alive
OC4J               | OC4J_EM            |    5540 | Alive
OC4J               | OCMRepeater        |   13900 | Alive
WebCache           | WebCache           |    5561 | Alive
WebCache           | WebCacheAdmin      |    5541 | Alive
DSA                | DSA                |     N/A | Down
[oracle@oemmach01 bin]$

Related articles: Install 10gR2 grid control and Agents

Hope It Helps
SRI
Share this article :

Related Articles By Category



Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger