Step by step upgrading of Developer 6i

Upgrading Developer 6i with Oracle Applications 11i

Assumptions:
Autoconfig Enabled
Forms Listener mode is selected.
Oracle 9.2.0.2 & Above
Perl 5.00503 (or later)
OPatch version is 1.0.0.0.57 or later

1) Download the latest Certified Developer 6i Patchset and Applications Interoperability Patch:
Download Patch:
6194129- Developer 6i
9935935- Interoperability Patch
2) Download Additional Developer 6i Patches:
For Linux Platform download the following patches:
9863561 (You must download and apply the latest interop 9935935 in order for this fix to work. )
6125732
6857221
5232832
8888184 (This patch cause errors when clicking a forms link . This is fixed by Applying  9094950)
7329300
6747939
7552880
Linux users must also apply the Linux interoperability Patch 3830807
3) Stop the Forms, Reports, HTTP, and Concurrent Manager Servers.


4) Install Developer 6i Patch:
Steps for Applying 6194129:
Note: You should be logged in as the oracle user with write previleges to the ORACLE_HOME.(ie. You have write permission to all the files under $ORACLE_HOME)
Installation Instructions
1. Set your ORACLE_HOME.
2. If you are going to apply this patch on top of an iAS install:
Set ORACLE_HOME to <iAS_HOME>/6iserver

Prepend <iAS_HOME>/6iserver/bin to the *beginning* of PATH

Prepend <iAS_HOME>/6iserver/lib to the *beginning* of LD_LIBRARY_PATH
3. Copy the files in this patch to your $ORACLE_HOME.
4. Unzip the patch using either WinZip on NT or unzip on Unix.
5. Run the install script contained in the patch:
cd $ORACLE_HOME/developer6i_patch19

./patch_install.sh 2>&1 | tee patch_install_p19.log (ksh)

./patch_install.sh |& tee patch_install_p19.log (csh)
6. Check patch_install_p19.log for errors.
7. 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
Reports has both link-time and run-time dependency with libjava.so so you need to append $ORACLE_HOME/network/jre11/lib/linux/native_threads in $LD_LIBRARY_PATH before linking Reports. The same $LD_LIBRARY_PATH should be used at run-time.
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install






5) Install the Additional Developer 6i Patches:
Steps for applying 9863561:

Shut down the listeners and copy the patch files

1.  Stop your web listeners and Forms Server.

2.  Copy the patch file within your 6i ORACLE_HOME and unzip this file within it to create a new subdirectory. You will be able to see the folder 9863561 which contains the actual one-off files.

     %cd $ORACLE_HOME
     %unzip  p9863561_60828_GENERIC.zip


Unzip the java class files and regenerate your JAR files

3.    Backup the Forms class files,(If class exist then take backpup of all class files, otherwise no need to take backup)
 
   Ex:   %cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
         $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG9863561
   
           Special Instruction
     *********************

       cd $ORACLE_HOME/forms60/java
       jar -xvf f60all.jar oracle/forms/ui/VBean.class


4.  Inside folder 9863561  in step-2 has class files in oracle/forms/handler
    Copy this file into ORACLE_HOME/forms60/java/oracle/forms/handler

     %cd $ORACLE_HOME/9863561/oracle/forms/engine
 
 %cp Main.class  $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
 %cp Main\$1.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class
 %cp RunformBundle.class $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class
   
%cd $ORACLE_HOME/9863561/oracle/forms/handler

 %cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class

 %cp BlockScroller.class           $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class

 %cp CancelQueryDialog.class       $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class
     
 %cp ComponentItem.class           $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class

 %cp FormCanvas.class              $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class

 %cp FormWindow.class              $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class
     
 %cp FormPrintableImpl.class      $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class
     
 %cp FormMenu.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class
       
 %cp TextComponentItem.class       $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class

 %cp UICommon.class               $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class

%cp UICommon\$DeferredItem.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class

%cp UICommon\$1.class             $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class

 %cp FormsMouseWheelHandler.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class

 %cp IHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class

 %cp MenuInfo.class $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class

 %cp HeavyBeanManager.class      $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class

%cd $ORACLE_HOME/9863561/oracle/forms/ui

%cp VImage.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class        

%cp FScalingImageCanvas.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class

%cp FormMouseGrabProvider.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class

 %cp FormMouseGrabProvider\$MouseGrabRemover.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class

%cp FormMouseGrabProvider\$MouseGrab.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class

 %cp VTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class

 %cp SmartBar.class $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class

 %cp FLWTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class

%cp ClipboardErrorUtils.class $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class

%cp VTextField.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class

 %cp VTextField\$FormsPWAccess.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class

%cp VTextField\$NewlineDisplayFilter.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class

%cd $ORACLE_HOME/9863561/oracle/forms/ui/mdi
   
%cp MDIContainer.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class
 
%cp MDIContainer\$1.class                $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class

%cd $ORACLE_HOME/9863561/oracle/forms/ui/delegates
     
%cp VComponentDelegate.class $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class


     For ewt3.jar please follow these additional steps:

         i. Backup the Forms java subtree and extract the changed files
                   % cd $ORACLE_HOME/forms60/java
                   % cp -r oracle/ewt oracle/ewt.PREBUG9863561
                   % jar -xvf $ORACLE_HOME/9863561/ewt3.jar
                   % rm META-INF/MANIFEST.MF
                   % rmdir META-INF

         ii. Verify that the EWT version has been updated under the
                  $ORACLE_HOME/forms60/java directory.
                   For example:
                     % ls -la oracle/ewt | grep 3_4_49

         iii. Now regenerate jar files using adadmin.


5.  Make sure that you have set up custom certificates for JAR file signing.
    Run adadmin administration utility. Select the "Maintain Files" option
    and then the "Generate JAR Files" sub-option.

6.  Spot check that the JAR files have been generated by verifying the timestamp.

Restart the listeners

7.  Restart the Forms Server.

8. Restart the web listener serving Forms Applets (e.g. Apache or WebDB 2.2).

Steps for applying 9935935:

Refer Readme file after downloading

Steps for applying 6125732:

    % unzip p6125732_1012_LINUX.zip

  Set your current directory to the directory where the patch  is located:

    % cd 6125732
    % sh patch.sh

Steps for applying 5841985 which is a pre requisite for 6857221:

To apply the patch, unzip the PSE container file:

    % unzip p5841985_101220_Linux.zip

  Set your current directory to the directory where the patch
  is located:

    % cd 5841985

  Ensure that the directory containing the opatch script appears in your $PATH; then enter the following command:

    % opatch apply

Steps for applying 6857221:

make sure you run:
chmod +x $ORACLE_HOME/bin/genshlib
 Then proceed with applying the current patch.

 To apply the patch, unzip the PSE container file:

    % unzip p6857221_101220_LINUX.zip

  Set your current directory to the directory where the patch is located:

    % cd 6857221

  Ensure that the directory containing the opatch script appears in our $PATH; then enter the following command:

    % opatch apply



Steps for applying 5232832:

To apply the patch, set your current directory to the directory where the patch is located and then run the patch.sh script by entering the following Unix command:

 Unzip Patch file(From where u put zip file)

 % cd 5232832
 % sh patch.sh

Steps for applying: 8888184

To apply the patch, set your current directory to the directory where the patch is located and then run the patch.sh script by entering the following Unix command:

 Set $ORACLE_HOME to 8.0.6 Oracle Home

Unzip Patch file(From where u put zip file)
% cd 8888184
 % sh patch.sh
SPECIAL NOTE ::
  _ _ _ _ _ _ _ _

    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"

Steps for applying 9094950 to eliminate errors when clicked on form links from Notification Detail Page:

Pre-Requisites:


5903765 - 11i.ATG_PF.H.RUP6
3219567 - Patch 11i.TXK.B Technology Stack Minipack B (also in 11.5.10)
3264822 - Patch 11i.CAC.B
3261254 - Patch 11i.ALR.G
5161676 - MINIPACK 11I.AD.I.5
3036401 - Mini-Pack 11i.HZ.L
3263588 - Patch 11i.XDO.H
3264818 - Patch 11i.UMX.H
3218526 - Patch 11i.BNE.D
3263645 - Patch 11i.AK.G
4206794 - Patch 11i.FRM.H
3262486 - 11i.JTA.F
3261243 - Patch 11i.EC.G
2614213 - AME PATCH :DELIVERY OF GA AND RULE PRIORITY FUNCTIONALITY
3262159 - Patch 11i.FND.H
2819091 - Patch 11i.BNE.C
3412795 - ADSPLICE PATCH FOR XDO

Steps for applying 7121788 pre requisite for applying 7329300 and 7552880:



To apply the patch, unzip the PSE container file:

    % unzip p7121788_101230_Linux.zip

  Set your current directory to the directory where the patch is located:

    % cd 7121788

  Ensure that the directory containing the opatch script appears in your $PATH; then enter the following command:

    % opatch apply

chmod +x $ORACEL_HOME/bin/genshlib


Steps for applying 7329300:

Prior to the Install Phase, following checks are performed:

    - Conflicts with other patches

    - Conflicts with subset patches (existing patch is a subset of the patch
      being installed)


 If a conflict is found, please abort the install and contact Oracle Support Services.
  If a subset is found, please continue the install, as all fixes for thesubset patch are included in the patch being installed.  The subset patch(s) will be automatically rolled back prior to the installation of
  the new patch.

  If the Oracle inventory is not setup correctly this utility will fail.
  To check accessibility to the inventory you can use the command:

      > <ORACLE_HOME>/OPatch/opatch lsinventory

  To apply the patch, make sure the ORACLE_HOME environment variable is
  set to the correct Oracle Home which needs to be patched:

      > set ORACLE_HOME=<Oracle Home Path>

  Unzip the zip file you downloaded from metalink:Before applying this patch. Apply bug: 7121788

  chmod +x $ORACLE_HOME/bin/genshlib

      > unzip p7329300_101230_LINUX.zip

  To apply the patch, set your current directory to the directory where the
  patch is located:

      > cd 7329300

  Locate the directory where OPatch is installed, by default
  <ORACLE_HOME>/OPatch. Ensure that the directory containing the OPatch
  script appears in your PATH; then run opatch by entering the following
  command:

    > opatch apply


Steps for applying 6747939:

   Apply bug: 6086347 for both 32 and 64 bit

    % unzip p6086347_101220_Linux.zip

  Set your current directory to the directory where the patch is located:

    % cd 6086347

  Ensure that the directory containing the opatch script appears in
  your $PATH; then enter the following command:

    % opatch apply


   chmod +x $ORACLE_HOME/bin/genshlib
    % unzip p6747939_101220_Linux.zip

  Set your current directory to the directory where the patch is located:

    % cd 6747939

  Ensure that the directory containing the opatch script appears in your $PATH; then enter the following command:

    % opatch apply


Steps for applying 7552880:

chmod +x $ORACEL_HOME/bin/genshlib


  To apply the patch, unzip the PSE container file:
  p7552880_10123_LINUX.zip



Set your current directory to the directory where the patch is located:
    % cd 7552880

  Ensure that the directory containing the opatch script appears in  your $PATH; then enter the following command:

    % opatch apply

Steps for applying: 3830807

 You must login to your Linux machine as the Oracle software owner before
  applying this patch. Your setting for ORACLE_HOME must be the value for the
  Forms 6i 8.0.6 based ORACLE_HOME and you must have write previlages to this
  area.

  [1] To apply the patch, unzip the PSE container file:
        % unzip p3830807_8063_LINUX.zip

  [2] Set your current directory to the directory where the patch
      is located, eg:

        % cd 3830807

  [3] Add execute permission to the script supplied in this patch

        % chmod u+x patch.sh

  [4] Check the value of LD_LIBRARY_PATH.

      This patch will relink reports60 binaries.

      Reports has both link-time and run-time dependency with libjava.so
      so you need to include
         $ORACLE_HOME/network/jre11/lib/linux/native_threads    OR
         $ORACLE_HOME/network/jre11/lib/i686/native_threads
      in $LD_LIBRARY_PATH before running patch.sh

      Please check your files under $ORACLE_HOME/network/jre11/lib to see
      which one of the above is appropriate on your system. The same
      $LD_LIBRARY_PATH should be used at run-time.

  [5] Run the script supplied by this patch

        % ./patch.sh



  [6] Relink all Applications executables. In AD Administration, choose Relink Applications programs from the Generate Applications Files menu.

5) Relink Applications Executables on UNIX Platforms:
After applying the Oracle Developer 6i Patch on UNIX platforms, you must relink several Oracle E-Business Suite executables to include Developer patch changes. The executables are f60webmx, ar60run , ar60runb,ar60rund, and are all owned by FND
You can relink these executables by running adadmin
When the Main Menu appears select 'Maintain Applications Files Menu' and then select 'Relink Applications Program'
Answer the questions below as follows, in order to select the individual executables for relinking.
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 *
Note: In a multi-node configuration, not all these executables exist on each node. The list of executables will show those that do exist on the node you are currently running on, and only those should be entered to avoid errors
6) Verify Upgrade:
Verify that the fndforms.jar and fndewt.jar JAR files have been rebuilt by checking the timestamp for both files in the $OA_JAVA/oracle/apps/fnd/jar directory. If the timestamp is not current and the previous steps completed successfully, run the AD Administration Utility (adadmin), select Maintain Applications Files, then select Generate Product JAR Files. Do not force the regeneration of all JAR files. Again, verify that thefndforms.jar and fndewt.jar JAR files have been rebuilt by checking their timestamps again.
If you have applied Developer 6i Patch 6 or above, verify that the PL/SQL version installed is 8.0.6.3.x. You can run '$ORACLE_HOME/bin/f60gen help=y' on Unix platforms
7) Start the Forms, Reports, HTTP, Concurrent Manager Servers