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 Apps 11i with Database to 10g R2
    Thursday, August 31, 2006
    Register for R12 upgrade
    This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you have not seen previous update on overview of DB upgrade for Apps 11i you can Click Here

    Upgrading a Oracle Apps 11i Database is Upgrading Usual 10g Database + some additional steps which are specific to Oracle Applications 11i. So if you have already done a database Upgrade you simply need to follow metalink note # 362203.1

    Database upgrade is Two Step process: First Upgrade your software i.e. your files under Database $ORACLE_HOME to provide new executables .
    How to upgrade software from 8i, 9i or 10.1 to 10.2 just go to directory where you have downloaded database & go to Disk1 & execute ./runInstaller . This will start Universal Installer & then you have to choose different Oracle_Home to install 10.2 software . (Check oracle database upgrade guide at ) After software Installation you have to install software for companion CD in above ORACLE_HOME i.e. one for 10.2 only.
    Why I need to Install companion CD separately, I never did it earlier ? Oracle recently started shipping Ultra Search as part of companion CD which earlier used to come with database software only Apply patch 4547817 on top of base release. For instructions on How to apply patcheset check ReadMe of patch & you again have to apply it via OUI Upgrade database Metadata Once software is upgraded you have to upgrade Metadata and option you have is via executing sql's mentioned in upgrade guide or dbua ( database upgarde assistance tool ). Oracle Universal Installer while upgrading software also prompt you to upgrade database while upgrade software. Depending on your comfort you can choose method to upgrade database. I prefer using manual method i.e. via upgrade sql files. Now apart from upgrading database there are some pre upgrade & post upgrade steps specific to oracle applications 11i & follow them as mentioned in metalink note # 362203.1 some are option & some are compulsory . I want to discuss Native Compilation in Oracle 10 g database but because of time constraints I will discuss it some other time.

    From now onwards slowly I will move on Advanced Apps DBA tasks like

    Adding extra Node in Applications 11i
    Implementing SSL with Apps 11i webserver
    Disaster Recovery Implementation
    Configuring 10g Application Server with E-Business Suite 11i
    Don't forget to leave comments and if you have any doubts in Apps 11i mail me at or post here as comment.

    Atul Kumar
    Oracle Apps DBA

    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 @ 6:39 PM  
    • At 8:09 PM, Anonymous Anonymous said…

      atul before going to advanced apps dba,
      can u tell about Workflow

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

      I Appreciate your feedback & I'll take next few topics on workflow with Apps 11i before moving to Advanced DBA topics .

      I'll happy if you put your name (Though you can still write as anonymous if you wish )


    • At 7:23 AM, Blogger Sandeep said…

      Hi Atul,

      This is a good blog !!

      I am having similar ones I started recently

      mainly for Apps DBAs

      I would like your comments on :


    • At 7:42 AM, Blogger Atul Kumar said…

      Thanks for informing about your blog but its not updated regularly.


    • At 9:10 AM, Anonymous Anonymous said…

      Hi Atul,
      I really enjoy your blog and like to read more about apps dba. I have one suggestion which i think might be helpful. It seems like you are touching too many topics and it might be harder for u to keep updated, so i would suggest to start with one topic and finish it to the end and take on next topic. For example, if u start load balancer finish it and may be move to concurrent manager.


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

      Sudip ,
      Thanks a lot for your feedback.

      I can understand that you want to read from start till end about a topic but sometime its boring for me as well for readers too much on same topic .

      I have noticed that I loose interest if I write continuously on single topic for 3-4 days.
      I tried experimenting writing on same topic CPU patches on 9 & 10th Oct.

      So what I have done is listed related topic in order in left menu bar .

      Keep posting feedback & comments to improve this blog .


    • At 11:38 AM, Anonymous Harshita said…

      Hi Guys,
      Talking about Workflows, have you implemented IMAP4?
      We have recently upgraded 11.5.7 to on 10g (OS redhat).
      Incase you have implemented IMAP4, please do let me know about your experiences.

    • At 11:42 AM, Blogger Atul Kumar said…

      I think IMAP4 is requirement for Workflow Notification Mailer .

      Are you looking for implementation Doc or Just Experience of implementing it .


    • At 10:09 PM, Anonymous Harshita said…

      Hi Atul,
      Thanks for your quick response.
      I want to know your exp. I have the implementation docs.Just want to foresee the problems faced and the solutions.

    • At 7:57 AM, Blogger Atul Kumar said…

      No Harshita, No issues as long as you follow documentation proprly.


    • At 9:11 AM, Anonymous Anonymous said…

      Thanks, Atul.


    • At 10:51 AM, Anonymous Anonymous said…

      HI Atul

      Have you done a 9i to 10g RAC database upgrade for a E Business suite before? (any 11.5.10).

      If so could you please tell me if yu have noticed any performance issues?? Request you to pls share if any to and thanks once again for your great efforts in sharing your knowledge with others through your sites and blogs.

      Best Regards

    • At 1:34 PM, Blogger Atul Kumar said…

      Hi Ramana,
      I have done it with 10g Application Server but not with Apps. In 10g AS I don't see any issues but yeah RAC in apps is not certified on OCFS , its only certified on ASM

    • At 7:40 PM, Anonymous Anonymous said…

      Hi Atul,
      We are in the process of upgrading Apps11i database from to 10gR2. I have two questions:
      1. What is ASM? is it mandatory configuring ASM while upgrading to 10GR2
      2. How to upgrade database using exp/imp method with out disturbing the existing database? Which method is good for upgrade?


    • At 9:42 PM, Blogger Atul Kumar said…


      ASM is Automatic Storage Management feature in database . To know more about ASM check

      2. Upgrade database using exp/imp trust me I never saw anyone upgrading via Imp/Exp , What you can do is install 10gR2 software & then Install separate database & exp from 9i & imp to 10g r2 complete database .

      Better would be install 10gR2 software & then upgrade.

      I don't understand why you want to use exp/imp & why you don't want to disturb existing database .

    • At 12:56 PM, Anonymous Anonymous said…

      Hi Atul,

      Could you give me document number "Oracle Database Upgrade Guide 10g Release 2 (10.2)." this was reffered in latest document 362203.1 (i.e., Interoperability Notes).

      I need to upgrade to 10g(

      Thanks in advance,

    • At 1:48 PM, Blogger Atul Kumar said…

      Suresh ,

      Upgarde guide is mentioned in next post

      and location is

    • At 10:43 AM, Anonymous Anonymous said…

      Hi Atul,

      I have upgraded my database to 10g, during implemented autoconfig, I have generated file and copied to Oracle home and unzipped, and generated context file,ran autoconfig. Question is, do I have to apply any latest autoconfig patch to get it work for 10g?, script is looking for $ORACLE_HOME/nls/data/9idata directory, which doesn't exist any more, hence autoconfig is failing, and clone can not be done.

      Thanks in advance,

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

      Yes Suresh.

    • At 5:36 PM, Anonymous Anonymous said…

      Hi Atul,

      Could you help finding a syntax that is used to expire a db user password after N number of days also, not re-using old password.

      Also for password changing intervels.

      Thanks in advance,

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

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

    • At 8:03 AM, Blogger harsha said…

      Hi Atul,,
      Can u please tell me how to migrate the database to not APPS)
      though it is not the apps...
      its urgent can u please help me..

      Thanks in advance...

    • At 8:13 AM, Blogger harsha said…

      please tell me how to migrate from 9205 database to 10202

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

      Check this at DB upgrade guide

    • At 8:50 PM, Anonymous annerose said…

      These comments have been invaluable to me as is this whole site. I thank you for your comment.

    • At 4:46 PM, Anonymous Anonymous said…

      <<< I have upgraded my database to 10g, during implemented autoconfig, I have generated file and copied to Oracle home and unzipped, and generated context file,ran autoconfig. Question is, do I have to apply any latest autoconfig patch to get it work for 10g?, script is looking for $ORACLE_HOME/nls/data/9idata directory, which doesn't exist any more, hence autoconfig is failing, and clone can not be done.

      Thanks in advance,

      Were you able to fix the above said problem...if so, can you please share your fix. I have the problem..

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

      Kindly raise this in forum at

    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