Oracle Ebs DB 9.2.0.6升级至9.2.0.8
本文档由ice.xie原创,转载请说明出处
版本说明:
EBS:11.5.10.2
Oracle:9.2.0.6
OS: RHAS 4(oracle linux)
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[/COLOR]
4.Apply additional 9.2.0.8 RDBMS patches
patch 5391326
patch 5495695
ps:这两个补丁要利用OPatch打上
opatch apply /ntkerp/patch/9208patch/5391326[/COLOR]
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[/COLOR]
6.Gather statistics for SYS schema
SQL> execute dbms_stats.gather_schema_stats
('SYS',cascade=>TRUE,degree=>20);
7.重启APP,OK
|