EBS 11i to EBS R12.2 Upgrade High Level Steps:

11i to R12.2 Upgrade highlevel Steps:


1. Download Patch 7705743: TUMS for R12: TO DELIVER TUMS UTILITY FOR UPGRADES FROM 11I TO R12

2. Generate the tums script using adtums.sql (Location-        
        $AD_TOP/patch/115/sql)

3. Run adsetmmd.sql DISABLE
4. Download Patch 7429271: PATCH FOR 11I.AD.I.7
5. Stop 11i Application services
6. Apply Patch 7429271
7. Run adgrants.sql on db node
8. Run Auto config on both tier (DB and APPS)
9. Run the tums report again
10. Remove the oct psu patches
11. Apply the additional db patches given in the document
12. Download JRE patches for DB Tier



13. Convert the multiple org architecture by using adadmin
        adadmin --> Maintain Applications Database Entities menu (option 4) -->
        Convert to Multi-Org (option 6)

14. Run the Gather Schema Stats
15. Download the 12.2 startCD51 and configure the orainventory
inst_group=apps
inventory_loc=/u01/apps/R12_2/oraInventory

16. Start the Rapid Installation using the Upgrade option:
cd /stage/startCD/Disk1/rapidwiz
./rapidwiz
17. Confiugure ifile.ora
18. Modify context file
s_apps_jdbc_connect_descriptor
port, host and service name

19. Enable maintenance mode
@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE


20. Grant privileges and create PL/SQL profiler objects
SQL> @/u01/apps/R12_2/fs1/EBSapps/appl/admin/adgrants.sql APPS


21. Apply Patch 10117518
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt \
logfile=u10117518.log \
patchtop=$PATCH_HOME/10117518 \
driver=u10117518.drv \
workers=41 interactive=yes

22. Compile APPS schema
23. Apply all Cumulative Upgrade Patches (CUPs)
24. Run the American English upgrade patch driver
25. Disable Maintenance Mode
26. Finish the Upgrade
       Configure Release 12.2 E-Business Suite instance

        On as applmgr:
perl $AD_TOP/bin/admkappsutil.pl

        As Oracle user:

cd $ORACLE_HOME
mv appsutil appsutil.before122
cp /u01/apps/R12_2/fs1/inst/apps/apps_appsapps01/admin/out/appsutil.zip .
unzip appsutil.zip
rm -f appsutil.zip
27. Generate a new database context
           
cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl appsuser=apps appspasswd=APPS_PASSWORD

- Run AutoConfig on the database tier nodes (be sure that $CONTEXT_FILE is the same created in the last step
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=$CONTEXT_FILE appspass=APPS_PASSWORD

28. Run Autoconfig on Apps Tier
29. Run Rapid Install to configure the 12.2 EBS Instance
 
Root user:
        Verify the oracle Inventory file /etc/oraInst.loc that is usung the apps inventory:
        inst_group=appsapps
        inventory_loc=/u01/apps/R12_2/oraInventory

        Start the Rapid Installation using the Upgrade option:
        cd /stage/startCD/Disk1/rapidwiz
        ./rapidwiz
30.  Run "Online Patching Enablement: Readiness Report"
31. Enable Maintenance Mode



32. Modifications to CONTEXT_FILE in DB Nodes

On Database Nodes as oracle:

sqlplus apps/APPS_PASSWORD@apps
SQL> exec fnd_net_services.remove_system('apps');
SQL> commit;
SQL> exec fnd_conc_clone.setup_clean;
SQL> commit;
SQL> SELECT node_name ""Node Name"", node_mode ""Mode"", support_cp ""C"",
support_web ""W"", support_admin ""A"", support_forms ""F""
FROM APPS.FND_NODES;

- Modify the following paramter in $CONTEXT_FILE
s_virtual_hostname
s_display

- Run AutoConfig on second node(s):
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=$CONTEXT_FILE appspass=APPS_PASSWORD
Now Run AutoConfig on all nodes.

33. Modifications to CONTEXT_FILE in APPS Nodes
34. Start Services
35. Sanity Check