20150506 Created By BaoXinjian
一、摘要
1. Oracle Erp从R12.1.1升级到R12.1.3的相关步骤
Step1. Database 通过opatch安装数据库补丁
Step2. Application 通过adpatch安装应用补丁
Step3. 通过Autoconfig配置安装补丁后程序
2. Oracle Erp升级的相关文档
[761570.1] Database Preparation Guidelines for an E-Business Suite Release R12.1.1 Upgrade
[1080973.1] Oracle E-Bussiness Suite Release 12.1.3 Readme
二、Database 通过opatch安装数据库补丁
安装数据库补丁
Step1. 查看目前数据库补丁安装情况
$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc /u1/VIS/visora/db/tech_st/11.1.0/oraInst.loc
Step2. 如果数据库Opatch版本存在问题，通过Patch No 6880880下载最后一个版本的Opatch
Opatch - 6880880
Step3. 安装数据库补丁
从Metalink中下载以下补丁，并安装，安装R12.1.1之后，数据库版本是，有一部分补丁已经安装，所以无需再次安装
6460304 -- 已存在，无需再次安装
7111245
7330434
7486407
7627743
7639602
7684818 -- 已存在，无需再次安装
8199107
8639653 -- 已存在，无需再次安装
8940108 -- 已存在，无需再次安装
9026927 -- 已存在，无需再次安装
9066130 -- 已存在，无需再次安装
9554727 -- 已存在，无需再次安装
9743057 -- 已存在，无需再次安装
Step4. 安装对应补丁
(1). 查看oraInst.loc文件路径，看相应的Oracle Inventory Home安装是否正确
cd /u1/VIS/visora/db/tech_st/11.1.0/rdbms/admin/
(2). 切换账号，设定初始化参数，并安装补丁
su oravis
source PROD_paleonode1.env
$ORACLE_HOME/OPatch/opatch apply -invPtrLoc /u1/VIS/visora/db/tech_st/11.1.0/oraInst.loc
Step5. 安装后确认补丁是否安装成功
$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc /u1/VIS/visora/db/tech_st/11.1.0/oraInst.loc
Step6. 补丁安装完毕后，修改数据库参数
$ORACLE_HOME/db/initPROD.ora
#For upgrading to R12.1.3
_disable_fast_validate=TRUE
event="31151 trace name context forever, level 0x100"
_pga_max_size=104857600
三、Application 通过adpatch安装应用补丁
Step1. 启动Database，关闭Application
Step2. 通过adadmin切换至运维模式
Step3. 安装补丁9239089
9239089 - R12.AD.B.delta.3: Oracle Applications DBA 12.1.3 Product Release Update Pack
Step4. 安装补丁9239090
9239090 - 12.1.3: ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK
(1). 查看自述文件
(2). 下载补丁批次
(3). 安装补丁
There are now 9726 jobs remaining (current phase=A32):
4 running, 24 ready to run and 9698 waiting.
Completed: file igiiareb.pls on worker 3 for product igi username IGI.
Assigned: file igiiarnb.pls on worker 3 for product igi username IGI.
Completed: file igiiadxb.pls on worker 1 for product igi username IGI.
Completed: file igiiardb.pls on worker 2 for product igi username IGI.
Assigned: file igiiartb.pls on worker 1 for product igi username IGI.
Assigned: file igiiasab.pls on worker 2 for product igi username IGI.
Completed: file igiiarlb.pls on worker 4 for product igi username IGI.
Assigned: file igiiascb.pls on worker 4 for product igi username IGI.
Completed: file igiiascb.pls on worker 4 for product igi username IGI.
Assigned: file igiiatfb.pls on worker 4 for product igi username IGI.
Completed: file igiiasab.pls on worker 2 for product igi username IGI.
Assigned: file igiiaytb.pls on worker 2 for product igi username IGI.
Completed: file igiiarnb.pls on worker 3 for product igi username IGI.
Assigned: file jai_ap_ha_t.plb on worker 3 for product ja username JA.
Completed: file igiiartb.pls on worker 1 for product igi username IGI.
Completed: file igiiaytb.pls on worker 2 for product igi username IGI.
Completed: file igiiatfb.pls on worker 4 for product igi username IGI.
Assigned: file jai_ap_ida_t.plb on worker 1 for product ja username JA.
Assigned: file jai_ap_ila_t.plb on worker 2 for product ja username JA.
Assigned: file jai_ar_rcta_t.plb on worker 4 for product ja username JA.
四、安装Post Patch
系统打完Opatch和Adpatch补丁后，需要安装后面两个补充补丁
1. 9817770 - Required
POST-R12.ATG_PF.B[POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH]
2. 9966055 - Required
POST-R12.FND.B [TRANSLATED VERSION OF FNDSCSGNNOT LAUNCHED]
3. 9239095 - Optional
Oracle E-Businees Suite Online Help for 12.1.3 Release Udpate Pack
五、通过Autoconfig配置安装补丁后程序
在database 和 application中安装
1. 在application Tier运行autoconfig
su oravis
source APPSPROD_paleonode1.env
Applicationtier: $INST_TOP/admin/scripts/adautocfg.sh perl $AD_TOP/bin/admkappsutil.pl
2. database Tier运行autoconfig
(1). 配置autoconfig
su applvis
source PROD_paleonode1.env
cp /u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/out/appsutil.zip $ORACLE_HOME/
unzip -o appsutil.zip
(2). 运行autoconfig
$ORACLE_HOME/appsutil/scripts/PROD_paleonode1/adautocfg.sh
3. 安装后查看Oracle Applcation 和 Database 版本
Thanks and Regards
参考： 百度文库 - http://wenku.it168.com/d_001281414.shtml
技术交流，技术讨论，欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建
