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 PATCH Basics II
    Friday, August 11, 2006
    Register for R12 upgrade
    As Oracle Apps DBA patching is quite basic thing you do regularly so lets continue with basics . If you have not gone through my previous posts please do so now as its quite important to through basics .

    Apps patches are buldled somthing like where p menas patch next few digit are patch number Unix is platform or OS on which this patch can be applied.

    When you unzip a patch you will see some files types which I am explaining here
    readme.txt - This file contain steps to spply patches, List of Prerequisite patch should be there on apps Instance (If not apply that patch )
    cXXXXXXX.drv c stand for copy driver file , this copies patch content to respective patch location , driver is like bus driver which provides instruction on work adpatch need to perform.
    dXXXXXXX.drv d stand for Database driver & contain content related to database like creating packages, tables, adding column....
    gXXXXXXX.drv This contain files related to forms , reports, graphis or messages
    uXXXXXXX.drv Sometime these three types of files are bundled together into single driver file called Unified driver file

    So now you know which type of driver file to apply where ? its common sense if this is d driver you just need to apply once on concurrent manager tier and c & g on all tiers as database is single & if you run it once its enough . If you applied it again by mistake its no harm & will not cause any issues . Similary c & g you need to apply from all tiers , because c will copy your content & g will generate message files.
    If you are not sure where to apply what just apply it on all tiers & depending on your context file in APPL_TOP/admin/SID_hostname.xml it will apply where to install what by checking xml tag TIER_ADFORMS , TIER_ADWEB , TIER_ADADMIN open your xml file & see these parameters are there or not ( For xml file your system should be Autoconfig enabled ) all system after 11.5.8 by default are autoconfig enabled . For more info on Autoconfig check

    Happy Learning
    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 @ 2:27 PM  
    • At 11:27 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 10:24 PM, Anonymous Anonymous said…

      Hi KK,

      your senior is runnng adpatch with options=hotpatch which doesn't require to stop the services and put node in maitaineance mode.



      Hi Atul,

      Apart from this reply. I have question for you.

      As you discussed about d driver. The way we apply u driver on RAC node with nodatabaseportion. Can we use same option while applying d driver on RAC node.

      Waiting for your response on this.


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

      Apologies as I missed replying to your previous comment.

      I hope you on RAC node , from one database node you are running patch as normal & from second RAC Node you are using nodatabaseportion. Yes for d driver you can use same .

    • At 10:52 PM, Blogger Atul Kumar said…

      KK, Maintenance mode was introduced in AD.I, so if your AD Version is less than I then there was no option to put Apps in Maintenance mode & you could apply patch while Instance was Up
      as Bob mentioned ur senior might be using options=hotpatch


    • At 3:03 PM, Anonymous agostino_neto said…

      Thanks Atul.
      I have the following questions regarding patch application:
      1- How can we know what our patch level is?
      2- When can we know we need to apply one patch (only when users complaints about a bug?
      When there are performance problems? To be on the latest patch level? Why should we apply a patch?)
      3- It is not very clear for me:
      You said: d driver you just need to apply once on concurrent manager tier why not database tier?
      Can I understand: d on database tier, c &g on all application tiers and on database tier (one time)?

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

      For questions/Issues please raise them in forum at dedicated to Apps DBA's

    • At 7:32 AM, Anonymous Anonymous said…

      How to deinstall the patch 4028184


    • At 7:33 AM, Anonymous Anonymous said…

      How to deinstall the apps patch 4028184


    • At 7:34 AM, Anonymous shivu said…

      How to deinstall the patch 4028184

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

      Since this is Apps patch applied using adpatch (This is minipack) so you can not uninstall this patch . Only option is to revert back to backup before applying this patch

    • At 4:51 PM, Blogger subhasis said…

      hi Atul
      i want to know how i applay A Application, 806 or iAS patch in multi-node and shared APPL_TOP i want complite concept ok

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

      Hi subhasis ,
      I 'll try to cover them in my coming posts.

    • At 7:56 AM, Anonymous Anonymous said…

      as u have mentioned here when we unbundle a patch we see a readme file readme.txt, a driver file u(patchno).drv but other than these we also see files like b(patchno).ldt, f(patchno).ldt. could you please let me know what are these files?

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

      Check here
      for ldt or lct file

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

    • At 9:13 AM, Anonymous Anonymous said…

      thanks but i know what are ldt and lct files. my question is what the ldt files inside a patch_top used for. i m not asking abt the ldt or lct files supplied with a patch to be applied to the instance. i m talking abt the 2 ldt files which are present in a patch_top for all the patches irrespective of the patch type. i wanted to know what are these ldt files and why are they used or how are they used by adpatch?u can try unzipping a patch and find out by urselves.

    • At 3:36 PM, Anonymous Anonymous said…

      how to apply a patch on a shared APPL_TOP. How to know which is the primary noe.

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

      Apply from any node which plays roles of admin server

    • At 3:24 PM, Anonymous Anonymous said…

      Hi Atul,

      Than q for the information.
      But still I've a doubt. You mentioned that d.drv updates the database.
      Does this mean that it updates the RDBMS_ORACLE_HOME or anything else?

      Than q.

    • At 11:43 AM, Blogger VIRAT said…

      plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..

    • At 11:44 AM, Blogger VIRAT said…

      plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..

    • At 11:45 AM, Blogger VIRAT said…

      plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..

    • At 2:59 PM, Blogger Rafi said…

      Thanks Atul...

      Its realy helpful..

      Best regards,


    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