Oracle Technologies Blog

By ASKM

Applying OEM Grid Control Patchset 10.2.0.5

Posted by Srikrishna Murthy Annam on May 25, 2011

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: