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
- Pre-Upgrade Tasks
- Upgrading from 10201 to 10205 ( With Video Demo)
- 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