Checklist for EM 10g GC 10.2.x to 10.2.0.5 OMS and Repository Upgrades_464674.1
Checklist for EM 10g Grid Control 10.2.x to 10.2.0.5 OMS and Repository Upgrades (Doc ID 464674.1)
In this Document
Applies to:Enterprise Manager Base Platform - Version 10.2.0.2 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform. PurposeThis article is a quick checklist to follow when upgrading Enterprise Manager Grid Control 10.2.0.x to Enterprise Manager Grid Control 10.2.0.5 and to report any Known Issues during Oracle Grid Control 10.2.0.5 Upgrade. ScopeThis article is intended for anyone needing to upgrade Enterprise Manager Grid Control from 10.2.0.x to 10.2.0.5 using the 10.2.0.5 Grid Control patchset. DetailsImportant Oracle recommends that you back up the ORACLE_HOME that must be upgraded using this Patch Set. In the case of a Management Repository, Oracle recommends that you back up the repository database because the Patch Set makes changes to the repository that cannot be rolled back. Also, back up the Oracle Central Inventory directory. Preparing for the 10.2.0.5 Upgrade:
1. Make sure that you meet the product pre-requisites (operating system patches, packages etc.) for the 10.2.0.5 patch set. For information about platform-specific package and kernel requirements,
2. Before upgrading your Oracle Management Service, ensure that the Shared Pool size is set in your Grid Control repository database as per your infrastructure. Minimum size for shared pool is 512 MB. For more details, refer to requirements described in the Enterprise Manager Grid Control Installation Guide available at : http://download.oracle.com/docs/cd/B16240_01/doc/nav/portal_booklist.htm
3. If the database housing the Grid control repository is linked with a Data Guard database, before the upgrade starts, the database has to be forced in logging mode, to force all index maintenance commands to be propagated to the standby database.
SQL> CONNECT / AS SYSDBA;
SQL> ALTER DATABASE FORCE LOGGING;
4. If your Enterprise Manager is shutdown for a long period of time, you must follow the below steps before conducting the upgrade:
SQL> exec emd_maintenance.analyze_emd_schema('SYSMAN');
b.) Start the Oracle Management Service.
5. Make sure that the Partitioning option is enabled in the Database housing the Grid control repository (SYSMAN schema)
SQL> select value from v$option where parameter = 'Partitioning';
Should give VALUE=TRUE.
Note:
1.No additional partitioning license is required for the Database housing the Grid control repository, as it is a basic Grid Control requirement. 2. Installing Grid Control with Repository in a Database that does not have Partitioning enabled is unsupported. In the earlier versions, running the repository database without partitioning could go un-noticed but starting with 10.2.0.5, the EMGC code expects the partitioning option to be there. 3. If the Partitioning Option is not enabled in the repository Database, trying to upgrade the OMS from a lower version to 10.2.0.5 will fail at the Repository Upgrade Step with these errors in the emrepmgr.log.10.2.0.5 ************* SQL> DECLARE 2 MGMT_AUDIT_LOGS VARCHAR2(40) :=MGMT_AUDIT_LOGS'; 3 l_sql VARCHAR2(10000) :=CREATE TABLE ' || MGMT_AUDIT_LOGS || 4 ' (user_session_id_guid RAW(64) DEFAULT NULL, .. .. ERROR at line 1: ORA-439: feature not enabled: Partitioning ORA-6512: at line 63 ************* To avoid the ORA-439 error, ensure that the Partitioning option is enabled in the repository database before the upgrade. Reference: Note 743857.1: Grid Control Repository: How to Partition the MGMT_METRICS_* Tables if Repository is Created in a Database without Partitioning Option?
SQL> SELECT value FROM nls_database_parameters WHERE parameter='NLS_LENGTH_SEMANTICS';
If the value is not set to 'BYTE', change it by running the below command:
SQL> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=BYTE SCOPE=both;
7. Login in the Database as Sysman and remove the following Job:
SQL> SELECT job FROM user_jobs WHERE what='MGMT_CNTR_TT.clean_up_old_ticket_recs;';
SQL> exec dbms_job.remove( SQL> COMMIT;
8. Make sure there are no Invalid SYSMAN objects in Grid Control repository database. Perform the following steps before upgrading.
a) Login into the Database as SYS user and
SQL> select object_name, object_type from all_objects where owner='SYSMAN' and status <> 'VALID';
The above query should return 0 rows. If there are rows, then run the below sql statement:
SQL> @admin_recompile_invalid.sql SYSMAN
The admin_recompile_invalid.sql script is available under
Where c.) Go to step b again to be sure all SYSMAN objects are valid. If you still have invalid SYSMAN objects, please contact Oracle support. d.) Check there is no invalid SYS object:
SQL> select object_name, object_type from all_objects where status<>'VALID' and object_name like 'DBMS%';
e) If any of the packages fail to become valid even after recompilation, then Contact Oracle Support to assist you. Once this verification is done, continue with the rest of the tasks.
9. If SYSMAN and DBSNMP user doesn't have execute permission to the DBMS_RANDOM package then upgrade will fail during the Repository Upgrade configuration assistant.
SQL> grant execute on dbms_random to dbsnmp;
SQL> grant execute on dbms_random to sysman; c) Verify that below query does not return any invalid objects
SQL> select object_name, object_type, owner from dba_objects where status='INVALID';
SET SERVEROUTPUT ON SIZE 4000
SET LINE 255 SPOOL run_after_upgrade.sql begin for rec in ( select TARGET_TYPE ,PROPERTY_VALUE FROM MGMT_TYPE_PROPERTIES WHERE TARGET_TYPE IN ( 'RHreposURL','SusereposURL','SolarisreposURL','WindowsreposURL','PatchCrossRef' )) loop begin dbms_output.put_line('INSERT INTO MGMT_PATCHING_PROPERTIES(PROPERTY_TYPE,PROPERTY_NAME,PROPERTY_VALUE)values(''os_patching_repos_url'','''||rec.TARGET_TYPE||''','''||rec.PROPERTY_VALUE||''');'); end; end loop; dbms_output.put_line('COMMIT;'); end; / SPOOL OFF
DELETE MGMT_TYPE_PROPERTIES WHERE TARGET_TYPE IN ('RHreposURL','SusereposURL','SolarisreposURL','WindowsreposURL','PatchCrossRef' );
COMMIT; /
11. If your 10.1.0.5.0 database containing the Grid Control repository does not have the CPU Jan 2008 patch 6826532 applied, then make sure that you apply this patch. If you have applied the latest CPU Jan 2009 patch 7592360 on your repository database, then you need not apply the CPU Jan 2008 patch 6826532.
Note: CPU Jan 2008 patch 6826532 and CPU Jan 2009 patch 7592360 are not applicable on Windows platform
12. If you have applied the latest CPU Jan 2009 patch 7608318 to your Oracle Management Service (OMS) before upgrading, then you may receive a warning about patch conflict during the product specific prerequisite check. You can ignore this warning and continue with the 10.2.0.5.0 upgrade. The installer will automatically rollback the patch.
13. If you have applied the latest CPU Jan 2009 patch 7608318 to your Oracle Management Service (OMS) before upgrading, then make sure that permission of the following files under the Oracle home directory of OMS
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'; b. Turn off DBMS JOBS by running the following command:
SQL> execute emd_maintenance.remove_em_dbms_jobs;
SQL> commit; SQL> ALTER SYSTEM SET job_queue_processes=0 SID='*'; Note: This will not kill currently running jobs but allows them to execute till their completion. There onwards, no new jobs can be started. Make sure there are no active Jobs by running the following :
SQL> SELECT l.id2 job, l.sid, to_char(last_date, 'DD-MON-YYYY:HH24.MI.SS') last_date,
to_char(this_date, 'DD-MON-YYYY:HH24.MI.SS') this_date, l.inst_id instance FROM sys.job$ j, gv$lock l WHERE l.type = 'JQ' AND j.job (+) = l.id2 ORDER BY 5, 4; c. Turn off the DBMS Scheduler by running (for version 10.1+ RDBMS) the following command:
SQL> exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
d. Be sure there were no active schedules running by waiting until the following query returns 0 (for version 10.1+ RDBMS):
SQL> select count(*) from dba_scheduler_running_jobs where SLAVE_PROCESS_ID IS NOT NULL;
15. The 7214697 patchset implements improved provisioning functionality with the 10.2.0.4.0 Grid Control product. These improvements are integrated in the 10.2.0.5.0 version. a.) For 10.2.0.4.0 Grid Control OMS installed on Unix platforms only, apply patch 7214697 to your Oracle home directory of the Oracle Management Service.
Note: If you have a multiple OMS setup, then apply Patch 7214697 to all the OMS ORACLE_HOMEs. This patch updates the files in the OMS and in repository and hence needs to be applied to all OMSs before proceeding with the Upgrade Step.
b.) You should see preinstall.pl file in the top level directory after extracting the patchset. Run this script before upgrading the OMS using the following command:
$PROMPT> perl preinstall.pl
Here OMS_HOME is the Oracle home directory of the Oracle Management Service. This is a generic script and can be used on all the platforms. Note: The above step is not required when the OMS is on a Windows platform.
16. During the Upgrade it will ask you for the ias_admin user password. The ias_admin user is the administrative user for Oracle Application Server instances. The password that you specify here is required to access the application server and to deploy the new features. This password is same as the SYSMAN password that you specified when you first installed the Grid Control in your environment.
Note: After installing the Grid Control in your environment, if you change the SYSMAN password, ias_admin password will not be changed.
To change the ias_admin password, go to the Oracle home directory of Oracle Management Service and run the following command:
$ORACLE_HOME/bin/emctl set password
17. If the secure key was exported out of the repository, it has to be put back into the repository during the upgrade. To check if the key is outside of the repository, use this command:
$ emctl status emkey
If the output reports "The Em Key is configured properly", the key is exported out of the repository, and needs to get imported again:
$ emctl config emkey -copy_to_repos
Note: If you don't remember the old ias_admin password, follow the instructions from Document 280116.1 How To Reset or Change the ias_admin User Password for Application Server Console (AS Control)
18. Check for duplicate target associations.
+ Download the EMDiagkit from the Note 421053.1 EMDiagkit Download and Master Index
+ Install it as per instructions in Note 421499.1 How to Install - Deinstall + Set the environment as per Note 421586.1 Environment Variables $ repvfy verify targets -test 6
SQL> CREATE TABLE foo AS SELECT * FROM mgmt_flat_target_assoc;
b.) Clean up the MGMT_FLAT_TARGET_ASSOC table
SQL> TRUNCATE TABLE mgmt_flat_target_assoc;
c.) Re-create all the associations
SQL> exec EM_ASSOC.recreate_full_flat_assoc;
SQL> COMMIT; d.) If everything has completed OK, drop the temporary table
SQL> DROP TABLE foo;
|
|
- preinstall.pl script(0.72 KB)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1246520/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Installation Checklist for EM 10g GC 10.2.0.1 to 10.2.0.2 OMS...-422062.1GC
- Install EM GC 10.2.0.5 Using Existin DB with Software Only on Linux x86_763347.1GCLinux
- 10g GC 啟動oms報錯Unexpected error occurred. Check error and log files.GCError
- Oracle 10.2.0.5 EM 啟動BUG問題解決Oracle
- To Verify if the Enterprise Manager GC (OMS) is Locked or Unlocked_428874.1GC
- EM 12c推送Agent出錯 - OMS_HOST and EM_UPLOAD_PORT is not availableAI
- oracle 10g em建立Oracle 10g
- oracle 10g em patchOracle 10g
- Using silent mode to install GC 10.2.0.1 and upgrade GC to 10.2.0.5 by Using an Existing Database onGCDatabase
- Agent to OMS Communi Fails if Agent is 'Blocked' in 10.2.0.5 Grid Cons_799618.1AIBloC996
- Oracle 10g EM 亂碼問題Oracle 10g
- oracle 10g em啟動失敗Oracle 10g
- AIX上配置ORACLE 10g RAC EMAIOracle 10g
- Automatic Start GC Agent 10.2.0.5 via gcstartup Script fails with sudo_789363.1GCAI
- 【GC】OEL4.8部署安裝 Grid Control OMSGC
- 【GC】重新配置Agent以應對 OMS伺服器的變化GC伺服器
- EM 12c Cloud Control - Agent Unreachable : Received Key Mismatch from OMS - 3Cloud
- EM 12c Cloud Control - Agent Unreachable : Received Key Mismatch from OMS - 2Cloud
- EM 12c Cloud Control - Agent Unreachable : Received Key Mismatch from OMS - 1Cloud
- EM 12c 修改 EMGC_OMS1的 java heap size (JVM大小) - 2GCJavaJVM
- EM 12c 修改EMGC_OMS1的 java heap size (JVM大小) - 1GCJavaJVM
- OMS Startup Fails during Repository Connection Attempt due to_310772.1AI
- oracle 10g em 無法對所有 EM 相關帳戶解鎖Oracle 10g
- 【kingsql分享】安裝EM遇到【SEVERE: Error creating the repository】SQLError
- oracle 10g em啟動失敗 續Oracle 10g
- Oracle 10G重建EM DB ControlOracle 10g
- Grid Control一些術語GC、OMS、OMR、OMA的概念GC
- GC 10.2.0.1 OMS和Agent連線失敗後的處理過程GC
- OEM GC11G OMS不能發現主機的問題解決GC
- Agent to OMS Communi Fails if Agent's REPOSITORY_URL Para has Incorrect_737373.1AI
- Oracle Performance ChecklistOracleORM
- Oracle DBA ChecklistOracle
- Upgrade GC 10.2.0.x to 10.2.0.5 - Important Steps Required_853691.1GCImportUI
- OMS
- "OMSCA-ERR:Bounce OMS failed" While Install/Upgrad to 11.1 GC_1325193.1AIWhileGC
- 【GC】OEM Grid Control 11gR1部署之OMS部分GC
- 安裝oracle 10g EM database controlOracle 10gDatabase
- oracle 10g rac em重建實施步驟Oracle 10g