Developer 6i Patch 14

Posted : admin | On 14-05-2021

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

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

Forms:: Download Patch 17 For Oracle Developer 6i May 20, 2005. Dec 14, 2011. I need Oracle Developer Suite 9i version for windows xp and windows 7. Web Service On Forms 6i (Patch 17) Oct 16, 2010. I have a 'pure' client / server environment with forms/reports 6i (NO form server architecture) and my necessity is to retrieve data from. Where to find the Developer 6i Patch 5 (6.0.8.14) 364599 Jul 18, 2003 7:35 AM Hi, I've download the Oracle Forms Developer/Services 6i Release 2 for Windows 98/NT/2000/XP from Oracle.

前提条件：

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

已应用RUP6，参考http://www.voidcn.com/article/p-ntatxfxt-rb.html

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 6iDev 6i PatchFormsReportsGraphicsApps Interop Patch
6.0.8.24.x
6.0.8.25.x
6.0.8.26.x
6.0.8.27.x
Developer 6i Patch 14

通过上述命令，及列表可发现。当前系统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

Developer 6i patch 14 download

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操作。

Developer 6i Patch 14

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

Pes11 Next Season Patch 14 15

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

Developer 6i Patch 14

安装补丁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)

  • So, JEDF is the name of your database? How did you run your forms on the old machine?
    report
  • Yes , JEDF is the name of your database, I run my forms on the old machine by adding the JEDF on the registry in Local , how can I get the patch 3 ,because I could not find it
    Best regards
    145 pointsBadges:
    report
  • Here is a link I just found. I did not upload the file, so I cannot guarantee it is legit.
    http://www.4shared.com/zip/y5KmcG8-ba/dll.html
    report
  • Hi, Carlosdl
    Thank you very much for your cooperation , this link, it download file called XZipInst but I could not open it. can you help
    Best Regards
    145 pointsBadges:
    report
  • No, you probably hit the wrong link on the 4shared page. The file that you need to download is named 'dll.zip'. I downloaded yesterday when I posted the link, and it worked, and contained the 2 dll files you need.
    If for any reason that doesn't work, a Google search should help you. That's what I did yesterday, and got several results.
    report
  • Hi, Carlosdl
    Thank you very much for your cooperation , can you send the file dll.zip to my email jamil_alshaibani@yahoo.com
    Best Regards
    145 pointsBadges:
    report
  • Hi, Carlosdl
    Thank you very much for your cooperation , when I try to download the file dll.zip ,it downloading file called dll.exe file so, I did not run it because ,it is not zip file , please send this dll.zip to my email JAMIL_ALSHAIBANI@YAHOO.COM
    jamil
    report
  • Hi, I download the NN60.DLL, NNB60.DLL , and copy them to the folder c:orantbin but still the report is not working , and the report is not show any output only show the message working
    Waiting for your valuable answer.

    145 pointsBadges:
    report
  • Sorry Jamil, if that didn't solve it, I'm afraid I won't be able to offer more help, since I cannot replicate the error you are seeing, and the solution I proposed had worked for me and many others several times in the past.
    Good luck.
    report
  • hey i am also facing same kind problem, I have a old software using ms-access and oracle forms. Its running on windows xp , How i can migrate it to windows 7 ?
    report
  • 84,720 pointsBadges:
    report
  • hi @carlosdl https://itknowledgeexchange.techtarget.com/itanswers/run-an-oracle-6i-application-on-windows/ i did it :)
    report
  • i have a problem oracle 6i software i already installed oracle 6i in windows 8.1 in my pc this working fine, the same as installed my laptop not opening the oracle software when i double click it automatically close
    report
  • I have a database in Oracle 8i and installed forms & and reports 6i in Windows XP. But in Windows 7, the report didn't run the error is report background stopped working. Please, I need help.
    report
  • Try installing a printer in the lap top with proper driver and make the printer as default printer, it should work.
    report