OS: AIX Version 5.3
DB: 10g (10.2.0.1.0)
APPS: 11i (11.5.10.2)
1.0.0 Apply AD.I.6 Minipack
Apply patch 6502082 using adpatch
Instructions
1. Before Applying This 5985992 Patch
Perform the steps listed below:
1.2 From the location where this patch was unzipped, change directory to fnd/patch/115/bin .
1.3 Run the Validation script as follows:
------------------------------------------
NOTE:
Ensure that your current working directory is
[patch unzipped location]/fnd/patch/115/bin
------------------------------------------ on Unix:
./txkprepatchcheck.pl -script=ValidateRollup
-outfile=$APPLTMP/txkValidateRollup.html
-appspass=
1.4 Review the report generated by the validation script
2. How To Apply This Patch
This patch contains the following driver file to be applied with
AutoPatch: u5985992.drv (This is the unified driver).
2.1 After Applying this Patch Run Autoconfig
2.2 Update the RDBMS ORACLE_HOME file system with the AutoConfig files by
performing the following steps:
2.2.1 On the Application Tier (as the APPLMGR user):
2.2.1.1 Source the environment file.
2.2.1.2 Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip in $APPL_TOP/admin/out .
2.2.2 On the Database Tier (as the ORACLE user):
2.2.2.1 Copy or FTP the appsutil.zip file to the
2.2.2.2 cd
2.2.2.3 unzip -o appsutil.zip
2.2.2.4 Run AutoConfig by executing:
2.3 Apply 11.5.10 INTEROP PATCH FOR 10GR2
Apply patch 4653225 using adpatch
Apply patch 4948577(patchset 18) For Oracle Developer
1.1 Apply Developer patchset 18
1. Apply patch 4948577 to 8.0.6 Home on app and admin tiers
Note:
Before moving ahead with patch application ensure following:
All processes, running out of the ORACLE_HOME being patched, are shutdown cleanly.
$PATH includes $ORACLE_HOME/bin and also it points to locations where following executables are present: make, ar, ld, and nm.
$ORACLE_HOME should point to 806 Oracle Home.
$ORACLE_HOME and $JDK_HOME environment variables are set.
Set JDK_HOME to the JDK directory (JDK 1.3.1 or above).
For example, if you have JDK version 1.3.1 installed under /usr/local/packages/jdk1.3.1 directory, then set JDK_HOME to /usr/local/packages/jdk1.3.1/jdk
Make sure to backup the current /etc/oraInst.loc file.
Point the inventory location to the correct path in the oraInst.loc with the directory having the required inventory information
Reference:
Unzip the patch in 8.0.6 $ORACLE_HOME. .
Run the install script contained in the patch:
cd $ORACLE_HOME/developer6i_patch18
./patch_install.sh 2>&1 tee patch_install_p18.log
Check patch_install_p18.log for errors.
2. Relink Procedure Builder
Reference:
cd $ORACLE_HOME/procbuilder60/lib;
make -f ins_procbuilder.mk install
3. Relink Forms
Reference:
cd $ORACLE_HOME/forms60/lib;
make -f ins_forms60w.mk install
4. Relink Graphics
Reference:
cd $ORACLE_HOME/graphics60/lib;
make -f ins_graphics60w.mk install
5. Relink Reports
Reference:
Reports has both link-time and run-time dependency with libjava.so, so you need to append $ORACLE_HOME/network/jre11/lib/sparc/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
1.2 Install Additional patches for Developer6i patchset 18
1.2.1 Apply patch 5713544
Unzip the patch. Change the directory to where the patch was unzipped.
cd 5713544
If you don't have genshlib in $ORACLE_HOME/bin directory then copy this file over there.
cp genshlib $ORACLE_HOME/bin
sh patch.sh
1.2.2 Apply patch 4261542
Copy the patch file to 6i Oracle Home
cd $ORACLE_HOME
Unzip the patch
Backup the Forms class files, i.e.$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
$ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/engine
%cd $ORACLE_HOME/4261542/oracle/forms/engine
%cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
%cd $ORACLE_HOME/4261542/oracle/forms/handler
%cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
1.2.3 Apply patch 5216496
Copy the zip in $ORACLE_HOME and Unzip the zip file. This will unzip into 5216496 folder.
• If you don't have genshlib in $ORACLE_HOME/bin directory then copy this file over there.
cp genshlib $ORACLE_HOME/bin
• Copy your original libraries in case you ever need it:
cd $ORACLE_HOME/lib
cp libiff.a libiff.a.ORG
cp libiff.so.0 libiff.so.0.ORG
cp libiffw.a libiffw.a.ORG
cp libiffw.so.0 libiffw.so.0.ORG
• Archive .o into iwf and iwfw library
cd $ORACLE_HOME/5216496/opt
ar -rv $ORACLE_HOME/lib/libiff.a ifzprs.o
cd $ORACLE_HOME/5216496/optweb
ar -rv $ORACLE_HOME/lib/libiffw.a ifzprs.o
• Generate All *.so's
cd $ORACLE_HOME/lib
$ORACLE_HOME/bin/genshlib iffw 0
$ORACLE_HOME/bin/genshlib iff 0
• Generate forms executables
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk install
1.2.4 Apply patch 5753922
Unzip Patch file into 6i Oracle Home
cd 5753922
sh patch.sh
1.2.5 Apply patch 6195758
Unzip the patch into 6i Oracle Home.
cd $ORACLE_HOME
unzip p6195758_600_GENERIC.zip
Unzip the java class files and regenerate your JAR files
Backup the Forms class files,
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG6195758
%cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
$ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG6195758
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
cd $ORACLE_HOME/6195758/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
1.2.6 Apply Patch 5938515
Unzip Patch file in 6i Oracle Home
cd 5938515
sh patch.sh
1.3 Apply Forms Interoperability Patch
Apply patch 4888294 using adpatch
1.3.1 APPLICATIONS INTEROPERABILITY PATCH
Apply patch 3830807 using adpatch
1.3.2 UNABLE TO RELINK LIBIFJAPI60.SO IN RHAS3.0
Apply patch 4586086 using adpatch
1.4 Generate JAR Files
Generate JAR files using adadmin
1.5 Apply Security Fixes to Developer 6i
1.5.1 Apply patch 5687261 to forms server
Unzip patch in 6i oracle home
cd 5687261
sh patch.sh 2>&1 tee patch.log
Please inspect patch.log for any errors
1.5.2 Apply patch 5686997
Unzip the patch in 6i Oracle Home
cd 5686997
sh patch.sh 2>&1 tee patch.log
Please inspect patch.log for any errors.
1.5.3 Apply patch 5078711
• Make sure that all processes running from the ORACLE_HOME being patched are shutdown before installing this patch.
• Ensure that ORACLE_HOME is set.
• Set JDK_HOME to the JDK directory (JDK 1.3.1 or later).
• Ensure $ORACLE_HOME/bin is included in your PATH environment variable, and also ensure that the following executables must be present in the $PATH: make, ar, ld, nm
• Set your current directory to the directory where the patch is located and then run the installcpu.sh script by entering the following UNIX command:
sh installcpu.sh
Inspect the following install log file for any errors:
installcpu.sh log file $ORACLE_HOME/cpu/5078711/install
***********************************
Apply ATG_PF RUP6
Apply Technology Stack Patch
CPUApr2008 6831988 EBS11i:Technology Stack (TXK) Components For Critical Patch Update April 2008
1.6 Apply Pre-Req Patches
1.6.1 Apply AD.I.6 Minipack
Apply patch 6502082 using adpatch
1.6.2 Post AD.I.6 patch Tasks
1.6.2.1 Grant privileges and create PL/SQL profiler objects
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
• Create $ORACLE_HOME/appsutil/admin on the database server.
• Copy adgrants.sql from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin.
• Set the environment to point to ORACLE_HOME on the database server.
• Run following commands
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
1.6.2.2 Run Adconfig
Run adconfig to instantiate the templates used by AD Utilities
1.6.2.3 Perform Adadmin Tasks
• Regenerate JAR files using adadmin.
• Update current view snapshot
1.7 Apply ATG_PF RUP6
1.7.1 Apply pre-req patches
Apply following pre-req patches
1.7.1.1 Apply patch 5989593
Apply patch using adpatch
Create $ORACLE_HOME/appsutil/admin on the database server.
Copy adgrants.sql (UNIX) from the patchtop(5989593)/admin directory to
$ORACLE_HOME/appsutil/admin.
Set the environment to point to ORACLE_HOME on the database server.
Use SQL*Plus to run the script:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
1.7.1.2 Apply patch 4291053
Apply patch using adpatch
Run adadmin and
Compile APPS Schema
Compile Flexfield data in AOL Tables
1.7.1.3 Apply patch 3218526 – BNE.D
Apply patch using adpatch
Run adadmin and
Compile APPS Schema
Compile Flexfield data in AOL Tables
Perform following post patch steps
Once you have successfully applied minipack 11i.BNE.D, you must complete these additional product-specific tasks. This section describes these tasks.
The Web server must be restarted after the successful application of the Patch Set.
Review the list of profile options in the Implementation and User Documentation specified in the Additional Product Information section.
Review the seeded form functions, menu, and responsibility in the Implementation and User Documentation specified in the Additional Product Information section. Give Oracle Application Users access to Web ADI form functions. Simply assigning the seeded Desktop Integration Responsibility to a user can do this. See the Oracle Applications System Administrator's Guide for more information on giving users access to form functions on the Personal Home Page.
If your site is using the General Ledger - Journals Integrator:
o Make sure the GL: Set of Books Name profile option is set for all user profiles.
o Assure that at least one of the following form functions is associated with the menu that contains the form function they use to access Web ADI: Enter Budget Journals, Enter Journals, Enter Encumbrances, Import Journals, and Create Document.
After BNE.D has been applied, then apply the latest ATG RUP patchset - currently that is ATG RUP6. All of the Web ADI fixes that have been made on top of BNE.D have been rolled up in the the latest ATG RUP patchset. In order to get these latest updates, you should apply the latest ATG RUP patch 6. Reference Patch 5903765 11i.ATG_PF.H. RUP6 and Note 444524.1 for more information
Sites using Internal Controls Manager need to apply Patch 4483674 after applying BNE.D Minipack.
Sites using Financial Intelligence need to apply Patch 3857216 after applying BNE.D Minipack.
Sites using HRMS need to apply Patch 4199321 after applying BNE.D Minipack. Please consult the HRMS Metalink page
1.7.1.4 Apply patch 3761838 – FRM.G
1.7.1.5 Apply patch 4206794 – FRM.H
Apply patch 4206794 using adpatch
Perform following adadmin task after successful application of patch
• Generate message files
• Compile APPS schema(s)
• Compile flexfield data
• Recreate grants and synonyms for APPS schema(s)
• Gather schema statistics
1.7.2 Run the technology stack validation utility
• Source the environment logged in as applmgr
• Ensure that APPLRGF environment is set, if not then set it to the value of APPLTMP
• From the location where this patch(ATG_PF>RUP6) was unzipped, change directory to fnd/patch/115/bin.
• Run the tech stack validation utility as follows:
• ./txkprepatchcheck.pl -script=ValidateRollup
-outfile=$APPLTMP/txkValidateRollup.html
-appspass=
• Check the report filegenerated by this utility for any actions required to perform
1.7.3 Apply ATG_PF.RUP6 patch using adpatch.
Apply patch 5903765 using adpatch
1.7.4 Post ATG_PF.RUP6 steps
Apply following patches using adpatch
3865683
Complete Adadmin Tasks
Complete following adadmin tasks
• Generate message files
• Compile apps schema
• Compile flexfields
• Compile menus
• Run “Gather Schema Statistics” concurrent program
