Apply the autoconfig patch as applmgr in concurrent & app tiers.
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3817226.log \
patchtop=/staging/patches/3817226 driver=u3817226.drv \
workers=6 interactive=yes options=novalidate
run the following to validate the technstack in app-tier as applmgr
/staging/patches/3594604/fnd/patch/115/bin/applxkValidateRollup.sh appspass=appdi01s
Apply the latest autoconfig template patch as applmgr in concurrent & app tiers.
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3594604.log \
patchtop=/staging/patches/3594604 driver=u3594604.drv \
workers=6 interactive=yes options=novalidate
Now build the autoconfig xml file file as applmgr in concurrent & app tiers.
adbldxml.sh tier=apps appsuser=APPS appspasswd=appdi01s
Now re-instantiate the the configuration files in the app tier with the autoconfig as applmgr
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/PROJ10_projdemo1.xml appspass=appdi01s
Now re-instantiate the configuration files in the conc and admin tier with the autoconfig as applmgr
$AD_TOP/bin/adconfig.sh contextfile=$APPL_TOP/admin/PROJ10_projdemo2.xml appspass=appdi01s
Generate the autoconfig appsutil.zip for the RDBMS ORACLE_HOME as applmgr in concurrent tier
perl $AD_TOP/bin/admkappsutil.pl
Move and unzip the appsutil to RDBMS ORACLE_HOME as oracle user in db tier
cp /appl7/u01/oraclep/PROJ10appl/admin/out/appsutil.zip /appl7/u01/oraclep/PROJ10db/9.2.0/
unzip appsutil.zip
Enable the autoconfig in the database tier as oracle user in db tier
$ORACLE_HOME/appsutil/bin/adbldxml.sh tier=db appsuser=apps appspasswd=appdi01s
Run the autoconfig in the database tier as oracle user in db tier
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROJ10_projdemo2.xml appspass=appdi01s
Run the required sys grants script as oracle user in db tier
cd $ORACLE_HOME
mkdir admin
cp /appl7/u01/oraclep/PROJ10appl/admin/adgrants.sql .
sqlplus /as sysdba
@adgrants.sql applsys;
Run adadmin and create a named snapshot as applmgr in db tier & app-tiers.
Apply the AD mini-pack I as applmgr
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3180816.log \
patchtop=/staging/patches/3180816 driver=u3180816.drv \
workers=6 interactive=yes options=novalidate
Apply the technology stack validation utility
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3971265.log \
patchtop=/staging/patches/3971265 driver=u3971265.drv \
workers=3 interactive=yes options=novalidate
Following developer upgrade takes 30 mins. We have to do this upgrade simuntatenously in projdemo1 and projdemo2 servers.
Upgrade the developer6i to patch set 16 in db and apptiers & apply the latest developer6i patches
cd $ORACLE_HOME
unzip /staging/patches/p3596539_600_AIX.zip
cd $ORACLE_HOME/developer6i_patch16
check $ORACLE_HOME/network/jre11/lib/aix/native_threads is in $LIBPATH and $LD_LIBRARY_PATH
./patch_install.sh 2>&1 tee patch_install_p16.log
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
cp $ORACLE_HOME/developer6i_patch16/bin/genshlib $ORACLE_HOME/bin
mkdir $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116
unzip /staging/patches/p3941497*
unzip /staging/patches/p3309083*
unzip /staging/patches/p3333818*
unzip /staging/patches/p2632838*
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/Bug3531106
cp genshlib $ORACLE_HOME/bin
chmod ug+x $ORACLE_HOME/bin/genshlib
cd $ORACLE_HOME/lib
cp libiffw.a libiffw.a.PRE_Bug3531106
cp libiwfw.a libiwfw.a.PRE_Bug3531106
cp libiffw.so.0 libiffw.so.0.PRE_Bug3531106
cp libiwfw.so.0 libiwfw.so.0.PRE_Bug3531106
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/Bug3531106
ar vt $ORACLE_HOME/lib/libiffw.a iftm.o
ar vt $ORACLE_HOME/lib/libiwfw.a iwbaeh.o
ar r $ORACLE_HOME/lib/libiffw.a iftm.o
ar r $ORACLE_HOME/lib/libiwfw.a iwbaeh.o
ar vt $ORACLE_HOME/lib/libiffw.a iftm.o
ar vt $ORACLE_HOME/lib/libiwfw.a iwbaeh.o
cd $ORACLE_HOME/lib
$ORACLE_HOME/bin/genshlib iffw 0
$ORACLE_HOME/bin/genshlib iwfw 0
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk install
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/Bug3534091
cp $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/Bug3534091/genshlib $ORACLE_HOME/bin/
cd $ORACLE_HOME/lib
cp libiwfw.a libiwfw.a.ORIG
cp libiwfw.so.0 libiwfw.so.0.ORIG
cp libixw.a libixw.a.ORIG
cp libixw.so.0 libixw.so.0.ORIG
cp libiffw.a libiffw.a.ORIG
cp libiffw.so.0 libiffw.so.0.ORIG
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/Bug3534091
ar vt $ORACLE_HOME/lib/libiwfw.a iwalx.o
ar vt $ORACLE_HOME/lib/libixw.a ixal.o
ar vt $ORACLE_HOME/lib/libiffw.a iftdlg.o
ar r $ORACLE_HOME/lib/libiwfw.a iwalx.o
ar r $ORACLE_HOME/lib/libixw.a ixal.o
ar r $ORACLE_HOME/lib/libiffw.a iftdlg.o
ar vt $ORACLE_HOME/lib/libiffw.a iftdlg.o
ar vt $ORACLE_HOME/lib/libiwfw.a iwalx.o
ar vt $ORACLE_HOME/lib/libixw.a ixal.o
cd $ORACLE_HOME/lib
$ORACLE_HOME/bin/genshlib iwfw 0
$ORACLE_HOME/bin/genshlib ixw 0
$ORACLE_HOME/bin/genshlib iffw 0
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/bug3941497
cd $ORACLE_HOME/forms60/java
cp -r oracle/forms oracle/forms.pre3941497
jar xvf $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/bug3941497/bug3941497.jar
ls -la oracle/forms/handler/ComponentItem.class
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/bug3530728
mkdir bug3530728cs bug3530728web
cp cs/icgc.o bug3530728cs
cp web/icgc.o bug3530728web
cp cs/iqf.o bug3530728cs
cp web/iqf.o bug3530728web
cp cs/ictse.o bug3530728cs
cp web/ictse.o bug3530728web
cp cs/iqfsc.o bug3530728cs
cp web/iqfsc.o bug3530728web
cp genshlib $ORACLE_HOME/bin
cd $ORACLE_HOME/lib
cp libic.a libic.a.ORI
cp libic.so libic.so.ORI
cp libic.so.0 libic.so.0.ORI
cp libicw.a libicw.a.ORI
cp libicw.so libicw.so.ORI
cp libicw.so.0 libicw.so.0.ORI
cp libiq.a libiq.a.ORI
cp libiq.so libiq.so.ORI
cp libiq.so.0 libiq.so.0.ORI
cp libiqw.a libiqw.a.ORI
cp libiqw.so libiqw.so.ORI
cp libiqw.so.0 libiqw.so.0.ORI
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/bug3530728/cs
ar rv $ORACLE_HOME/lib/libic.a icgc.o
ar rv $ORACLE_HOME/lib/libic.a ictse.o
ar rv $ORACLE_HOME/lib/libiq.a iqf.o
ar rv $ORACLE_HOME/lib/libiq.a iqfsc.o
cd $ORACLE_HOME/developer6i_patch16/patches_on_top_of_patch116/bug3530728/web
ar rv $ORACLE_HOME/lib/libicw.a icgc.o
ar rv $ORACLE_HOME/lib/libicw.a ictse.o
ar rv $ORACLE_HOME/lib/libiqw.a iqf.o
ar rv $ORACLE_HOME/lib/libiqw.a iqfsc.o
cd $ORACLE_HOME/lib
$ORACLE_HOME/bin/genshlib ic 0
$ORACLE_HOME/bin/genshlib icw 0
$ORACLE_HOME/bin/genshlib iq 0
$ORACLE_HOME/bin/genshlib iqw 0
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk install
Upgrade the J-Intiator to 1.3.x
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3930041.log \
patchtop=/staging/patches/3930041 driver=u3930041.drv \
workers=3 interactive=yes options=novalidate
cd /appl7/u01/oraclep/PROJ10comn/util/jinitiator
unzip /staging/patches/p3516136_131_GENERIC.zip
/staging/patches/3930041/fnd/patch/115/bin/jinit.sh no_jinit skippatch
Apply the forms6i i/o patch in database and app tiers with the following commands simuntaniously
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3392966.log \
patchtop=/staging/patches/3392966 driver=c3392966.drv \
workers=3 interactive=yes options=novalidate
Relink the following executables and force the regeneration of jarfiles from adadmin
f60webmx ar60run ar60runb ar60rund
Now check the time stamp of the following files.
increase the system tablespace to 9.5GB and setup the new tablespaces for 11.5.10
sqlplus system/manager /staging/patches/3180164/ad/patch/115/sql/adruncts.sql 15 min
apply the shipping pre-req patch
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3649470.log \
patchtop=/staging/patches/3649470 driver=u3649470.drv \
workers=3 interactive=yes options=novalidate
run the payables upgrade steps
prepare opm for update
apply the maintenance pack in the db-tier & app tiers.
adpatch defaultsfile=$APPL_TOP/admin/PROJ10/defaults.txt logfile=3140000.log \
patchtop=/staging/patches/3140000 driver=u3140000.drv \
workers=12 \
interactive=yes \
flags=hidepw \
options=novalidate,norevcache
Step By Step 11.5.8.->11.5.10 Apps Upgrade
.