24 September 2010

Step by Step Upgradation on Forms & Reports 6i Patch 19 for Linux

Forms & Reports 6i Patch 19 for Linux

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

De-Installation Instructions

   1. Set your ORACLE_HOME.
   2. If you originally applied 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. Run the de-install script contained in the patch:

cd $ORACLE_HOME/developer6i_patch19

./patch_deinstall.sh 2>&1 | tee patch_deinstall_p19.log (ksh)

./patch_deinstall.sh | tee patch_deinstall_p19.log (csh)

   4. Check patch_deinstall_p19.log for errors.
   5. 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

No comments: