Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database
  • Upgarde DB to
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management

  • We have moved to kindly check http://onlineAppsDBA.comin future
    Upgrade Oracle Applications to 11.5.10 CU 2
    Saturday, February 10, 2007
    Register for R12 upgrade
    This post is coming bit late & I know lot of you might be wondering when Oracle Apps R12 is in market why I am still writing on 11.5.10 Upgrade . Looking at quesries/doubts/document request by many of my readers in mail and in forum at I thought of covering entire 11.5.10 upgrade and its related docs in this post.
    This post will focus on which is oracle apps version 11.5.10 with CU 2 and patch number is 3480000 and related metalink note is 316365.1 . Minimum prereq AD patch for is AD.I.2 (4337683)

    Please Note:
    1. Patch 348000 ( is for 11.5.9 or lower version , If you are already on 11.5.10 and which to apply CU2 then this is not right patch for you.

    2. Steps mentioned here are for upgarding your apps version 11.5.X , This post doesn't cover upgrade procedure from 10.7 or 11.0.3

    3. If you have language other than US then you have to apply translated version of patch as well
    4. To reduce Upgrade downtime you can use staged APPL_TOP methodology mentioned in metalink note # 242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
    5. MRC schema is no more used from 11.5.10 onwards so you can drop MRC schema after upgrade so there is no need to maintain/synchronize MRC before or after 11.5.10 (CU2) upgrade

    6. requires database version 9.2.X and higher so you can upgarde to 9.2.X or 10.1.X before Upgarde . If you wish to upgrade to database 10.2.X then its better you do it after Update.

    7. Since I upgraded Financial & HRMS system so I will focus on steps related to these module but check optional steps mentioned in metalink note # 316365.1 , There are some additional steps for Windows which are not covered in this post

    8. To reduce patch downtime online help patches can be applied at later stage

    A) Pre Update task
    Compulsory Steps
    A.1 As mentioned above apply AD.I.2

    A.2 Update Autoconfig Tech Stack template files - Autoconfig uses Template files to build files specific to your applications

    A.3 Run Technology Validation Utility - This will test minimum tech stack components required to run (Tech Stack components are database, forms & reports, discoverer, Jinitiator, JDK, OJSP, JDBC, libraries for web & form server )

    A.4 Check OATM step mentioned in optional steps below. If you are not migrating to OATM mentioned above then prepare your table space to include new space requirement and new products . Read me of patch 3180164 will help you in creating additional tablespaces.

    Optional Steps
    A.5 Manual Update script - Run this script to find optional & compulsory manual steps you should do before upgarding (This script is specific to an Instance and vary instance to instance)

    A.6 Convert database to OATM (Earlier tablespace were based on OFA/Optimal Flexible Architecture where each product used to have one data & one index tablespaces so there were around 200+ tablespace which was difficult to manage which is now moved to ATM/Application Tablespace Model which is simple to manage & there are around 15 table spaces)

    A.7 This steps is only required if you are using audit trails & shadow tables name > 26 characters. For auditing purpose you may have auiting enabled for Instance which you want to upgrade then you must change shadow table names (I will cover more on auditing in oracle applications in coming post) before any new columns can be added . HRMS & Payroll customers with Auditing enabled focus on this. If you are not sure if any of your shadow table name is > 26 then use script FNDATCTBL.sql provided with patch 3872242

    A.8 If you are using any of product which require ilog planner libraries then apply related patches

    A.9 Unmerge of Contacts from TCA Process is long running process during upgrade process so if you wish to reduce downtime during upgrade
    then run this program before upgrade else it will be executed during upgrade

    Apply Maintenance Pack
    1. Shutdown application tier services

    2. If your database is not 9i upgrade it now

    3. Apply maintenance patch . This is unified driver

    4. Apply any additional languages patches (If your installation is multi language)

    Post Update task
    1. Apply Interoperability patch (If you upgraded database to 10g)

    2. Register new product , If you want to use any product installed as part of you have to manually license it via OAM

    3. Drop MRC schema (As mentioned above MRC schema is no longer required from

    4. If you are not using HRMS Pack I before upgrading to then you have to apply HR legislative updates

    5. There are product specific updates which you should carry out with your
    functional consultant.

    For complete list and extensive steps to upgrade follow metalink note # 316365.1


    We have moved to

    kindly check in future

    add to  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:23 PM  
    • At 8:00 AM, Anonymous Anonymous said…

      Note:242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime

      It refers a staged APPL_TOP, but doesn't mention how to stage COMMON_TOP and ORA_TOP (6i and Apache home).

      Any idea about this? Thanks.

    • At 9:08 AM, Blogger Atul Kumar said…

      Nice question anonymous, Yes you use entire application tier as staged (Think appl_top) in terms of application tier because when you apply apps patch using adpatch only appl_top changes (if you apply tech stack patches jinit, iAS or forms & report) . So you can stage entire application tier. At actual upgrade you just have to upgrade database tier and you need to copy application tier (appl_top, comn_top & iAS & 806)

    • At 6:37 PM, Blogger Bhetaal said…

      From what release of 11.5.x have you performed the upgrade? How long did it take to do the upgrade?

    • At 11:54 PM, Anonymous neto said…

      Hi Atul,
      What should we do if we want to upgrade from 11.0.3 ?

    • At 1:17 AM, Blogger Shailender said…


      I had upgrade from 11.5.9 to 11.5.10 after this i want to upgrade my db from 9.2.07 to Please let me know the steps for the upgrade of the db.


    • At 8:52 AM, Blogger Atul Kumar said…

      For any apps quesries/questions / doubts raise them in forum at

    • At 2:42 PM, Anonymous Anonymous said…

      hi Atul
      i had setup in 11.5.9 and we want 2 upgrade it in 11.5.10 and my database is so plz provide me steps to do upgrade or do i need to upgrade my database is also.


    • At 2:57 PM, Blogger Atul Kumar said…

      Check 316365.1 Oracle Applications Release Maintenance Pack Installation Instructions

      Upgrade of database is optional & not compulsory

    • At 7:22 AM, Anonymous A Shaik said…

      Dear Atul,

      Thanks for your information you have provided. We have a similar scneario but with 11.0.3 Applications. I need your help and opinion, which will be greatly appreciated.

      Our Company is on 11.0.3/8.0.5 Version and on Digital UNIX V4.0F. We want to upgrade the applications to DB and move it to Red Hat Linux AS 4.

      I want to know during this upgrade process when we have to move the application to Linux either in the mid or after the upgrade. What is the best procedure.
      Your inputs regarding this higly appreciated.


    • At 12:46 PM, Blogger Atul Kumar said…

      Hi AS,
      I am have not upgarded/migrated from 11.0.3 so you might have to contact Oracle Support for this information

    • At 6:09 AM, Blogger fouadbandarkar said…


      Please provide me the steps for Upgrading Oracle Applications 11.0.3 on Compaq Alpha to Oracle Applications on Linux 4i.

      Thanks and Regards,

    • At 7:22 PM, Blogger Atul Kumar said…

      Hi Foud, As I have not worked on 11.0.3 I may not be able to help you. Kindly check with Oracle Support

    • At 9:54 AM, Anonymous Anonymous said…

      Mr. Atul,
      i am stuck with below issue while upgrading to 11.5.10.
      i already installed jdk 1.4
      when i type
      which java it is showing the path correctly.
      java -version command also showing version 1.4.
      please help.

      cd $FND_TOP/patch/115/bin jdktop=/usr/java/j2sdk1.4.2_15/bin
      Using Application context file /d00/oracle/siixappl/admin/SIIX_ebsiprd.xml...
      Sourcing /d00/oracle/siixappl/SIIX_ebsiprd.env APPL_TOP environment file.....
      A valid JDK installation directory is required - verify that
      exists and is readable and restart

    • At 9:55 AM, Anonymous Anonymous said…

      Mr. Atul,
      i am stuck with below issue while upgrading to 11.5.10.
      i already installed jdk 1.4
      when i type
      which java it is showing the path correctly.
      java -version command also showing version 1.4.
      please help.

      cd $FND_TOP/patch/115/bin jdktop=/usr/java/j2sdk1.4.2_15/bin
      Using Application context file /d00/oracle/siixappl/admin/SIIX_ebsiprd.xml...
      Sourcing /d00/oracle/siixappl/SIIX_ebsiprd.env APPL_TOP environment file.....
      A valid JDK installation directory is required - verify that
      exists and is readable and restart

    • At 8:20 PM, Blogger Atul Kumar said…

      Kindly raise any issues in forum at

    • At 12:19 AM, Anonymous Michael said…

      Thanks for your nice post!

    • At 3:13 AM, Anonymous Anonymous said…

      hi Atul,

      We are on 11.5.9 and planning for upgrade.

      The workflow is highly customized and with imodules.

      What preliminary steps to be taken to take care of the workflow before/after upgrade.


    • At 7:53 AM, Blogger koti said…

      hi this is kiran i want 11.5.9 to 11.5.10 upgradation steps
      and also 11.5.10 , differences.

    • At 3:31 AM, Blogger jen said…

      hi Sir!

      Is it also best to upgrade our linux machine? we will also upgrade from 11.5.9 to 11.5.10 with database.


      \\ Jen

    • At 6:19 PM, Blogger pavan kumar said…

      hi Atul

      iam upgrading the applications 11.5.9 to
      while aim applying maintenance pack
      3480000 i have hang up with my workers invirupg2.sql,ozfaelne.sql and bom10u03.sql this scrips are running from 10 to 15 hours still it was running can u please suggest me ..

    Post a Comment
    << Home
    About Me

    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Add On

    Add to Technorati Favorites



    Add to Google


    Add to My AOL


    Subscribe in Bloglines


    Subscribe in NewsGator Online

    Powered by

    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Copyright © 2006 All rights reserved Presented by Atul Kumar