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 Apps 11i with Database 10g R2
    Monday, August 28, 2006
    Register for R12 upgrade
    Database 10G Release 2 is now certified with Oracle Apps 11i , so today I am writing on overview of Upgrading your 8i, 9i database to . For exact steps follow Metalink Note ID mentioned at bottom of this page.

    Few Things you should note before starting database Upgrade with Apps 11i
    1. Database is currently certified only with 11.5.9 and 11.5.10 ; If you want to know which Apps version you are currently on ; check question "how to determine apps version"
    2. As of date 27Aug2006 only is certified in Database 10g R2 family .
    3. If you are using Portal 3.0.9 with Apps 11i , portal 3.0.9 is not certified with 10gR2 so you have to upgrade Portal to 10g Application Server. (First configure 10G Application Server for Portal)
    4. Base release of 10gR2 is so first you have to Install & then apply patchset which is certified with Apps 11i (11.5.9 & 11.5.10)
    5. Use natively compile PL/SQL code , Though metalink note mention its optional but 11i Initialization parameter says its mandatory parameter (I'll confirm it once I go to init paramateres with and for better performance use Native Compilation.

    Why should I upgrade 11i database to ?
    -New features in
    -Bug fixes from or 10.1.x database

    From which database versions direct 10.2.0.x supported ?
    You can upgrade directly to from following database version , or higher, or higher

    Where can I get software & patchset ?
    --You can download software from
    You need companion CD as well so download companion CD as well from above location.
    -- is available as patch 4547817 which you can download from or

    Related Metalink Notes
    These notes will be helpful during your database Upgrade for Oracle Applications 11i.
    --362203.1 Oracle Applications Release 11i with Oracle 10g Release 2
    --216205.1 Database Initialization Parameters for Oracle Applications 11i

    About tips to reduce downtime & other critical things during 10g R2 database upgrade with 11i, I'll update tomorrow.

    Leave your comments about this or any other post as well about look and feel of site as compared to previous look and feel.

    Atul Kumar
    Oracle Apps 11i 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 @ 11:12 AM  
    • At 7:21 AM, Anonymous Anonymous said…

      Hi Atul
      Expecting more on this topic as soon as your time permits.
      Wish you all best

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

      Sure KK,
      I'll do it tonight.


    • At 5:44 AM, Blogger TJ said…

      This comment has been removed by a blog administrator.

    • At 5:47 AM, Blogger TJ said…

      after you upgrade db to,
      there will be an rapid clone error of on dbTier.It seems to be an bug.
      Therefore when you clone dbTier, you better not use 'dbTier' option, but use 'dbTechStack' option to clone engine and manually create database with creating controfile.

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

      Thanks for sharing this with all of US. I suppose there is workaround available by changing one of template file , I'll update you with more info on this soon.


    • At 9:32 AM, Blogger TJ said…

      Hi Atul
      I have modified some template files, etc, but error not fixed.
      pls update this when you figure it out and hope we can share knowledge on APPS each other via your blog

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

      In my Instance changing tepltae file fixed issue . I'll check it again & get back on this comment section in a day or two .


    • At 6:07 PM, Blogger Arunkumar said…

      Can you elaborate more on this issue and the solution to fix it?

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

      Check Metalink Note 372256.1
      perl dbTier" failed on Error: /lib/stubs/ not found


      Script version 115.24 is not 10gR2 ( 10.2.0.X) compliant

      Fix & symtoms are in note


    • At 1:50 PM, Anonymous Anonymous said…


      U said above that companion cd is also neede. What is the use of companion CD.
      just we need 2 CD's
      (2) patch set ..


    • At 1:59 PM, Anonymous Anonymous said…

      Hi Atul,

      Above u said that, for 10g upgradation, Companion CD is required. will it be needed?
      Only 2 are needed

      (1) CD

      (2) Patch Set


    • At 2:01 PM, Anonymous Anonymous said…

      Hi Atul

      For 10g Upgradation, Comapanion CD is required?

      I think for metalink 2 are needed

      (1) CD

      (2) Patch Set


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

      Yes Rao,
      You need companion CD apart from software & patch


    • At 4:36 PM, Blogger Atul Kumar said…

      I don't know if other Updates are alos your but Companion CD is required for

      Knowledge Base & Ultraseach .


    • At 8:41 PM, Anonymous lac said…

      I am a new bee in oracle DBA. I have a doubt in applying archived redo logs.
      1. We have our test database is running in archive log mode(for testing purpose)
      2. Every day we take closed completed cold backup in the night
      3. We are testing the recovery scenario in this database
      4. For example at 12p.m we had some failures and we have decided to restore the database from previous night backup and apply the archived log files.
      5. How can i achieve this?
      a. Assume that there were arch1 - arch25 archived log files from yesterday. When the database is backed up yesterday night the last log was arch20 and the archived logs also got backed up upto arch20.
      b. After that arch21,22,23,24,25 got generated until today
      c. current online log(at the time of failure) is arch25.
      d. when restored from the backup i restored all datafiles,control files not redo logs(should not overwrite the online redo logs).
      Now my question is:
      1. What option i should use to recover my database? since my online logs are more recent than the control file .
      2. After recovery how to apply the archived logs to make it complete recovery .
      If i am confusing you, can you give me the clear picture of how to recover database from cold backup + applying archive logs up to the point

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

      I can understand what you are saying . When you say you had failure at 12PM what kind of failure is that ?

      Do you have control file at 12 PM , time at which database failed ?

      If yes then you use that control file to start backup server . AS controlfile recognize that datafile header (from previous night backups)are not matching with number in control file then your database will prompt your for recovery & it will ask you for archives/redo's from 21 to 25.. provide these to database (You might miss online redo logs depending on if you have backup of those or not)

      For more info on backup scenario check

    • At 8:21 PM, Anonymous Anonymous said…

      After 10gR2 upgrade, we encounter a lot of performance problems.
      setting OPTIMIZER_FEATURES_ENABLED=9.2.0. improves the performance, but of course we wouldn't want to do that.
      Simple query:
      select count(*) from dba_segments,dba_tables where segment_type = 'TABLE'
      and table_name = segment_name
      and dba_segments.owner = dba_tables.owner;


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

      Hi anonymous ,
      Thanks for sharing this ifno with us . Could you please confirm if this is with apps & you have followed init file for 10g with Apps properly.
      We also had this issue in past & later found one init parameter was wrongly configured .


    • At 7:08 PM, Anonymous Anonymous said…


      I am lac, This is the continuation of my previous post abt recovery. We have used "recover database using backup control file" and applied the archived logs from 21-25 + online redo log. Now when i try to open the database i am forced to use resetlogs. I know this is going to clear the current log and reset the archive log numbers to 1. We dont want to reset the logs. Can you please explain here how to continue with the archive numbers like 26,27... after recovery of database.

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

      There is very good explanation on this by Eric at

      Atul Kumar

    • At 9:13 PM, Anonymous Anonymous said…

      I am following up your document for upgrading the database from to 10gR2 on 11.5.10 .
      1. I have downloaded oracle 10g from metalink
      2. Installed oracle home software . The installation went fine.
      3. As per document when i try to install the 10gR2 patchset (4547817). It says Installed and the reinstall option is enabled.
      4. When i checked in installed products button and local inventory of oracle home using
      opatch lsinventory, it shows the following :

      Installed Top-level Products (2):

      Oracle Database 10g
      Oracle Database 10g Release 2 Patch Set 1
      There are 2 products installed in this Oracle Home.
      I am confused whether to proceed with patch set installation or proceed with db upgrade>

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

      Hi Anonymous as you said that you applied 10gR2 patchset (4547817) and even Installed Top level products from oraInventory is showing both 10g R1 & R2 i.e. you proceed with DB Upgrade .

      You can proceed with DB upgrade.


    • At 5:25 PM, Anonymous Anonymous said…

      Is is certified with oracle apps 11.5.10CU2?

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

      Not yet, but you might see it soon .


    • At 3:06 PM, Blogger fhasweh said…

      hi atul, a qustion plz in step 3. If you are using Portal 3.0.9 with Apps 11i...etc, how can i know if i am using oracle portal 3.0.9 or not.


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

      Can you tell me which metalink note you are referring ?

    • At 6:21 PM, Blogger Shashi Bhushan said…

      Hi Atul,
      I am using solaris 10 and fresh install with 9i database. Now we want to upgrade the database with Is is possible to direct install oracle software instead of and then apply patchset.

      Please clarify as early as possible.



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

      Hi Sashi,
      Unfortunately NO. base release for is so you have to first install & then patch it to


    • At 5:03 PM, Blogger Anonymous said…

      Hi Atul,

      we are on 11.5.10 with atg cu4 on a 9207 db, do we meet the pre-req to upgrade to 10gR2 or should we apply cu2 on top of 11.5.10

      Kindly advise

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

      Anonymous is prereq so U still have to apply 11.5.10 CU2 patch

    • At 7:04 AM, Blogger Saptarshi said…

      hi Atul,

      I have freshly installed
      then upgraded the db to applied patch, db is now

      but my problem is, whenever i am opening http://host:8006/oa_servlets/AppsLogin
      its displaying a blank page.

      but if i use http://host:8006
      Logon Options for Oracle Applications 11i page is opening.
      but on clicking "E-Business Home Page" link, its displaying blank page.

      kindly reply at your earliest

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

      For issues/problems raise them in forum at

    • At 7:35 PM, Blogger Chelmella said…

      hi Atul,
      I am srinidhi.
      I am very much impressed with your blog site, actually I have seen this site recently that is why I am late to the blog.
      I have doubt ...
      In Oracle Applications 11i while migrating the database( from one platform to other platform what should be the target system like...the entire databse should be deleted or wat should be the structure of target databse ...
      please help me out in this...

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

      Depending on your targeting operating system there are documented way to migrate apps database from one o.s. to other o.s. use metalink to check corresponding document

    • At 4:55 PM, Blogger Vikram said…

      Hi Saptarshi,

      Most probably your Jserv is not starting up. Check these directories for errors:


      - Vikram

    • At 3:02 AM, Anonymous Anonymous said…

      Hello Atul,

      Is it possible to install 11.5.10 fresh install directly to an empty 10gR database. I am trying to look for some workaround

      Thanks for the help


    • At 3:34 AM, Blogger Atul Kumar said…

      No, Its not possible to install 11i on 10g R2 directly

    • At 11:30 AM, Anonymous Anonymous said…

      Why shouold I upgrade to 11.5.10?
      Answer will not be sufficient as every one knows there should be enhancements with upgradation. could you give a brief introduction about the new features which were introduced in release 11.5.10

    • At 8:48 AM, Anonymous Anonymous said…

      hi atul,

      I have an apps 11.5.8 version running on db We are looking forward to move to What are the broad steps to this db upgrade? Can we move to, is 11.5.8 supported on this version of DB?


    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