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
    Thursday, August 10, 2006
    Register for R12 upgrade
    Lot of you asked me about patch basics & even I myself was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & all these buzz words oracle uses to impress people like you & me.

    But before that if you have reached to this post first time & haven't read all my previous post I'll recommend you to go through them as they are basics & very important to understand what I am putting here & in future.

    So now lets start with patch basics / terminology
    Standalone/Oneoff patches : This is used to define patch created to fix single/particular problem.
    Mini Pack : This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ....11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.
    Family Pack : Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack
    Maintenance Pack : Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack ) so

    To wind up things you can say

    few one off patch make mini pack , few mini pack related to same family bundeled together as family pack & all family pack fixed till that time are bundeled in Maintenance pack .

    Oh wait I forgot to tell about NLS Patch ( When you have more than one language , like english & arabic or french .. ) then apart from normal patch you have to apply patch for specific language Installed in your system called as NLS patch ( What is NLS or MLS coming soon ..)

    Next I am going to cover patch basics part II

    Don't forget to leave your comment about what else you want to hear about .
    Apps Learning

    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:44 AM  
    • At 1:15 AM, Anonymous Anonymous said…

      I have heard people taking about drives....? what exactly is that ?

    • At 1:52 AM, Anonymous Anonymous said…

      Thankyou once again for all the stuffs that you are providing.

      Please me about configuration of printers in oracle apps and troubleshooting the printer problems

    • At 9:25 AM, Anonymous Anonymous said…

      Would appreciate if you could pay a bit more attention to the grammar..

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

      I appreciate your comment about grammer, I'll try to focus on my grammer as well in future . Please do point out with specific lines whereever you find wrong grammer in future.

    • At 6:36 PM, Anonymous Anonymous said…

      Good Work Atul, Keep going.. Thank you very much.


    • At 12:28 PM, Anonymous Anonymous said…

      Hi Atul ..What is this F-CUPS ?...Family Consolidated Upgrade Patches

    • At 12:51 PM, Blogger Atul Kumar said…

      Nice Question,
      I'll update Family Consolidation Upgrade patches in my post after database Upgrade . If you don't see it by next week please remind me again.
      I hope you won't have to remind me .

    • At 3:53 PM, Anonymous Anonymous said…

      Great job Man.

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

      Thanks a lot hanmant.


    • At 1:19 PM, Blogger Baskar said…

      continue doing this goodwork is very useful and i am also aware that u spend ur precious time in publishing.well done.

    • At 11:37 AM, Anonymous Anonymous said…

      What is the differnece between rollup patches and stand alone patches??

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

      Standalone patch is a patch provided to fix a particular bug/issue. These are usually small in size & limited to only single issue/problem/bug.

      Rollup patces are usually fixes of all issues popped up because of a particular minipack/familypack or maintenance pack. Lets assume you applied a family pack & because of that some issue/bug came into picture or all bugs reported soon after family pack or maintenance pack are fixed and released as Roll Up patch . These are usually denoted as roll up 1 rollup 2 or roll up A roll up B.

      So you will see maintenance pack 10 (11.5.10) roll up 1 or roll up2

      or family pack HJ.J rollup1 .

      Roll Up patches are usually cummulative in nature .

    • At 1:30 PM, Anonymous Anonymous said…

      Good work atul, keep it up.

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

      Thanks a lot !!

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

      Unfortunately I won't be able to post your commnets as they are copy of Metalink Note # 181665.1
      Which is against copyright laws.

      Atul Kumar

    • At 10:02 AM, Anonymous Anonymous said…

      Could u please help explain what is 11., 5., 10.,2 in Oracle Apps ?
      Thanks & regards

    • At 12:15 PM, Blogger Atul Kumar said…

      Hi is version 10 of Oracle Apps 11i with patchset 2.

      So 11.5.X is 11i
      11.5.10 is version 10 of 11i is patchset 2

    • At 9:35 AM, Anonymous Anonymous said…

      How to check when the Apache is bounced and please let me know is there any log file i can check


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

      You can check $IAS_ORACLE_HOME/Apache/Apache/logs/error_log file

      If you see entry like

      Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations


      That means Apache is Just restarted

    • At 6:56 AM, Anonymous Anonymous said…

      Thanx for the usefull stuff


    • At 8:47 AM, Anonymous Anonymous said…

      Can we talk about ad utilities here? I wanted to know about adadmin. what is the step "copy files to destination"???

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

      Thanks a lot for your request. I'll discuss this in a day or two in new post

    • At 6:39 AM, Blogger fouadbandarkar said…

      Hi Atul ...
      I need to apply a Dicoverer patch on a Windows client ... Opatch.
      If you couls please provide me with the steps as to how to do it ...

      I was applying patch 5398173 ... It had a pre-requisite patch 2617419.
      The steps that I followed were ... 1) I unzipped the patch 2617419 in D:\Oracle. I got a directory called OPatch now.
      2) I unzipped the other patch too ... thats 5398173 in D:\oracle.
      3) Went to the location D:\Oracle\5398173 and gave the command opatch apply.
      Its not working out.

      Please provide me with the detailed steps to set the path and apply the patch ... as I dont know the commands too.

      This patch is given to us as ... the list of application users does not appear when logged in to discoverer.

      Thanks and Regards,
      Fouad Bandarkar.

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

      If this is database patch "opatch apply" is right way .

      What error you are getting ? raise all issues in forum at

      Though I could n't find this patch in metalink

    • At 10:44 AM, Anonymous Anonymous said…

      Hi Fouad,

      There can be 2 issues here...

      1. the inventory location may be incorrect
      - verify that the global inventory is pointing to the correct instance(oracle-home).

      2. opatch is not in the path.
      - to verify this, please use " which opatch". it it returns the opatch for the desired oracle_home then we need to troubleshoot as per the error msg you are receiving else if its not returning a correct value, then give the absolute path for opatch, say /home/test/10.1.2/OPatch/opatch apply.
      You have to run this command from the patch directory where u unzipped ur patch.

      Hope this helps :)

    • At 9:06 AM, Anonymous Anonymous said…

      i am still waiting for the posts on adutilities

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

    • At 2:14 AM, Anonymous Anonymous said…

      Hi atul remember me ur old friend
      abinas from LG i want to know about patch from basisc i was out of apps for 4 months.plse suggest for good trainging in south inida as delhi has no facility.

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

    • At 9:13 AM, Anonymous Anonymous said…

      Hi Atul,

      This is very good stuff. Thanks for posting such a good info.

      My question is:
      My client has changed the default APPLSYS & APPS schema names for some security reasons to APPLSYS_MGR & APPS_MGR while installing Apps.

      They have recently created a new user named as "APPLSYS" due to some requirement.

      This new "APPLSYS" user is just like any other user in Apps DB, who has synonyms to access 4 tables from APPLSYS_MGR schema.

      Would this new user (APPLSYS) create any problem while upgrading/patching OracleApps in future?

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

      Hi Anonymous,
      There is fair chances that this might create problem in future upgrades.

      I am quite curious to know how user changed default apps & applsys schema names & what all other changes they did after changes schema names ..if you can share .

      Atul Kumar

    • At 12:17 PM, Anonymous Anonymous said…

      Thanks Atul for your response. I'll try to get the details for you based on changes done by client.

      Can you also point out to some kind of analysis/oracle docs which would state the potential problems that can be faced while applying patches in scenario mentioned by me?

    • At 12:31 PM, Blogger Atul Kumar said…

      Hi Anonymous ,
      To be frank changing Apps & APPLSYS schema name is not very common (Though clients create their own sutom apps read only schema to give it to functional team) so if you can get more information what all changes were & what all places I can suggest somethign to you .


    • At 7:20 AM, Anonymous Anonymous said…

      Hi Atul ,

      The information provided by you is very useful ..Please keep up your good work :-)

      I have a generic qs regarding Oracle products..

      On what basis does Oracle name its products and the further upgraded versions of it ?

      Like --the Database version was Oracle 9i previosuly and it changed Oracle 10g,why not 10i ??

      why is the Oracle Apps version 11.5 ??why not 11.4 or 11.3 ?

      Similarly for its other products as well like Oracle reports and Forms ..

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

      Hi Anonymous,
      i & g is just buzz world where i is internet & g is for grid.

      and for version number they follow internal versioning mechanism based on thier own tools

    • At 7:43 PM, Anonymous Anonymous said…


      I tried the ftp site,
      as you pointed, it cannot be accessed.
      COuld you pls let me know the exact one, thank you so much.


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

      Steve download them from

    • At 11:07 AM, Blogger Naveen said…

      Hi Atul,
      How to find if a particular Oracle Patch is applied or not?
      (DB Patch)


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

      Use "opath lsinventory" to find database patch on db node

    • At 3:54 PM, Anonymous Anonymous said…

      Can u tel something abt patches like , wat type of patches wil we apply in realtime ?


    • At 3:58 PM, Anonymous Anonymous said…

      I have doubt in patches , regarding ..will we apply patch to add new functionality in realtime ? When we apply that type of patches ?


    • At 8:28 PM, Anonymous Nishu said…

      Hi Atul it was a great learning experience going thru your post..'m in Canda working on Oracle Apps 11.5.8 how can I reach you if I encounter any problem or guidance. I have just a basic knowledge about apps but the good part is that I have access to application so can play around but not confident how can I handle this new responsibility of Analyst to Oracle apps..please send me some tips and guidance how can I if not master but project not a novice on it.

    • At 11:25 AM, Blogger shankar said…

      hi atul this is shankar choudary and
      here is my request to you plz explain
      about 11.5.10 and also some detailed
      regarding patches

    • At 6:33 AM, Anonymous atish said…

      Hi atul..
      i was suppose to apply a patch on an apps Appication 11i using a DB 8i..
      wat r the steps to follows?
      Should i put the application on maintenance mode? How 2do that..

      My problem was, am use to use adadmin on DB 11i an above. but on the DB 8i, the options on adadmin was not the same,am i didn't know how to put on maintenance mode,etc..

      Beside, how to do a patch on a running application..


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

      We have moved to new site at so I'll respond to your query at above link kindly in future keep your comment at above site

    • At 8:30 AM, Blogger yaseen said…

      Hi atul have a nice day ,

      I have applied maintenance pack 3480000 patch. while applying i got one worker failed if i see the log file the error code is 1. what is the reason the worker failed ? how to resume the patch .. can you give sugesstion for this as soon as possible

      advance thanks & regards

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

      Please raise it in forum dedicated to Apps DBA's

    • At 3:53 AM, Blogger oracle apps dba said…

      Hi Atual,

      I want small help. i want to apply the Arabic Language on 11.5.10 version.can you please tell me the what is the patch number and steps.


    • At 5:53 AM, Anonymous Anonymous said…

      Hey Hi buddy,this is Pawan
      Ur articles and updates for Apps
      Architecture are of Gr8 help.
      Gr8 goin Buddy!

    • At 6:06 AM, Anonymous Anonymous said…

      can you please explain what is rollup patch and how to apply the rollup patch.

    • At 10:30 AM, Blogger shaani said…

      How i may apply a Patch on R12.0.4 in Windows Server 2003 Environment.....?


    • At 7:59 PM, Anonymous Anonymous said…

      Do I need to run adautocfg after applying a CPU patch on 11i EBS?

    • At 3:13 AM, Anonymous Anonymous said…


    • At 3:49 PM, Anonymous JDE Training said…

      Great job, I can now work smoothly with my Oracle apps.

    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