Finally today, i upgraded my grid control installation to 10.2.0.5 (From 10.2.0.4). Instructions for installing 10.2.0.4 can be found in my previous blog post, Installing Grid Control 10.2.0.4
Amazing but true, the process was fairly straight forward. I mostly followed the instructions in the Readme and its close, more detailed cousin, Metalink Note 464674.1. So without further ado, below are the steps that i followed.
Download the grid control patch 10.2.0.5
Unzip gc_10205_part2of2.zip (Because the file p3731593_10205_LINUX.zip you need is in that)
Take a good backup of the oms, agent and oracle database.
All of the following actions were performed on the management server.
Analyze the SYSMAN schema
Login to the SYSMAN schema in the management repository
SQL> exec emd_maintenance.analyze_emd_schema(‘SYSMAN’)
Check for Invalid Objects
Login to the SYSMAN schema in the management repository
SQL> select object_name, object_type from all_objects where owner=’SYSMAN’ and status <> ‘VALID’;
Login to the SYS schema in the management repository
SQL> select object_name, object_type from all_objects where status<>’VALID’ and object_name like ‘DBMS%’;
Stop jobs running in Enterprise Manager
Login to the SYSMAN schema in the management repository
SQL> execute emd_maintenance.remove_em_dbms_jobs;
 |
 |
Setup Database Initialization Parameters
Login to the SYS schema in the management repository
alter system set sga_max_size=1024M scope=spfile
alter system set sga_target=1024M scope=spfile;
alter system set job_queue_processes=0 scope=spfile;
alter system set shared_pool_size=512M scope=spfile;
Shutdown and restart the database.
Ensure that the database listener is up and running.
I had left the iasconsole (emctl start iasconsole) and oracle management server running (opmnctl startall)
Make sure that the following files under the Oracle home of OMS have write permissions before staring the Upgrade process.
<ORACLE_HOME>/j2ee/OC4J_EM/applications/em/em/online_help/paf_cs/paf_cs_he lp.jar
<ORACLE_HOME>/j2ee/OC4J_EM/applications/em/em/online_help/paf/paf_help.jar
If you do not remember the password for your iasconsole (It is supposed to be the same as the password you specified for SYSMAN during the original install), this will be a good time to follow metalink note 396344.1 and change this password (Because the patch installer will prompt you for this password, and will not proceed unless you provide the correct password).
Apply patch 10.2.0.5 to the OMS
cd to your software staging directory
cd /u01/oem
unzip gc_10205_part2of2.zip
unzip p3731593_10205_LINUX.zip
cd 3731593
./runInstaller
 |
 |
 |
 |
 |
 |
 |
 |
When it prompts you, run root.sh from the oms home.
Apply patch 10.2.0.5 to the Agent
cd /u01/oem/3731593
./runInstaller
 |
 |
 |
 |
 |
 |
Completing the Upgrade
Login as the schema SYS to the management repository
alter system set sga_max_size=500M scope=spfile;
alter system set sga_target=500M scope=spfile;
alter system set job_queue_processes=10 scope=spfile;
alter system set shared_pool_size=0 scope=spfile;
Restart the jobs scheduled in Enterprise Manager
Login as the schema SYSMAN to the management repository
SQL> EXEC emd_maintenance.submit_em_dbms_jobs;
Stop and restart the agent, management server and management repository database.
Login to enterprise manager and enjoy using 10.2.0.5
