Developer 6i Patch Patch 18*

Download the below Patches for developer 6i Patch set.



===========================================================

6502082 - done - AD.I.6
5985992 - done - TXK AUTOCONFIG ROLLUP PATCH Q (JUL/AUG 2007)

3453499 - already applied

4653225 - done - 11.5.10 INTEROP PATCH FOR 10GR2

==============================================================
4948577 - done - Developer 6i Patch Patch 18*

4888294 - done - Apps Interop Patch

3830807 - done - APPLICATIONS INTEROPERABILITY PATCH

4586086 - done - UNABLE TO RELINK LIBIFJAPI60.SO IN RHAS3.0

Download Additional Developer 6i Patches
5713544 - done
4261542 - done
5216496 - done
5753922 - done
6195758 - done
5938515 - done
================================================================

Apply this patch 5985992

From the location where this patch was unzipped, change directory
to fnd/patch/115/bin .

on Unix:

./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps


[applmgr@sys43 bin]$ ./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = /oracle/app/apps/testcomn/rgf/TEST_sys43/TXK/txkValidateRollup_Fri_Apr_11_21_21_24_2008_stdout.log
Reportfile /oracle/app/apps/testcomn/temp/txkValidateRollup.html generated successfully.




On the Application Tier (as the APPLMGR user):

Source the environment file.

Create the appsutil.zip file by executing:

$ADPERLPRG $AD_TOP/bin/admkappsutil.pl

This will create appsutil.zip in $APPL_TOP/admin/out .



On the Database Tier (as the ORACLE user):

Copy or FTP the appsutil.zip file to the


cd
unzip -o appsutil.zip

Run AutoConfig by executing:
/appsutil/scripts//
adautocfg.sh

==================================================================

Forms & Reports 6i Patch 18 for Linux



Set your ORACLE_HOME.
If you are going to apply this patch on top of an iAS install:
Set ORACLE_HOME to /6iserver
Prepend /6iserver/bin to the *beginning* of PATH
Prepend /6iserver/lib to the *beginning* of LD_LIBRARY_PATH
==========================================================
[applmgr@sys43 patch10g]$ export ORACLE_HOME=/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 patch10g]$ export LD_LIBRARY_PATH=/oracle/app/apps/testora/iAS/6iserver/lib:$LD_LIBRARY_PATH
[applmgr@sys43 patch10g]$ export PATH=/oracle/app/apps/testora/iAS/6iserver/bin:$PATH


[applmgr@sys43 6iserver]$ pwd
/oracle/app/apps/testora/iAS/6iserver
=============================================
Copy the files in this patch to your $ORACLE_HOME
[applmgr@sys43 developer6i_patch18]$ echo $ORACLE_HOME
/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 6iserver]$ unzip p4948577_600_LINUX.zip

ls -ltr
drwxr-xr-x 6 applmgr oinstall 4096 Jan 13 2006 developer6i_patch18

[applmgr@sys43 developer6i_patch18]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18
Run the install script contained in the patch:
cd $ORACLE_HOME/developer6i_patch18
./patch_install.sh 2>&1 | tee patch_install_p18.log (ksh)
./patch_install.sh |& tee patch_install_p18.log (csh)
================================================================
[applmgr@sys43 developer6i_patch18]$ ./patch_install.sh 2>&1 | tee patch_install_p18.log

Patch can be deinstalled by using /oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/patch_deinstall.sh script
===============================================================
Check patch_install_p18.log for errors
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

============================================================
[applmgr@sys43 developer6i_patch18]$ cd $ORACLE_HOME/procbuilder60/lib
[applmgr@sys43 lib]$ make -f ins_procbuilder.mk install

[applmgr@sys43 lib]$ cd $ORACLE_HOME/forms60/lib
[applmgr@sys43 lib]$ make -f ins_forms60w.mk install

[applmgr@sys43 lib]$ cd $ORACLE_HOME/graphics60/lib
[applmgr@sys43 lib]$ make -f ins_graphics60w.mk install

========================================================

Reports has both link-time and run-time dependency with libjava.so so you need to append either one of:
$ORACLE_HOME/network/jre11/lib/linux/native_threads
$ORACLE_HOME/network/jre11/lib/i686/native_threads
in $LD_LIBRARY_PATH before linking Reports.
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.
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install


======================================================
[applmgr@sys43 lib]$ cd $ORACLE_HOME/network/jre11/lib/i686/
[applmgr@sys43 i686]$ pwd
/oracle/app/apps/testora/iAS/6iserver/network/jre11/lib/i686
[applmgr@sys43 i686]$ ls -ls native_threads
total 4940
2552 -rwxr-xr-x 1 applmgr oinstall 2606042 Jun 20 2001 libawt.so
1376 -rwxr-xr-x 1 applmgr oinstall 1404357 Jun 20 2001 libjava.so
312 -rwxr-xr-x 1 applmgr oinstall 313893 Jun 20 2001 libjpeg_sun.so
164 -rwxr-xr-x 1 applmgr oinstall 160561 Jun 20 2001 libmath.so
88 -rwxr-xr-x 1 applmgr oinstall 84707 Jun 20 2001 libmmedia.so
156 -rwxr-xr-x 1 applmgr oinstall 151672 Jun 20 2001 libnet.so
88 -rwxr-xr-x 1 applmgr oinstall 85802 Jun 20 2001 libsysresource.so
204 -rwxr-xr-x 1 applmgr oinstall 203482 Jun 20 2001 libzip.so


[applmgr@sys43 i686]$ export LD_LIBRARY_PATH=$ORACLE_HOME/network/jre11/lib:$LD_LIBRARY_PATH
[applmgr@sys43 i686]$ cd $ORACLE_HOME/reports60/lib
[applmgr@sys43 lib]$ make -f ins_reports60w.mk install
=======================================================


[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/bin
-rwxr-xr-x 1 applmgr oinstall 2811 Dec 12 2005 genshlib

Copy this file genshlib to /oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp genshlib genshlib.bak_Apr12
[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp -b genshlib /oracle/app/apps/testora/iAS/6iserver/bin

============================================================


unzip p3830807_8063_LINUX.zip

cd 3830807

chmod u+x patch.sh

export LD_LIBRARY_PATH=/oracle/app/apps/testora/8.0.6/network/jre11/lib:$LD_LIBRARY_PATH

./patch.sh

================================================================================

cd $ORACLE_HOME
mkdir patch
cd patch

unzip p4586086_600_LINUX.zip


cd $ORACLE_HOME/forms60/lib

[applmgr@sys43 lib]$ ls -lrt env_forms60.mk
-rw-r--r-- 1 applmgr oinstall 28454 Dec 22 2005 env_forms60.mk

mv env_forms60.mk env_forms60.mk.PRE_BUG4586086


cp $ORACLE_HOME/patch/bug4586086/env_forms60.mk $ORACLE_HOME/forms60/lib

cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk libso_install


adrelink.sh force=y "fnd f60webmx"


=============================================================

cd 5713544
sh patch.sh

E.g. to relink f60webmx for Oracle Applications
adrelink.sh force=y "fnd f60webmx"

===============================================================


1. Stop your web listeners and Forms Server.

2. Make a patch directory within your 6i ORACLE_HOME and unzip

cd $ORACLE_HOME
[applmgr@sys43 6iserver]$ cp p4261542_600_GENERIC.zip $ORACLE_HOME
unzip p4261542_600_GENERIC.zip


[Part 2] Unzip the java class files and regenerate your JAR files

3. Backup the Forms class files, i.e.$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class

[applmgr@sys43 4261542]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ ls -ls AlertDialog.class
8 -rw-rw-r-- 1 applmgr oinstall 6673 Dec 21 2005 AlertDialog.class

[applmgr@sys43 handler]$ mv AlertDialog.class AlertDialog.class.bak

[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/engine/
[applmgr@sys43 engine]$ ls -ls Main.class
24 -rw-rw-r-- 1 applmgr oinstall 20545 Dec 21 2005 Main.class

[applmgr@sys43 engine]$ mv Main.class Main.class.bak




4. Inside folder 4261542 in step-2 has class files in oracle\forms\engine directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/engine

[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/engine
[applmgr@sys43 engine]$ cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/handler
[applmgr@sys43 handler]$ cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class


5. Generate JAR Files use adadmin

=================================

cd 5216496
sh patch.sh
=================================

[applmgr@sys43 6iserver]$ cp p6195758_60827_GENERIC.zip $ORACLE_HOME

[applmgr@sys43 6iserver]$ unzip p6195758_60827_GENERIC.zip

Backup the Forms class files,


[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv UICommon.class UICommon.class.bak
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv ComponentItem.class ComponentItem.class.bak

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


[applmgr@sys43 handler]$ cd $ORACLE_HOME/6195758/oracle/forms/handler
[applmgr@sys43 handler]$ cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
[applmgr@sys43 handler]$ cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class

====================================

cd 5938515
sh patch.sh

adrelink.sh force=y "fnd f60webmx"

========================================


cd 5753922
sh patch.sh

adrelink.sh force=y "fnd f60webmx"

=======================================


How to find forms version in patch set


$ORACLE_HOME/bin/f60gen help=y
Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)

Metalik id :125767.1

6.0.8.27.0 ===> Patch 18




Pre-Upgrade Step:


select banner from v$version;

SELECT product_group_id GroupID, product_group_name GroupName,release_name Release,product_group_type GroupType, argument1 FROM fnd_product_groups;

select count(*) from ad_bugs where bug_number = '5985992';


patch 4653225

Check the developer 6i Patch set.

Metalink Note 125767.1


Developer 6i patchset 18 (4948577)

1 comment:

Md. Hamidur Rahman Siddique said...

i need it.

I need the patch. do u have ?