oracle 9.2.0.6,Oracle Ebs DB 9.2.0.6升级至9.2.0.8

1.Apply patch OUI补丁

patch 5035661

在app，db两节点都要打

解压至IAS_ORACLE_HOME,ORACLE_HOME

perl OUIsetup.pl

2.Perform. 9.2.0.8 Patch Set installation tasks

patch 4547809

ps:在xwindows下安装,关闭APP,DB,选择原来的oracle_home

3.Apply latest Oracle Patching Tool (OPatch) patch 2617419

patch 2617419

ps:解压后，覆盖到$ORACLE_HOME/opatch

4.Apply additional 9.2.0.8 RDBMS patches

patch 5391326

patch 5495695

ps:这两个补丁要利用OPatch打上

opatch apply /ntkerp/patch/9208patch/5391326

5.Perform. 9.2.0.8 Patch Set postinstallation tasks

SQL> startup migrate

SQL>@catpatch.sql;

SQL> shutdown immediate

SQL> startup

SQL>@utlrp.sql

SQL>@utlrcmp.sql

SQL> @?/javavm/install/jvmsec3.sql

SQL> @?/javavm/install/jvmsec5.sql

ps:check system tablespace free >10M,share_pool_size,java_pool_size>150

6.Gather statistics for SYS schema

SQL> execute dbms_stats.gather_schema_stats

('SYS',cascade=>TRUE,degree=>20);

7.重启app