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
    Patching Commonly asked questions
    Tuesday, August 15, 2006
    Register for R12 upgrade
    Where can I find patch log files ? ( Check

    What are different type of patches ?

    How to check if a patch is applied ?
    Check table ad_bugs (bug_number ) or ad_applied_patches table .

    What two tables adpatch creates when you apply or run adpatch session ?

    Is uninstalling apps patch applied using adpatch supported ?
    No (Supported version is to restore from backup )

    How to apply a patch when adpatch is running & you come to know that a patch needs to be applied before that patch ?
    Broad level steps are Shutdown workers using adctrl, backup above two tables, backup .rf9 files, Drop these two table mentioned above, apply patch which you were suppose to apply , restore .rf9 files , restore two tables which you backed up earlier & restart patch again .

    Whats defaults file ?
    This is to apply patch non interactively more Coming soon ( i 'll post on this soon )

    Few methods to reduce patch timing ?
    Use defaults file, merge patches & apply as single patch, use high batch size depneding on your system resource, select carefully number of workers while running patching, if upgrade use staged appl_top ( more coming on this in future, please note staged appl_top is different from shared appl_top )

    How to control workers ?
    using adctrl .

    If you encounter any questions related to adpatch and not clear about it, please mail it to me & I will get back to you with in 48 hours . Mail me at

    To know more about Oracle apps 11i Webserver visit my site

    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 @ 9:51 PM  
    • At 3:10 AM, Anonymous Anonymous said…

      Good work...keep going

    • At 7:48 AM, Anonymous Anonymous said…

      The blog is good,but your web site is better.Waiting to see the updates there.

    • At 11:35 AM, Anonymous Anonymous said…

      Hi Atul
      While Patching, As Per documents
      1. We have to set the environment variables
      2. We should enable Maintenance Mode
      3. Stop Services (current Mgr, Forms Server, web server)
      4. Apply Patches thru ad Patch (As per Read me file) & review the log files
      5. Disable Maintenance Mode (adadmin)
      My seniors skipped 1 & 3.
      Please explain why he had skip the above 1 & 3 steps
      Thanks & Regards

    • At 3:39 PM, Blogger Atul Kumar said…

      Thats very valid question . No you should never skip setting Environment Variables. Since mostly env. variable files are called from user profile so as soon as you login to applications from o.s. user it automatically sets environment variables thats why ur seniors might not be seeting env. variables.

      Enable maintenance mode was introduced in I suppose Ad.I.2 you can skip that by option=hotpatch so like adpach options=hotpatch

      There is no need to stop services but if your patch changes any executable which your services might be using you see unexpected behaviour during patch applications.

      Oracle is recommending to stop but its not necessary so for a starter its better to stop services & as you grow in apps dba you can decide to stop or not


    • At 8:21 PM, Anonymous Anonymous said…

      This is my first post/comment on ur blog..I must say Hats-Off to u...Keep up the good work..Coming to the query part?? can u put some light on .lgi files which are created along with .log files during patch application...

      Thankz and Regards

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

      Thanks a lot for your compliments. Coming to your query about lgi file while patch , I can never forget this question because I was not aware of this five years ago when someone asked me this question during Apps Interview :)

      lgi stands for log information ( lgi ) this stores informative message while patching which can be helpful to understand what patch is actually doing. Though I never came across anyone till now who ever opened this file.


    • At 5:36 PM, Blogger walkingtall said…

      Hi Atul,
      Is there a way we can login when maintence mode is on??

    • At 5:37 PM, Blogger walkingtall said…

      Hi Atul,
      Is there a way we can login when maintence mode is on??

    • At 11:08 PM, Blogger Atul Kumar said…

      Yes you can login but application will behave strangely like responsibility missing or functions/menus not available

    • At 3:50 AM, Blogger Dilipkumar said…

      Where to find that lgi file in R12??

    • At 3:51 AM, Blogger Dilipkumar said…

      I am newbie to Apps DBA...These blogs are helpful to me....thanks

    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