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
    Oracle R12 Upgrade from 11i & Database Versions
    Thursday, January 25, 2007
    Register for R12 upgrade
    As promised in past , here is some information on R12 Upgrade process. This Upgrade post revolves around Database version with Oracle Applications (E-Business Suite)

    Key points to note in Oracle Apps R12 upgrade from 11i
    -- R 12 upgrade process involve replacing 11i Tech stack (9iAS & 806) to Fusion Middleware (10g Application Server)
    -- Basic upgrade process involves Rapid Install & Autopatch
    -- Rapid Install involves installing new R12 tech stack as mentioned in first point
    -- Auto patch process involves upgrading E-Business Suite database compatible to R12 (Data Model)
    -- Final upgrade process is of updating data model using enhanced version of AutoPatch
    -- Minimum version from which you can upgrade to R12 is 11.5.7 and higher
    -- Minimum database version from which you can upgrade to R12 is 9i
    so if your database is still 8i or <>
    -- Database must be before or during upgrade process & prior to running AutoPatch which will upgrade datamodel to R12

    As per Oracle R12 Upgrade Documentation, Apps 11i Instance is classified in Two Categories based on Apps & DB Version
    Category 1 - 11.5.7, 11.5.8, 11.5.9 (CU1), 11.5.10 (CU1)
    Category 2 - 11.5.9 (CU2), 11.5.10 (CU2) or

    For Category 1 , database should be upgraded during R12 upgrade process (Downtime for R12 upgrade process will be more as this involve database upgrade as well) but for Category 2 Database can be upgraded before R12 upgrade .

    Why can't I upgrade database to before for category 1 ?
    This is because there is no Interoperability patch for above release & was supported for 11.5.9 (CU2) & 11.5.10(CU2) only . (Wish I could be on ;-) )

    What are advantages of Upgrading database to before R12 upgrade ?Downtime can be broken down to two small downtimes (one for Database upgrade another one for R12 upgrade) and can be achieved during weekends or long weekends (depending on your system & resources)

    Various upgrade paths (mainly 3) revolves around application version & database version (mainly on database version).

    Path A for apps R12 Upgrade :

    These are for instances where database is not 10.2 & DB is upgraded during R12 Upgrade
    Install the R12 Technology Stack and Oracle home
    Upgrade the Database to
    Perform Database Steps
    Complete the R12 upgrade

    Path B for apps R12 Upgrade :
    These are for instances & and database is 10.2
    Install the R12 Technology Stack and Oracle home
    Perform Database Steps
    Complete the R12 upgrade

    Path C for apps R12 Upgrade :
    These are for instances & and database is NOT 10.2, Here upgrade database first to 10.2.
    Upgrade database to
    Use 11i with DB & then in next downtime window
    Perform Database Steps
    Complete the R12 upgrade

    Related :
    For full Steps follow metalink Note # 403339.1 Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade

    Labels: ,

    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 @ 4:22 PM  
    • At 11:24 PM, Blogger fhasweh said…

      good post,

      drop me a line at my friend.


    • At 9:50 AM, Blogger bhavesh said…

      Before Upgrading to release 12, one has to upgrade to this correct?

    • At 10:32 AM, Blogger Atul Kumar said…

      No Bhavesh,
      As long as you are 11.5.7 or higher you can upgarde to R12

    • At 3:11 PM, Blogger Firas said…

      Hi Atul,

      Very useful information.
      Are you going to post any info regarding the installation of a fresh R12? Are there major differences between installation of prior versions and R12 ( Rapid install process, ..etc).


    • At 6:17 PM, Blogger Atul Kumar said…

      Yes I am going to put fresh install steps on R12 as son as I have my VMWare ready with Linux.

      There are few changes (enhancement) in install which I am going to cover after / before r12 install post


    • At 3:22 PM, Anonymous neto said…

      Hi Atul,
      There two major new features with release 12:
      - eBusiness Tax (old tax codes)
      - Subledger accounting (old AX)
      Can you tell us if the upgrade process take those two features?

    • At 6:47 AM, Blogger shekhar said…

      Hi Atul,
      We r in process of upgrading oracle apps to release 12.
      I want to know what are the major functional changes(in AR,AP,GL & HRMS modules) in terms of Business Processing between versions and R12.

      Oracle Apps DBA

    • At 6:52 AM, Blogger shekhar said…

      we are in the process of upgrading oracle apps to Release 12.
      I want to know what are the major changes in AP,AR,GL & HRMS modules in terms of Business Processing between versions & R12.

    • At 5:06 PM, Blogger m.Gobi said…

      hi Atul,

      i am a APPS DBA , We are planing to do the upgrade and migration from (hpux to itanium) from 11.5.7 to R12.
      can u please check the following steps and suggest me, i had earlier done the upgrade from with in hpux it works fine
      but in this case we need to migrate to itanium, and currently the migration note is not available for R12 , i had changed a
      small step to skip the migration , instead of installing the R12 with upgrade option on hpux , i am planning to install the
      R12 with upgrade option on the Itanium and then move the datafile to itanium and first complete the DB upgrade using the
      newli created 10g binaries from the R12 upgrade option installation.

      and then upgrading the application on the itanium it self

      below i had given the detailed step please suggest me whether this step will work ?

      Current Env

      server : hpux
      apps : 11.5.7
      Rdbms : 8.1.7

      Proposed Env
      server : hp Itanium
      apps : R12
      Rdbms : 10gR2 (10.2.0)

      11.5.7 to R12 upgrade and migrating the OS

      1. Perform the pre-request for upgrade on the source instance which is 11.5.7 on (hpux),

      I Pre-Update Tasks on the source hpux machine

      1. Apply 11i.AD.I on 11.5.7 on hpux

      2. Apply TUMS Patch

      3. Generating the TUMS Report

      4. Convert MultiOrg

      5. Run AD preparation scripts (required)

      6. Gather schema statistics for CBO (required)

      II Prepare for the Upgrade - perform the step on the new hp itanium server (target)

      Run Rapid Install (required) for R12 with upgrade option

      "start Rapid Install by typing rapidwiz

      >> select Upgrade to Oracle Applications Release 12. Click Next.

      >>> On the Select Upgrade Action screen, select Create Upgrade File System."

      And now we need to migrate the data files of the old 8.1.7 to the new server

      clarify me whether the datafiles of hpux and itanium are compactable with each other. so that
      a simple copy will work

      or any specific migration is needed

      And now upgrade the datafiles to 10g using the new 10g binaries created rapid install upgrade opt

      so now the database will be both upgraded and migrated to 10g on itanium server


      now we can perform the R12 applciation upgrade on the new itanium server

      Upgrading to Release 12

      1. Drop MRC schema (conditional) on the upgraded db

      2. Ensure that Maintenance Mode is enabled (required)

      3. Apply Release 12 AD minipack (required)

      4. Run the American English upgrade patch driver (required)

      IV Finish the Upgrade on the target itanium instance

      1.. Configure and start server processes (required)

      2. Run the Autoconfig on the dbTier

      3. Run Rapid Install with upgrade option

      please suggest that this will work or not, if works then check any other steps has to be added


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

      Kindly raise doubts/questions in forum at

    • At 10:35 AM, Anonymous Anonymous said…

      Hi Atul,
      I have a question about an apps upgrade. Im running on windows and planning to migrate to R12 on Linux 64 bit.

      Can I install R12 in Linux, use the export/import process from 11i to R12 and run the post upgrade steps to complete the upgrade? I appreciate if you can explain ..

      many many thanks in advance

    • At 4:13 PM, Anonymous Anonymous said…

      Hi Atul,

      Oracle Applications - 11.5.10
      Oracle Database -
      Application Modules - HRMS,Payroll,Benefits
      HRMS FP K RUP - RUP2

      we are planning to upgrade Ebiz suite to R12. As a prererq we are trying to convert our HCM environment to Multi-org.

      We dont have any operating unit definied in our environment, since we are not using any financial moduels.
      select count(*) from hr_operating_units;

      I know before running the multi org conversion on adadmin we need to assign the operating unit value to MO:Operating unit. But here we dont have an OU. Can you please share the experience how to do this

    • At 11:59 PM, Blogger Anupama said…

      Hi Atul,

      My client is running on Oracle Database 8i Enterprise version and Oracle apps 11.5.4.

      Now they are in process to upgrade to Oracle apps 12.

      We do have a lot of customization in this environment.

      Can you please guide me what are the step by step process to look for upgrade.


    • At 4:32 AM, Anonymous Anonymous said…

      Hi Atul,
      Can you explain me the steps for upgrading 11i with RAC to R12 with RAC.
      I am confused as I believe Rapid Install only ask for one DB node during laying down the file System, it may not ask RAc information for DB tier.
      Can you please elaborate on this?

    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