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
    How to apply apps patch using adpatch
    Monday, August 14, 2006
    Register for R12 upgrade
    Now you know basics of apps patch like type of patches & options available with patching, lets see how to apply patches in oracle applications 11i .

    Two broad ways to apply patch interactive & noninteractive(You will supply required parameters on commnad line & patch will apply without asking you any questions as you have already provided answers)

    You being new to apps patching will prefer to interactive way f patching , let adpatch throw series of questions & you answer each of these .
    If you want to use any option with adpatch enter adpatch with options= seprated by comma (If you don't supply any options it will take defaukt value set for that particular option like compiledb & compilejsp)
    You have to issue adpatch from application user (User you entered as applications/middle tier user usually applmgr if you insatlled using oracle standard documentation like )

    adpatch options=nocompiledb,nocompilejsp
    Based on you AD verison it will ask you questions like with some suggested value

    Is this the correct APPL_TOP [Yes]
    Log file name & location

    Once patch is applied you might be interested in checking log files

    If patch fails then you have to use utility adctrl to check for which worker it failed & check corresponding worker log file to see error message.

    For more information on patches & patch basics follow metalink note # 181665.1
    I'll cover adctrl to see error message & how to reduce patch timing using defaults file day after tomorrow.

    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:18 PM  
    • At 7:52 AM, Anonymous Anonymous said…


      Is there any list of patches(single node) to be applied for Pre&post installation. Steps to be taken while applying the patches(i.e like shutdown DB or Listener).


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

      For pre & post steps while patching , these should be mentioned in Patch Read Me so do them if they are mentioned in readme .

      For Services these days you have to shut down application tier & enable maintenance mode via adadmin.

      DB & DB listener should be up during apps patching

    • At 3:07 PM, Blogger Firas said…

      Hi Atul,

      Actually sometimes it is very confusing to know what patches to use. For example i have just installed a fresh oracle TEST apps. Now i have many choices. I will use PATCH WIZARD/OAM to install latest recommended patches. I have also ATG_PF Rollup 4 to install .. am i on the right track? In general what is the right policy and strategy for patching systems? Also how to know the family pack amd mini-packs version you currently have?

      Thanks a lot,

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

      You can use script to find mni pack version on your apps instance .
      There are various ways of applying patch & autopatch (adpatch) and OAM are few. OAM inturn uses adpatch only . You can use any supported tool to apply patch

    • At 7:48 AM, Blogger Firas said…

      Where could i find this scrip? I did a "find" op and i couldn't find it. Please advise.

      Thanks anyway,

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

      Check at

    • At 3:38 PM, Anonymous Anonymous said…

      u r very helpful.
      I have 3 questions for you:
      1. How can I know which new patches should I apply by a simple query for the application. I know we can query it from ad_applied_patches, but it only tells the patches, the # tell you nothing. I just want know the answer regardless the version, since the system login on should automatically pick up info without inputing anything.

      2. What kind of logs that I can purge within the application, and how?

      3. How can backup the application and keep them many days and db files, since they are hundreds gbs, not only database datafiles incremental, but also the application files (top and common folders).

      I appreciate your help.


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

      For latest mini pack available and one on your system use this will give list of patch you should apply.

      For purging logs you can use
      purge concurrent request data &
      Purge obsolete workflow data

      concurrent request

    • At 1:41 AM, Anonymous Anonymous said…


      I search the file for the patch set, cannot find it. where is it located? Thank you again.


    • At 1:53 AM, Blogger Atul Kumar said…


    • At 4:22 AM, Anonymous Anonymous said…

      when i'm trying apply a patch, the error occure FAILED: file GMFFIN.odf on worker 1 for product gmf username GMF.How can i handle it?

    • At 4:25 AM, Anonymous Anonymous said…

      when i'm trying to apply a patch, i've got error message :
      FAILED: file GMFFIN.odf on worker 1 for product gmf username GMF. How can i handle the error?

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

      Whats patch No ? Do you see any reason for failure of this in worker log file ?

    • At 9:38 AM, Blogger Muhammed said…

      i m first time upgrading 11.5.10 to but i dont know how to use adpatch utility , when i run adptach then show a appl_top is not set, plz tell me how to apply this utility on W2003.


    • At 9:42 AM, Blogger Muhammed said…

      im first time upgrading 11.5.10 to on vision server now plz tell me how to use adpach utility on w2003.
      when i run only adpatch ulility then show appl_top is not set.

      i downloded a patches.

      soonly reply

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

      Set environment varioable by running env file

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

    • At 12:37 PM, Anonymous Anonymous said…

      Hi Atul,

      How do we find whether the Language patches(NLS) have been applied from the database level other than using OAM? Can you me suggest a query for that?

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


      You might have to correct syntax or typo mistake

    • At 7:56 AM, Anonymous Anonymous said…

      Hi Atul,

      Sorry that was a typo. What i actually meant was that, Can we find out what all language specific patches are applied to Apps from database level using a query other than using OAM? Is there any query for that? B'cos the Ad_bugs and Ad_applied_patches list only the Base patches(US) applied.


    • At 7:39 PM, Anonymous Anonymous said…


      I have problem to download the from oracle metalink, and search from application OAM.

      can anybody pls send me the file latest downloaded to

      and anybody pls give me the list of patches need to be applied for installed on Intel Linux on June 2006.



    • At 2:41 PM, Blogger ravi said…

      Hi Atul,
      how ca i know on which RUP the instance or the application is on there any query or any table to know this .

      Ravi Kishore

    • At 5:10 AM, Anonymous Anonymous said…

      hi atul

      how to know the patch/115/sql/apwexptb.pls

      plz Reply as early as possible

    • At 7:47 PM, Anonymous waseem said…

      Hi Atul Bhai,
      Its gr8 yaar to meet a human like u ,very interesting u will get all u r returns from Almighty for these efforts."Can u plz post prepatching n post patching steps so that i can try it by looking at u r blog.
      Thanx alot again.

    • At 4:46 AM, Blogger Atul Kumar said…

      We are updating these details in new site at

    • At 7:45 AM, Blogger Sunita said…

      I frequently check your site when i face some problem related to apps. is there any document available which comprehensively provides steps for applying patch on windows 2003 operating system, including the path for GNUMAKE, environment variables to be confirmed before starting the patch application and so on.


    • At 4:54 AM, Anonymous Anonymous said…

      hi Atul,

      can provide detail about patching step by step


    • At 8:13 PM, Anonymous ranjeet said…

      hi sir ,

      my self ranjeet from India(mumbai) I am oralce 9i certified now I am working in oracle 10g in saraswat bank so tell me what is difference between core DBA and apps I am interesting to learn apps DBA in directly apps 11i is it possible to me.and give me the path of certification,books

    • At 9:32 PM, Anonymous Anonymous said…

      Hi Atul,
      Have you used PPM tool to apply Oracle patches? If yes, do you have a step by step document for this?


    • At 6:42 AM, Blogger Saq said…

      When we apply any application patch on a dual node or multi node server, why do we start applying it from concurrent node and then application nodes?

    • At 2:29 AM, Blogger Pramod's Lair said…

      How to confirm if a particular patch was applied before the ESA Patch? Is there any query to check this ?


    • At 7:14 PM, Anonymous Anonymous said…


      your articles are really useful for all of us.
      can you please post CPU patches info for E-Businesss 11i? It would be very helpful.


    • At 4:57 PM, Anonymous Anonymous said…

      Hi, We are running Oracle ERP Rel 12, we have 2 languages one in English and another one is German. I have to apply a patch in this environment. what is the right way?

      Do i need to download and apply the patch for English, and then German Language Or only English (ie the dafault) patch is enough? Pls clarify.

      M. Mydeen

    • At 2:05 AM, Blogger kishore.chala said…

      Hi Atul,
      How to apply adpatch by using OAM, I want know only effected files after running the patch. i.e., it is possible by using adpatch apply=no option. but how come it possible in OAM??

    • At 3:40 AM, Anonymous Anonymous said…

      hi Atul ,
      really you are helpful..
      my question is ,if patches realted to application we can use adpatch for patches related to database side..i mean where to apply O patch???

    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