Installation Checklist for EM 10g GC 10.2.0.1 to 10.2.0.2 OMS...-422062.1
Installation Checklist for EM 10g
Grid Control 10.2.0.1 to 10.2.0.2 OMS and Repository Upgrades [ID
422062.1]
In this Document
Purpose
Scope and
Application
Installation Checklist for EM 10g Grid
Control 10.2.0.1 to 10.2.0.2 OMS and Repository Upgrades
Reducing the Upgrade Time:
Preparing
the Repository Database:
Preparing for the
Upgrade:
Post-processing After the
Upgrade:
Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.2Information in this document applies to any platform.
Purpose
This article is a quick checklist to follow when upgrading EM 10g 10.2.0.1 to EM 10g 10.2.0.2Scope and Application
This article is intended for anyone needing to upgrade EM Grid Control from 10.2.0.1 to 10.2.0.2 by installing the 10.2.0.2 Grid Control patchset.Installation Checklist for EM 10g Grid Control 10.2.0.1 to 10.2.0.2 OMS and Repository Upgrades
Reducing the Upgrade Time:
To speed up the data migration part, a couple of maintenance tasks should be performed on the repository prior to the upgrade.
NOTE: All statements below should be ran as the 'SYSMAN'
user (Repository owner).
1. Run the partition maintenance routines:
In order to run the partition maintenance routines, the OMS's will
have to be stopped.
After all the OMS's have been shutdown, perform. the following steps:
SQL> EXEC emd_maintenance.remove_em_dbms_jobs;
SQL> ALTER SYSTEM SET job_queue_processes=0 SID='*';
SQL> EXEC emd_maintenance.partition_maintenance;
SQL> ALTER SYSTEM SET job_queue_processes=10 SID='*';
SQL> EXEC emd_maintenance.submit_em_dbms_jobs;
Delete all pending-delete ECM snapshots, by running these two
PL/SQL routines:
DECLARE
pcb_params MGMT_PURGE_CALLBACK_PARAMS :=
MGMT_PURGE_CALLBACK_PARAMS(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
BEGIN
ecm_ct.DELETE_SNAPSHOTS(pcb_params);
END;
/
DECLARE
pcb_params MGMT_PURGE_CALLBACK_PARAMS :=
MGMT_PURGE_CALLBACK_PARAMS(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
BEGIN
ecm_ct.DELETE_HOST_CONFIG_SNAPSHOTS(pcb_params);
END;
/
3. After running all the cleanup, make sure the statistics on all the repository tables are accurate and up-to-date. Run this procedure to analyze the statistics on the repository tables:
SQL> EXEC emd_maintenance.analyze_emd_schema('SYSMAN');
Preparing the Repository Database:
1. If the version of the repository database is 10.1.0.3 or 10.1.0.4, the following patch will need to get applied to the repository database prior to the upgrade:Bug 4143213: VPD MISBEHAVIOUR CAUSES RANDOM FAILURES IN EM GRID JOB SYSTEM
2. If the version of the repository database is 10.1.0.4 or 10.1.0.5, the following patch will need to get applied to the repository database prior to the upgrade:
Bug 4329444: SKIP SCAN OF COMPRESSED INDEX ON INDEX-ORGANIZED TABLE (IOT) GIVES WRONG RESULTS
On Windows platforms, you will need to upgrade the 10.1.0.4
database to 10.1.0.5 using patch 5731187. The 10.1.0.5 patchset includes the
patch 4329444.
3. If the version of the repository database is 10.2.0.1 to 10.2.0.3, the following patch will need to be applied to the repository database prior to upgrade:
Bug 5103126: INSERTS TAKEING 2 TO 3X LONGER IN 10.2.0.2 WITH PRESENCE OF
UNIQUE INDEX
Preparing for the Upgrade:
1. If Grid Control has been running with version 10.2.0.1 for a while, the table MGMT_JOB_STATE_CHANGES will have grown quite considerable in size.To optimize the flow of jobs, and the dispatching of jobs with 10.2.0.2, this table should get truncated:
SQL> TRUNCATE TABLE mgmt_job_state_changes;
5043773: PERF: MMR TRIGGER IS TOO HEAVY
If this patch is applied, the upgrade to 10.2.0.2 will fail.
$ PATH=$ORACLE_HOME/OPatch:$PATH
$ export PATH
$ cd$ opatch rollback -id 5043773
After the upgraded has completed, the 10.2.0.2 version of this patch can be applied:
Bug 5403839: MLR FOR BUGS 4712213 AND 5043773 ON TOP OF 10.2.0.2
3. Run the EMDiagKit and fix all of the found issues.
Certain problems in the repository can be found and fixed using the EMDiagkit. See Note.421053.1 Prior to running the upgrade of Grid Control, verify the repository by running the EMDiagKit:
To verify:
SQL> EXEC mgmt_diag.VerifyAll(9);
To verify and Fix:
SQL> EXEC mgmt_diag.VerifyAll(9,TRUE);
Post-processing After the Upgrade:
1. Check the status of the DBMS_JOBS.After bringing up the repository, and with the OMS's all up-and-running, run this query, to verify the conditions of the DBMS_JOBS:
SQL> SELECT COUNT(*) FROM user_jobs;
COUNT(*)
--------
17
This query should return 17 on the migrated repository.
2. Since several tables got migrated and changed during the upgrade process, the statistics on these tables are not in sync anymore. To get accurate and up-to-date statistics on the repository, analyze the repository schema again:
SQL> EXEC emd_maintenance.analyze_emd_schema('SYSMAN');
3. After the upgrade has completed, and the environment has been upgraded to 10gR2, verify the system again with the EMdiagkit:
SQL> EXEC mgmt_diag.VerifyAll(9);
Critical patch list:
--------------------
This is the list of critical patches which is needed for 10.2.0.2:
4712213: PERF: OHSEM - FULL TABLE SCANS ON METRIC ERRORS PURGE
5055727: METRICS FOR RAC ARE SHOWING UP TWICE AFTER THRESHOLD CHANGE VIA TEMPLATE
5382668: EM_PURGE.APPLY_PURGE_POLICIES RUNNING FOR 4 DAYS
5448666: MISMATCH BETWEEN PING AND CURRENT AVAILABILITY FOR TARGETS
5709628: MLR FOR BUGS 4969057, 5108394, 5357916, 54038 ON TOP OF 10.2.0.2 FOR LINUX/INTEL
5725201: MLR FOR BUG-5690074 AND BUG-5661403 ON TOP OF 10.2.0.2 FOR LINUX/INTEL
5938050: JOB BACKLOG DUE TO REVERSE PING JOBS
5977153: TABLES MGMT_DELTA_ENTRY AND MGMT_DELTA_ENTRY_VALUES GROWING TOO FAST
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-760179/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- IOMESH Installation
- Tape-out Checklist FormORM
- 2.3.3.2 Application InstallationAPP
- EM
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- 簡單的 web 安全 checklistWeb
- A Tomcat 8.0 installation is expectedTomcat
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- 從10.2.0.1升級到10.2.0.5操作實驗(下)
- 全志R16原理圖 checklist
- em 和 remREM
- 07-Plugin ‘scala’ is incompatible with this installationPlugin
- Include manifest for over-the-air installationAI
- Adding Drivers into VMWare ESXi Installation Image
- 做機器學習專案的checklist機器學習
- 記憶體使用過高點檢checklist記憶體
- Full GC (Metadata GC Threshold)GC
- rem與em的區別||結合使用rem與emREM
- oracle EM 優化Oracle優化
- 從CLR GC到CoreCLR GCGC
- 前端團隊程式碼評審 CheckList 清單前端
- GCGC
- 04EM演算法-EM演算法收斂證明演算法
- GC.MaxGeneration屬性【GC示例】GC
- px em rem 探討REM
- EM演算法1演算法
- Oracle 19C EMOracle
- Windows Server 2019 Installation 安裝.net 3.5WindowsServer
- 03EM演算法-EM演算法流程和直觀案例演算法
- 架構師必備:系統容量現狀checklist架構
- 10g RAC on AIXAI
- After mysql installation, we need to change the password of root as belowMySql
- 淺談px,em與remREM
- 白話EM演算法演算法
- em字型大小參考物件物件
- 4.4 為CDB配置EM ExpressExpress
- 09_EM演算法演算法
- em、rem、px、的區別REM
- 隨機森林、EM、HMM、LDA隨機森林HMMLDA