EBS 11i升级Developer 6i到patch set 19

接之前所说，关于ebs 11i系统升级数据库到11gR2。需要将Developer 6i至少升级到patch set 18。本次计划升级Developer 6i升级到patch set 19。

参考文档：Upgrading Developer 6i with Oracle Applications 11i (Doc ID 125767.1)

前提条件：

应用处于关闭状态，并处于维护模式

已应用RUP6，参考http://blog.csdn.net/li7080301/article/details/17585587

1 安装Developer 6i Patches

1.1 查看当前Developer 6i版本

[appltest@test02 ~]$ $ORACLE_HOME/bin/f60gen help=y

Forms 6.0 (Form Compiler) Version 6.0.8.25.0 (Production)

Developer 6i对应补丁及版本列表如下：

Developer 6i	Dev 6i Patch	Forms	Reports	Graphics	Apps Interop Patch
Patch 15*	3171855	6.0.8.24.x	6.0.8.24.x	6.0.8.17.x	3935987
Patch 16*	3596539	6.0.8.25.x	6.0.8.25.x	6.0.8.17.x	3392966
Patch 17*	4183804	6.0.8.26.x	6.0.8.26.x	6.0.8.17.x	4138754
Patch 18*	4948577	6.0.8.27.x	6.0.8.27.x	6.0.8.17.x	4888294

通过上述命令，及列表可发现。当前系统Developer 6i对应版本为patch set 16。

1.2 安装补丁6194129 Oracle Developer 6i patchset 19 (6.0.8.28.x)

1.2.1 解压缩补丁6194129

解压缩补丁6194129 Patchset文件到$ORACLE_HOME下

cd $ORACLE_HOME
cp p6194129_60828_LINUX.zip $ORACLE_HOME
unzip  p6194129_60828_AIX5L.zip

1.2.2 Run the install script contained in the patch

cd $ORACLE_HOME/developer6i_patch19
./patch_install.sh 2>&1 | tee patch_install_p19.log

查看patch_install_p19.log是否有错误

1.2.3 Relink Procedure Builder, Forms, Graphics and Reports

cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install

1.2.4 执行ins_reports60w.mk

确定环境变量$LD_LIBRARY_PATH已经包含$ORACLE_HOME/network/jre11/lib/linux/native_threads

cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install

2 安装其他 Developer 6i Patches

2.1 安装补丁16699473，将补丁解压缩到$ORACLE_HOME下后再进行patch操作。

cd $ORACLE_HOME
unzip  p16699473_60828_LINUX.zip
cd 16699473
sh patch.sh

2.2 backup of the class files

cd $ORACLE_HOME/16699473
sh backup.sh

2.3 copy all files to $ORACLE_HOME with respective location

cd $ORACLE_HOME/16699473
sh copy_files.sh

2.4 Backup the Forms java subtree and extract the changed files

cd $ORACLE_HOME/forms60/java
cp -r oracle/ewt oracle/ewt.PREBUG16699473
jar -xvf $ORACLE_HOME/16699473/ewt3.jar
rm META-INF/MANIFEST.MF
rmdir META-INF

2.5 Verify that the EWT version has been updated

cd $ORACLE_HOME/forms60/java
ls -la oracle/ewt | grep 3_4_49
-rw-r--r--   1 appltest dba    46 Dec 16 14:27 3_4_49

2.6 regenerate jar files using adadmin

1 Generate Applications Files menu
5 Generate product JAR files
Do you wish to force regeneration of all jar files? [No] ? Yes

cd $OA_JAVA/oracle/apps/fnd/jar
ls -l |grep fndforms.jar
appltest dba  701915 Dec 16 14:30 fndforms.jar
ls -l |grep fndewt.jar
appltest dba 2247765 Dec 16 14:30 fndewt.jar

Note: If you are an Oracle Applications customer, please also run
adrelink
E.g. to relink f60webmx for Oracle Applications:
adrelink.sh force=y "fnd f60webmx"

2.7 安装补丁3830807

cd $ORACLE_HOME
unzip p3830807_8063_LINUX.zip
cd $ORACLE_HOME/3830807
chmod u+x patch.sh
Check the value of LD_LIBRARY_PATH.
$LD_LIBRARY_PATH需要包括$ORACLE_HOME/network/jre11/lib/linux/native_threads
或者$ORACLE_HOME/network/jre11/lib/i686/native_threads
./patch.sh
Relink all Applications executables
adadmin
Generate Applications Files
Relink Applications programs

3 编译应用相关的程序

运行adadmin去编译可执行程序，包括f60webmx, ar60run , ar60runb, ar60rund：
Enter list of products to link ('all' for all products)[all] : fnd
Generate specific executables for each selected product [No] ? y
Relink with debug information [No] ? n

(You will then be offered a list of executables that are available for relinking)

Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund

4 安装Oracle Applications 11i Interoperability 补丁

安装补丁9935935

5 安装补丁9094950

安装补丁9094950以解决步骤2中补丁10043867带来的bug。

9094950(US/ZHS)

9094950前置补丁3036401，包含在11.5.10.2的补丁3151672中。

 

综上操作后，查看Developer 6i版本。

[appltest@test02 ~]$ $ORACLE_HOME/bin/f60gen help=y

Forms 6.0 (Form Compiler) Version 6.0.8.28.0 (Production)