Step by step process 11i to R12.1.1

Hi everybody, recently I have made complete iteration from fresh PROD 11i instance to R12.1.1 with database 11.2.0.2

I have used VMware for this iteration, the following step involved to achieve this upgrade from 11i to R12.1.1

OS – OEL 4.6
Memory 3GB
Instance 11i CU2
Database 9.2.0.6

My VMware installation has been running on P5 processor with 4GB memory under Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled procedure prior to this step. 

The following steps performed successfully to complete this hectic upgrade from 11i instance to R12.1.1

•      Upgrade 9.2.0.6 to 10.2.0.4

–     Patches applied before 10g upgrade are 5478710, 4676589, 4653225

–     Changed some of the OS kernel parameters

–     Created new oracle home directory

–     Installed 10gR1 (software only)

–     Installed 10gR1 companion CD

–     Installed 10g patch set 3 (10.2.0.4)

•      Configuration section for 10g

–     Created nls/data/9idata

–     Run the script cr9idata.pl

–     Copied environment file from 9i home to 10g home and made changes to reflect the directory structure of 10g home

–     Copied TNS_ADMIN directory from 9i to 10 home and made changes according to new home

–     Copies admin directory from 9i to 10g home and make necessary changes

–     Shutdown 9i database and listener

–     Startup 10g listener

–     Upgraded  9i to 10g using dbua from 10g home

•      Shutdown database and listener

•      Create temporary tablespace

•      Apply RDBMS Patches

•      Fix Korean Lexers

•      Run Adgrants.sql

•      Grant create procedure privilege on CTXSYS

•      Implement and run Autoconfig

•      Gather statistics for SYS schema

•      Recreate grants and synonym for apps

•      Restart application server process

•      Preparing for the Upgrade R12.1.1

–     Apply AD.I.6

–     Apply TUMS utility

–     Run AD preparation scripts

Backup database and applications

•      Startup 11i Instance

•      Check for Invalid Objects etc...

•      Create R12 application user

•      Create R12 Base folder

•      OS  Kernel setting etc

•      (Refer Metalink: 761564.1  - Oracle E-Business Suite Installation and Upgrade Notes R12.1.1 for Linux x86)

•      Installation of R12.1.1 applications

•      Enable maintenance mode in R12

•      Apply AD 12.1.1 upgrade driver (7461070)

•      Source the R12 Applications environment file

•      Run the Patch Application Assistant

•      Run the adgrants.sql

•      Apply patch

•      Re-Create grants and Synonyms

•      Compile APPS schema

•      Modify tablespace

•      Run the American English upgrade patch driver 6678700

•      Review patch history and timing

•      Install R12.1.1 again for configuration purpose

•       Startup / shutdown applications and database

•       Try with autoconfig in both tiers

•       Restart services

•       Upgrade 10.2.0.4 to 11.2.0.2

•      Patches applied before  11gR2 upgrade are 9062910, 8919489, 9868229, 10024524

•      Autoconfig latest version with 9852070 and 9738085

•      OS kernel parameters for 11gR2

•      Created new oracle home directory

•      Installed 11gR2 (software only)

•      Installed 11g Examples CD

•       Configuration section for 11gR2

•      Created nls/data/9idata

•      Run the script cr9idata.pl

•      Copied environment file from 10g home to 11g home and made changes to reflect the directory structure of 11g home

•      Copied TNS_ADMIN directory from 10g to 11g home and made changes according to new home

•      Copies admin directory from 10g to 11g home and make necessary changes

•      Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223

•      Shutdown 10g database and listener

•      Startup 11g listener

•      Run  DBUA

•      Perform post-install instructions

•      Run adgrants.sql

•      Grant create procedure privilege on CTXSYS

•      Set CTXSYS parameter

•      Validate Workflow ruleset

•      Implement and run AutoConfig in the new Oracle home on the database server node.

•      Gather statistics for SYS schema

•      Re-create grants and synonyms

•      Restart Applications server processes

•      Synchronize Workflow views

Very detailed step-by-step notes with screen shot also prepared along with this iteration, if anybody looking for this iteration material or VMware copy don’t forget to drop me mail.

Cheers!!!

Developer 6i Patch Set 19 upgrade with EBS 11i

As part of Extended support for 11i, upgrade Developer 6i patchset 19 is a must, this post will help to you do so. I am writing the  "step-by-step" upgrade instructions for linux box
*** All patches must be installed on all Application tier nodes
Stop all application processes by adstpall.sh
Apply the latest certified Developer 6i patch set 19 (6194129)
- Source applications environment (e.g source . /app/apps/ajiappl/APPSORA.env)
- Verify that $ORACLE_HOME is the 806_ORACLE_HOME
- Execute with applmgr user
$ unzip p6194129_60828_LINUX.zip
$ cd developer6i_patch19
$ ./patch_install.sh 2>&1 | tee patch_install_p19.log  
- Check patch_install_p19.log for any errors
- Execute the following to 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
$ cd $ORACLE_HOME/reports60/lib;     make -f ins_reports60w.mk install


Apply patch 9863561
Unzip Patch file p9863561_60828_GENERIC.zip
$cd 9863561
   Backup the Forms class files
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class         $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class.PRE_BUG9863561
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class.PRE_BUG9863561


Special Instructions
 cd $ORACLE_HOME/forms60/java
 jar -xvf f60all.jar oracle/forms/ui/VBean.class
cd $Patch_HOME/9863561/oracle/forms/engine
cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
cp Main\$1.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main\$1.class
 cp RunformBundle.class  $ORACLE_HOME/forms60/java/oracle/forms/engine/RunformBundle.class
cd $Patch_HOME/9863561/oracle/forms/handler
cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
cp BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class
cp CancelQueryDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/CancelQueryDialog.class
cp ComponentItem.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
cp FormCanvas.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class
cp FormWindow.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class
cp FormPrintableImpl.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormPrintableImpl.class
cp FormMenu.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/FormMenu.class
cp TextComponentItem.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/TextComponentItem.class
cp UICommon.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
cp UICommon\$DeferredItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$DeferredItem.class
cp UICommon\$1.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon\$1.class
cp FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class
cp IHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/IHandler.class
cp MenuInfo.class  $ORACLE_HOME/forms60/java/oracle/forms/handler/MenuInfo.class
cp HeavyBeanManager.class      $ORACLE_HOME/forms60/java/oracle/forms/handler/HeavyBeanManager.class
cd $Patch_HOME/9863561/oracle/forms/ui
cp VImage.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/VImage.class
cp FScalingImageCanvas.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FScalingImageCanvas.class
cp FormMouseGrabProvider.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider.class
cp FormMouseGrabProvider\$MouseGrabRemover.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrabRemover.class
cp FormMouseGrabProvider\$MouseGrab.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/FormMouseGrabProvider\$MouseGrab.class
cp VTextArea.class    $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextArea.class
cp SmartBar.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/SmartBar.class
cp FLWTextArea.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/FLWTextArea.class
cp ClipboardErrorUtils.class    $ORACLE_HOME/forms60/java/oracle/forms/ui/ClipboardErrorUtils.class
cp VTextField.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField.class
cp VTextField\$FormsPWAccess.class      $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$FormsPWAccess.class
cp VTextField\$NewlineDisplayFilter.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VTextField\$NewlineDisplayFilter.class
cd $Patch_HOME/9863561/oracle/forms/ui/mdi
cp MDIContainer.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer.class
cp MDIContainer\$1.class  $ORACLE_HOME/forms60/java/oracle/forms/ui/mdi/MDIContainer\$1.class
cd $Patch_HOME/9863561/oracle/forms/ui/delegates
cp VComponentDelegate.class   $ORACLE_HOME/forms60/java/oracle/forms/ui/delegates/VComponentDelegate.class

For ewt3.jar please follow these additional steps:
Backup the Forms java subtree and extract the changed files
  cd $ORACLE_HOME/forms60/java
  cp -r oracle/ewt oracle/ewt.PREBUG9863561
  jar -xvf $Patch_HOME/9863561/ewt3.jar
  rm META-INF/MANIFEST.MF
  rmdir META-INF
 Verify that the EWT version has been updated under the
cd $ORACLE_HOME/forms60/java
 ls -la oracle/ewt | grep 3_4_49
Now regenerate jar files using adadmin.
- Regenerate Jar files
  - Execute adadmin
  - Select the "Generate Applications Files menu" option
  - Select "Generate product JAR files"
  - Do you wish to force regeneration of all jar files? => Yes
  - Spot check that the JAR files have been generated by verifying the timestamp    
$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar

Apply patch 6125732 
- Unzip patch file + Apply patch
$ unzip p6125732_60828_LINUX.zip
$ cd 6125732
$ sh patch.sh

Apply patch 6857221 
- Unzip patch file + Apply patch
$ unzip p6857221_60828_LINUX.zip
$ cd 6857221
$ sh patch.sh
- Relink f60webmx for Oracle Applications
$ adrelink.sh force=y "fnd f60webmx"

Apply patch 5232832
Make a patch directory for this fix, and put your patch files in it:
$ cd $ORACLE_HOME
$ unzip p5232832_600_Linux.zip
$ cd 5232832
3) Copy your original librw60.a file in case you ever need it, get new file:
$ cd $ORACLE_HOME/lib
$ cp librw60.a librw60.a.PRE_5232832
$ ar -r librw60.a $Patch_HOME/5232832/rwffm.o
5) If you don't have genshlib in $ORACLE_HOME/bin directory then copy this file over there:
$ cp $Patch_HOME/5232832/genshlib $ORACLE_HOME/bin
$ chmod ug+x $ORACLE_HOME/bin/genshlib
6) Generate the shared libraries:
$ cd $ORACLE_HOME/lib
$ $ORACLE_HOME/bin/genshlib rw60 0

Relink the reports executables:
$ cd $ORACLE_HOME/reports60/lib
$ make -f ins_reports60w.mk install

Apply patch 8888124

 Unzip Patch file 8888124
$ cd 8888184
$ sh patch.sh

Apply patch 7329300
 Unzip Patch file
$ cd 7329300
$ sh patch.sh

Apply patch 6747939
 Unzip Patch file
$ cd 6747939
$ sh patch.sh
adrelink.sh force=y "fnd f60webmx"
Apply patch 7552880
 Unzip Patch file
$ cd 7552880
$ sh patch.sh
adrelink.sh force=y "fnd f60webmx"

If 11i.ATG_PF.H.RUP6 or above, you have to apply this ====
Apply patch 9094950
Unzip Patch file
$cd 9094950
  Adpatch using u9094950.drv
Relink applications executables
- Run adadmin
- Select (2) "Maintain Applications Files Menu"
- Select (1) "Relink Applications programs"
- List of product to link: fnd
- Generate specific executables …: Yes
- Relink with debug: No
- Enter executables to relink: f60webmx ar60run ar60runb ar60rund
==
Relink these executables by running adadmin
When the Main Menu appears select 'Maintain Applications Files Menu' and then select 'Relink Applications Program'
Answer the questions below as follows, in order to select the individual executables for relinking.
Enter list of products to link ('all' for all products)[all] : fnd
Generate specific executables for each selected product [No] ? y
Relink with debug information [No] ? n
(You will then be offered a list of executables that are available for relinking)
Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund *
* In a multi-node configuration, not all these executables exist on each node. The list of executables will show those that do exist on the node you are currently running on, and only those should be entered to avoid errors.

Apply patch  9935935 (Apps Interoperability)
- Unzip patch file
$ unzip p9935935_11i_GENERIC.zip
- Enable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (1) Enable Maintenance Mode
- apply patch with adpatch
- Disable maintenance mode: adadmin -> (5) Change Maintenance Mode -> (2) Disable Maintenance Mode
Verify your upgrade
- Check the timestamp for the following files:
$ cd $OA_JAVA/oracle/apps/fnd/jar
$ ll fndforms.jar fndewt.jar
If the timestamp is not current - run adadmin => Maintain Applications Files => Generate Product JAR Files.
Start all applications processes (adstrtall.sh)
- You can also verify your upgrade by login to forms responsibility -> Help -> About Oracle Applications
  You should see: Oracle Forms version: 6.0.8.28.0


Cheers!!!

R12 - Upgrade first patchset (11.2.0.2) for the 11gR2 Database

Upgrading an R12 Database to Oracle Database 11g Release 2 (11.2.0.2)

Recently Oracle had certified R12 database 11.2.0.2, the first patchset for the 11gR2 Database. I have successfully completed the installation. Have a look at it

Application Version : E-Business Suite Release 12.1.1
Database Version : 10.2.0.4
OS : Enterprise Linux AS Release 4.6
Current DB Home /u01/ajidb/10.2.0
New Home /u01/oracle/AJI/db/tech_st/11.2.0

I have followed these steps to achieve this.

Apply the following patches

1. 11g Release 2 interoperability patch for Release 12.1 (9062910)
2. 12.1 TXK Delta 3 patch (8919489)
3. 9868229
4. 10024524

AutoConfig Latest version with 9852070 and 9738085

Source the Application Tier environemnt file

. /u01/oracle/AJI/apps/apps_st/appl/APPSAJI_visr12.env

Enable maintenance mode

[appsR12@visr12 ~]$ adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=4

 export PATCH_TOP=~/upgradeR12db_11.2.0.2/

Apply 11g Release 2 interoperability patch for Release 12.1 (9062910)

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9062910.log patchtop=$PATCH_TOP/9062910 driver=u9062910.drv workers=4

apply Patch 12.1 TXK Delta 3 patch (8919489)
Step :1
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u8919489.log patchtop=$PATCH_TOP/8919489 driver=u8919489.drv workers=4
Step: 2
 1.1. On the Application Tier (as the APPLMGR user):
        1.1.1. Source the environment file.
        1.1.2. Create the appsutil.zip file by executing:

               $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
               This will create appsutil.zip under $INST_TOP/admin/out

   1.2. On the Database Tier (as the ORACLE user):
        1.2.1. Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME]
        1.2.2. cd [RDBMS ORACLE_HOME]
        1.2.3. unzip -o appsutil.zip
        1.2.4. Run AutoConfig by executing:
               [RDBMS_ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]/adautocfg.sh

apply Patch 9868229
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9868229.log patchtop=$PATCH_TOP/9868229 driver=u9868229.drv workers=4

apply Patch 10024524

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u10024524.log patchtop=$PATCH_TOP/10024524 driver=u10024524.drv workers=4

Apply Latest veriosn AutoConfig 9852070 and 9738085

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9738085.log patchtop=$PATCH_TOP/9738085 driver=u9738085.drv workers=4

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9852070.log patchtop=$PATCH_TOP/9852070 driver=u9852070.drv workers=4

1.1. On the Application Tier (as the APPLMGR user):
        1.1.1. Source the environment file.
        1.1.2. Create the appsutil.zip file by executing:

               $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
               This will create appsutil.zip under $INST_TOP/admin/out

   1.2. On the Database Tier (as the ORACLE user):
        1.2.1. Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME]
        1.2.2. cd [RDBMS ORACLE_HOME]
        1.2.3. unzip -o appsutil.zip
        1.2.4. Run AutoConfig by executing:
               [RDBMS_ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]/adautocfg.sh

Install the 11.2.0.2 software downloaded from http://updates.oracle.com/download/10098816.html

In the Installation Types window, select the option install the database software only.
The 11.2.0 Oracle home must be installed on the database server node in a different directory than the current Oracle home.
New Oracle Home /u01/oracle/AJI/db/tech_st/11.2.0

Also required to install Oracle Database 11g Products from the 11g Examples CD

Once installed  base 11.2.0 software, need to set the following in .bash_profile of oracle user
ORACLE_SID=AJI;export ORACLE_SID
ORACLE_BASE=/u01/oracle/AJI;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/db/tech_st/11.2.0;export ORACLE_HOME
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/odbc/lib;export LIBPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATHPERL5LIB=$ORACLE_HOME/perl/lib/5.10.0;export PERL5LIBPERL5LIB=$PERL5LIB:$ORACLE_HOME/perl/lib/site_perl/5.10.0;export PERL5LIB

Create nls/data/9idata directory

perl $ORACLE_HOME/nls/data/old/cr9idata.pl
This will create create the $ORACLE_HOME/nls/data/9idata directory.

ORA_NLS10=/u01/oracle/AJI/db/tech_st/11.2.0/nls/data/9idata;export ORA_NLS10

Apply any other additional 11.2.0.2 RDBMS patches

Also required to Apply the following patches:

4247037
10149223

Now you can do the Database Upgrade from 10.2.0.4.0 to 11.2.0.2.0:

Shut down Applications server processes and database listener

I have used Database Upgrade Assistant (DBUA) to do the upgradation from 10.2.0.4 to 11.2.0.2. This will take some times to complete based on your hardware.

Now required to upgrade Oracle E-Business Suite has only one statistics table, APPLSYS.FND_STATTAB. Please execute the following

Connect to SQL*Plus as sysadmin user and run the following line:
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB');

Next step is that modify initialization parameters for R12.
I have followed the Note: 396009.1, Database Initialization Parameter Settings for Oracle Applications Release 12

Perform patch post-install instructions

Run only the catmgdidcode.sql and utlrp.sql scripts for the post install instructions in patch 9218789.

After the Database Upgrade:

Start the new database listener
If the Oracle Net listener for the database instance in the new Oracle home has not been started, you must start it now. Since AutoConfig has not yet been implemented, start the listener manually.

Set the TNS_ADMIN environment variable to the directory where you created your listener.ora and tnsnames.ora file


Run adgrants.sql

Copy $APPL_TOP/admin/adgrants.sql from the administration server node to the database server node.
$ sqlplus "/as sysdba" @adgrants.sql APPS

Grant create procedure privilege on CTXSYS

Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node.
$ sqlplus apps/[APPS password] @adctxprv.sql [SYSTEM password] CTXSYS

Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:

$ sqlplus "/ as sysdba"
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

Validate Workflow ruleset
On the administration server node, use SQL*Plus to connect to the database as APPS and run the $FND_TOP/patch/115/sql/wfaqupfix.sql script using the following command:

$ sqlplus [APPS user]/[APPS password] @wfaqupfix.sql\
  [APPLSYS user] [APPS user]

Implement and run AutoConfig

Implement and run AutoConfig in the new Oracle home on the database server node. If the database listener of the new Oracle home is defined differently than the old Oracle home, you must also run AutoConfig on each application tier server node to update the system with the new listener.

Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node.
$ sqlplus "/ as sysdba"
SQL> alter system enable restricted session;
SQL> @adstats.sql
$ sqlplus "/ as sysdba"
SQL> alter system disable restricted session;
SQL> exit;

Re-create custom database links, if any.

Re-create grants and synonyms

Oracle Database 11g Release 2 (11.2) contains new functionality for grants and synonyms compared to previous database releases. As a result, you must re-create the grants and synonyms in the APPS schema. On the administration server node, as the owner of the Applications file system, run AD Administration and select the "Recreate grants and synonyms for APPS schema" task from the Maintain Applications Database Objects menu.


Restart Applications server processes

Restart all the Application tier server processes that you shut down previously. Remember that the Oracle Net listener for the database instance, as well as the database instance itself, need to be started in the 11.2 Oracle home. Users may return to the system.


Synchronize Workflow views
Log on to Oracle E-Business Suite with the "System Administrator" responsibility. Click Requests > Run > Single Request and the OK button. Enter the following parameters:

Request Name = Workflow Directory Services User/Role Validation
p_BatchSize = 10000
p_Check_Dangling = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No
Click "OK" and "Submit".

Please refer Interoperability Notes EBS R12 with Database 11gR2 (1058763.1)

Cheers!!!

Oracle E-Business Suite Release 12.1.3 RUP

I have successfully done upgradation of 12.1.3 RUP on my instance without having any problems. The details of my instance details are

Instance version: 12.1.2
Database version: 11.2.0

I have followed the Note 1080973.1 for upgrading from 12.1.2 to 12.1.3 release update pack.

The steps followed to upgrade for Apply Oracle E-Business Suite Release 12.1.3 are,

First of all disabling fast validation for PL/SQL recompilations using 

_disable_fast_validate=TRUE

using init parameter of database and restarted

Enable maintenance mode

adadmin menu_option=ENABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Applying required patches from 12.1.3.RUP

Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=$PATCH_TOP/9239089 driver=u9239089.drv workers=8

Use AutoPatch to apply Oracle E-Business Suite Release 12.1.3 Patch 9239090 and follow the instructions in the patch readme file.

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=$PATCH_TOP/9239090 driver=u9239090.drv workers=8

Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in the patch readme file.

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=$PATCH_TOP/9239095 driver=u9239095.drv workers=8

Post-Update Steps

Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)

Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=$PATCH_TOP/9817770 driver=u9817770.drv workers=8

Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=$PATCH_TOP/9966055 driver=u9966055.drv workers=8

Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level.

After upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3:

Application tier:

As the APPLMGR user, run the environment file for the current APPL_TOP.

. .$APPL_TOP/APPS$CONTEXT_NAME.env

Run AutoConfig on the APPL_TOP.

the little r12.1.3 upgrade guide: a guide to upgrading from Release 11i to Release 12 of Oracle's E-Business Suite of Applications (Softcover and Download Edition)

Run the admkappsutil.pl utility to create the file appsutil.zip in the $INST_TOP/admin/out directory.

perl $AD_TOP/bin/admkappsutil.pl

Database tier:

As the ORACLE user, run the environment file for the current ORACLE_HOME.

cd [RDBMS ORACLE_HOME]
. ./[RDBMS ORACLE_HOME]/$CONTEXT_NAME.env

Copy or FTP the appsutil.zip file to the [RDBMS ORACLE_HOME].

Uncompress appsutil.zip under the [RDBMS ORACLE_HOME].

cd [ORACLE_HOME]
unzip -o appsutil.zip

Run AutoConfig on the [RDBMS ORACLE_HOME]

Re-run adpreclone.pl on the database tier and the application tier.

Since updates included in Oracle E-Business Suite Release 12.1.3 were applied to the system, adpreclone must be run again to apply the updates to the clone directory structures that were used during cloning.

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

Disable Maintenance mode

adadmin menu_option=DISABLE_MAINT_MODE workers=4 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin_DISABLE_MAINT_MODE.log

Remove the fast validation for PL/SQL recompilations from init parameter and restarted the database.

Restarted the application Tiers

Cheers!!!

Apply Release 12.1.3 - R12.ATG_PF.B.delta.3

I have applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) in  the following steps

Instance 12.1.2
Database version 11.2.0.1
OS OEL 4.6

Before Applying Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) required to apply R12.AD.B.DELTA.3, Patch 9239089

unzip -o p9239089_R12.AD.B_R12_LINUX.zip
As oracle user Copy adgrants.sql from this patch/admin directory to $ORACLE_HOME/appsutil/admin.
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

Enable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8

Apply patch 9239089
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9239089.log patchtop=~/upgrade12.1.3/9239089 driver=u9239089.drv

Apply patch 8919491 (Applications Technology Release 12.1.3)
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=8919491.log patchtop=~/upgrade12.1.3/8919491 driver=u8919491.drv

Post-Install Steps

Apply post-install Oracle E-Business Suite Applications Technology patches
Apply the following mandatory patches:

9869602:R12.OWF.B, Patch 9869602
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9869602.log patchtop=~/upgrade12.1.3/9869602 driver=u9869602.drv

9888158:R12.FND.B, Patch 9888158
Need to shut down all Application tier services before performing the task
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9888158.log patchtop=~/upgrade12.1.3/9888158 driver=u9888158.drv

9583541:R12.TXK.B, Patch 9583541
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9583541.log patchtop=~/upgrade12.1.3/9583541 driver=u9583541.drv

9794874:R12.FND.B, Patch 9794874
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9794874.log patchtop=~/upgrade12.1.3/9794874 driver=u9794874.drv

9907182:R12.FND.B, Patch 9907182
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9907182.log patchtop=~/upgrade12.1.3/9907182 driver=u9907182.drv

9951283:R12.FND.B, Patch 9951283
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951283.log patchtop=~/upgrade12.1.3/9951283 driver=u9951283.drv

9951284:R12.FND.B, Patch 9951284
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951284.log patchtop=~/upgrade12.1.3/9951284 driver=u9951284.drv

Required to update database tier nodes to the Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) code level.
After that applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3), perform the following required post-install steps to update all database tier nodes to the AutoConfig code level that is provided by this release:

As the APPLMGR user, run the environment
$APPL_TOP/APPS$CONTEXT_NAME.env
$perl AD_TOP/bin/ admkappsutil.pl

Database tier:
As the oracle user, run the environment
Copy or FTP the appsutil.zip file to the . 
Uncompress appsutil.zip under the . 
Run AutoConfig on the .
Run AutoConfig on all nodes with an Appl_Top

Database tier and application tier:
Run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) were applied to the system, you must run the adpreclone again in order to apply the updates to the clone directory structures used during cloning.
perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

Apply Oracle E-Business Suite Applications Technology Online Help
Apply Patch 9400185
unzip -o p9400185_R12_GENERIC.zip
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9400185.log patchtop=~/upgrade12.1.3/9400185 driver=u9400185.drv

Disable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=DISABLE_MAINT_MODE workers=8

Startup all Application tier services

Cheers!!!