接着在合并应用节点中提到的,最近在做升级项目。ebs 11i对于DB 11gR2需要升级到RUP6,今天刚好有时间,将操作步骤整理如下。本文将着重介绍ebs 11i升级RUP6的过程
环境信息:
EBS APP----------11.5.10.2(linux 4.5 32bit)
EBS DB------------9.2.0.6(AIX 6.1 64bit)
前提:应用处于关闭状态,adadmin打开维护模式
参考文档:
About Oracle Applications Technology ATG_PF.H Rollup 6 (Doc ID 444524.1)
1 应用AD.I.5补丁
补丁号5161676(US/ZHS),应用补丁后需要执行如下后续操作
登录数据库服务器,拷贝应用服务器$APPL_TOP/admin/adgrants.sql到数据库服务器,执行
sqlplus /nolog
SQL> connect /as sysdba
SQL> @adgrants.sql APPLSYS
参考:R11i : About Oracle Applications DBA Minipack 11i.AD.I (Doc ID 233044.1)
2 应用其他前置补丁
2.1 应用补丁5989593
AD: 11i: Remove "REVOKE ALL FROM PUBLIC" from ADGRANTS.SQL
应用补丁5989593(US/ZHS),patch完成后执行如下后续操作
登录数据库服务器,拷贝应用服务器$APPL_TOP/admin/adgrants.sql到数据库服务器,执行
sqlplus /nolog
SQL> connect /as sysdba
SQL> @adgrants.sql APPLSYS
2.2 应用补丁3218526
BNE: Patch 11i.BNE.D - Refer to About Web Applications Desktop Integrator Mini-pack 11i.BNE.D, OracleMetaLink Note 287080.1, for installation instructions.
2.2.1 确认系统是否已经存在BNE产品
SQL> select * from APPLSYS.FND_APPLICATION where APPLICATION_SHORT_NAME = 'BNE';
如果未返回记录那么需要运行adsplice工具去把BNE加入到系统(相关补丁:2824380 - Splice files for the BNE Product )
2.2.2 应用3218526前置补丁
FND-3757164: INPUT FILTERING ONE-OFF FOR FND
FND-2278688: Oracle Self Service Framework Version 5.6E
FND-3358500: SSO Pre-Req for Applications Products – Rollup E
FND-2565888: AOL Java rollup patch H.1 to replace rollup H
FND-2666624: FNDJAR.DEP Pre-req needed for changes to JAR files: FNDSEC.JAR and FNDCCT.JAR
BNE-4252319: LANGUAGE FILE SETUP FOR BNE.D(3218526) PATCHSET
本系统需要应用4252319,其他补丁已应用。4252319(US)
4252319补丁成功应用后,adadmin执行如下操作
a. Compile APPS schema(s).
b. Compile flexfield data in AOL tables.
2.2.3 应用补丁3218526
应用补丁3218526(US/ZHS),补丁成功应用后,adadmin执行如下操作
a. Compile APPS schema(s).
b. Compile flexfield data in AOL tables.
2.2.4 补丁3218526后续操作
以下需要操作的部分均为webadi的业务上的设定
4.1) The Web server must be restarted after the successful application of the Patch Set.
4.2) Review the list of profile options in the Implementation and User Documentation specified in the Additional Product Information section.
4.3) Review the seeded form functions, menu, and responsibility in the Implementation and User Documentation specified in the Additional Product Information section. Give Oracle Application Users access to Web ADI form functio