Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 19 October 2008

UPGRADING TO DEVELOPER 6i PATCHSET_19

Developer 6i Patch Set 19 upgrade with EBS 11i

.

*** All patches must be installed on all Application tier nodes

  1. Stop all application processes by adstpall.sh
  2. Apply the latest certified Developer 6i patch set 19 (6194129)
    - Source applications environment (e.g source .../testappl/APPSORA.env)
    - Verify that $ORACLE_HOME is the 806_ORACLE_HOME
    - Execute with applmgr user

$ unzip p6194129_60828_LINUX.zip
$ cd developer6i_patch19
$ ./patch_install.sh 2>&1 | tee patch_install_p19.log


  1. - Check patch_install_p19.log for any errors
    - Execute the following to 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
$ cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install


  1. Apply patch 7156414
    - Unzip patch file

$ unzip p7156414_60828_GENERIC.zip


  1. - Backup old files

$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG7156414
$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG7156414
$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class.PRE_BUG7156414
$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class.PRE_BUG7156414
$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class.PRE_BUG7156414
$ cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class.PRE_BUG7156414


  1. - Copy patch files to appropriate directories

$ cd [PATCH_TOP]/7156414/oracle/forms/handler
$ cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
$ cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
$ cp BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.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

$ cd [PATCH_TOP]/7156414/oracle/forms/ui
$ cp VBean.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class


  1. - Regenerate Jar files
    - Execute adadmin
    - Select the "Generate Applications Files menu" option
    - Select "Generate product JAR files"
    - Do you wish to force regeneration of all jar files? => Yes
    - Spot check that the JAR files have been generated by verifying the timestamp

$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar


  1. Apply patch 6125732
    - Unzip patch file + Apply patch

$ unzip p6125732_60828_LINUX.zip
$ cd 6125732
$ sh patch.sh


  1. Apply patch 6857221
    - Unzip patch file + Apply patch

$ unzip p6857221_60828_LINUX.zip
$ cd 6857221
$ sh patch.sh


  1. - Relink f60webmx for Oracle Applications

$ adrelink.sh force=y "fnd f60webmx"


  1. Apply patch 3830807
    - Unzip patch file + Apply patch

$ unzip p3830807_8063_LINUX.zip
$ cd 3830807
$ ./patch.sh


  1. - Relink all Applications executables:
    adadmin -> "Maintain Applications Files" -> "Relink Applications programs"
  2. Apply patch 4586086
    - Unzip patch file

$ unzip p4586086_600_LINUX.zip


  1. - Backup old file

$ cd $ORACLE_HOME/forms60/lib
$ mv env_forms60.mk env_forms60.mk.PRE_BUG4586086


  1. - Copy patch file to the appropriate directory

$ cd [PATCH_HOME]/bug4586086
$ cp env_forms60.mk $ORACLE_HOME/forms60/lib


  1. - Generate shared object + Relink f60webmx for apps

$ cd $ORACLE_HOME/forms60/lib
$ make -f cus_forms60w.mk libso_install
$ adrelink.sh force=y "fnd f60webmx"


  1. Relink applications executables
    - Run adadmin
    - Select (2) "Maintain Applications Files Menu"
    - Select (1) "Relink Applications programs"
    - List of product to link: fnd
    - Generate specific executables …: Yes
    - Relink with debug: No
    - Enter executables to relink: f60webmx ar60run ar60runb ar60rund
  2. Apply patch 7343387 (Apps Interoperability)
    - Unzip patch file

$ unzip p7343387_11i_GENERIC.zip


  1. - Enable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (1) Enable Maintenance Mode
    - apply patch with adpatch
    - Disable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (2) Disable Maintenance Mode
  2. Verify your upgrade
    - Check the timestamp for the following files:

$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar


  1. If the timestamp is not current - run adadmin => Maintain Applications Files => Generate Product JAR Files.
  2. Start all applications processes (adstrtall.sh)
    - You can also verify your upgrade by login to forms responsibility -> Help -> About Oracle Applications
    You should see: Oracle Forms version : 6.0.8.28.0




Related - Note 125767.1 - Upgrading Developer 6i with Oracle Applications 11i.

No comments: