Upgradation of Forms and Reports Oracle Home(10g) in R12

437878.1 Upgrading Forms and Reports 10g in Oracle Applications Release 12:
Steps:
1) Stop all services and take backup of DB and all code tree’s with inventory.
2) Let us Say Form and Report OH is /apps/test_inst/tech_stat/10.1.2
3) make sure that /apps/test_inst/tech_stat/10.1.2/oraInst.loc is pointing to the right inventory location (/var/opt/oracle/oraInst.loc)
4) Apply patch 4960210 through Runinstaller ..
5) export DISPLAY=local_host:0.0
6) cd Disk1 (If you unzip the patch, you will find it)
./runinstaller (or)
./runInstaller -invPtrLoc /apps/test_inst/tech_stat/10.1.2/oraInst.loc
7)check the installed products
click next
enter the full path of the products to be installed
/apps/test_inst/PATCHES/Disk1/stage/products.xml
select destination oracle home
apps_test_inst_apps_apps_tech_st_10_1_2
path
/apps/test_inst/apps/tech_st/10.1.2/
click next
select product to update Oracle Application Server Software Update
choose “Oracle Application Server and Developer Suite 10g R2 Software Update 10.1.2.2.0″
Supply the ias_admin default password ‘secret’ when it prompts.
8. run root.sh when it prompts.
9. post patch:
Update File Permissions
chmod ug+x $ORACLE_HOME/sso/bin/ssoreg.sh
10. Deploy new forms.ear file as per Note 397174.1
———————————————-
cp $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml_org_10152008
vi $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml
oc4jadmin
OC4J Administrator
OC4J Administrator
{903}7pt3cBV4AkL6tlFqYHmHdhHbrTpDcTS8
oc4jadmin
OC4J Administrator
OC4J Administrator
!welcome
$FND_TOP/bin/txkrun.pl -script=CfgOC4JApp
Enter Application name for re-deployment ? forms
Enter Oc4j Instance password for re-deployment ? welcome
Run Autoconfig ? No
NOTE: mention the password as welcome only.
restore back the xml files for previous password
cp $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml_org_10152008 $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml
Run autoconfig on all the nodes..
11.Apply patch 5861907
a) Shutdown the iAS instance.
b) Backup the $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml file.
c) Copy the patch oraclehomeproperties.xml to $ORACLE_HOME/inventory/ContentsXML.
12) Apply the below additional patches in same order
5841985
6002686
5985861
6146823
5637184
5466491
5841985
=======
export PATH=$PATH:/apps/test_inst/apps/tech_st/10.1.2/OPatch
export ORACLE_HOME=/apps/test_inst/apps/tech_st/10.1.2
make sure that /apps/tst_inst/apps/tech_st/10.1.2/oraInst.loc is pointing to the right inventory location
(/apps/local/TEST_INST/inst/apps/TEST_INST_coe-dev-17/admin/oraInventory)
If no inventory exists under $INST_TOP/admin then copy the central inventory to this location.
make sure that JRE_LIB_DIR in /apps/test_inst/apps/tech_st/10.1.2/sysman/lib/env_sysman.mk is pointing to the correct location
opatch lsinventory -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
Make sure the output is correct. This should not error out.
cd /apps/test_inst/PATCHES/5841985
opatch apply -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
6002686
=======
cd /apps/test_inst/PATCHES/6002686
opatch apply -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
5985861
=======
cd /apps/test_inst/PATCHES/5985861
opatch apply -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
6146823
=======
pre req
echo $OPATCH_PLATFORM_ID
export OPATCH_PLATFORM_ID=46
chmod +X $ORACLE_HOME/bin/genshlib
unzip p6146823_101220_Linux.zip
cd 6146823
sh apply.sh | tee 6146823_apply.log
Note: This will apply all these patches (5456500,5527100,5650051,5753922,5893392 and 5985840)
unset OPATCH_PLATFORM_ID
5637184
=======
cd /apps/test_inst/PATCHES/5637184
opatch apply -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
5466491
=======
cd /apps/test_inst/PATCHES/5466491
opatch apply -invPtrLoc /apps/test_inst/apps/tech_st/10.1.2/oraInst.loc
13. Apply interoper patch 5411711
using adpatch
14.Regenerate Jar files if the time stamp is not current in $OA_JAVA/oracle/apps/fnd/jar directory
Using adadmin
select Generate Applications Files > Generate Product JAR Files
(Do not force the regeneration of all JAR files)
15. Start services and verify the upgrade.
a) Log on to Applications as any user, launch any form, select About Applications from the Help menu,
and confirm that the Forms version (under Forms Server) is 10.1.2.2.0.
b) Execute following command,to display various component versions.
This command requires DISPLAY environment variable to be set correctly.
$ORACLE_HOME/bin/frmcmp help=y