DBA_Oracle Erp版本升级12.1.1到R12.1.3（案例）

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