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
    Reducing Patch Timing Contd...
    Tuesday, September 26, 2006
    Register for R12 upgrade
    Yesterday we looked at how to use default file so that you can reduce repetative questions asked in adpatch session each time its initiated like APPL_TOP, ORACLE_HOME confirmation. Lets check what else you can do to reduce patch time ( All these tricks & tips to reduce patch time is useful if you are applying lots of patches may be five or more )

    With lot of patches adpatch compile database objects & compile JSP's in end so if you are applying 10 patches & out of those six patches execute compile database in end so adpatch will compile database six time which is waste of resource in terms of time. If you instruct adpatch not to compile of JSP & Database objects & do it in last manually this will reduce lot of your patch timing . So lets see how to do it .

    If you are not clear with patch basics here are my previous posts
    Apps Patch Basics
    Apps Patch Basics Part II
    How to Apply Apps Patch using ADPATCH

    Yesterday I told that you can use defaults file like

    adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt logfile=654321.log patchtop=/patches/654321 driver=u654321.drv interactive=no

    so if you don't want adpatch to compile database & jsp with each execution of adpatch you can use options nocompiledb & nocompilejsp

    adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt options=nocompilejsp,nocompiledb logfile=654321.log patchtop=/patches/654321 driver=u654321.drv interactive=no

    Once your patching is complete and you have applied all patches you can compile jsp & database once.

    How to compile database objetcs ?
    Use adadmin compile database option else
    Use utlrp.sql script on database tier at $ORACLE_HOME/rdbms/admin

    How to compile JSP in Apps ?
    Use perl script under $JTF_TOP/admin/scripts like
    perl --compile

    Merge Patches to reduce patch timing
    Another option to reduce patch timing is to use ad tool admrgpch, so lets say you have 10 patches to apply you can merge 10 patches & create single patch and apply that single patch. ( Sometime applying patches after merging may fail because of conflict in driver file so check first on test server)

    create a directory lets say source_directory & put all patches which you want to merge in that & create another directory where your final single patch will come lets say destination_directory then use

    admrgpch source_directory destination_directory
    If there is any error in merging patch by default it will be in directory from where you are initiating admrgpch by name admrgpch.log
    Apply patch from target directory via normal adpatch way.

    If you are Upgrading your apps instance lets say from 11.5.8 or 11.5.9 to 11.5.10 you can use stagged APPL_TOP (ddifferent from shared APPL_TOP)
    More on stagged APPL_TOP coming in near future ....


    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 @ 5:08 PM  
    • At 2:19 AM, Anonymous Anonymous said…

      Hi Atul,

      Thanks for the info.Just want to know this. Is there any way (apart from using defaults file) to hide the password for system and apps being printed while applying patch.

      Appreciate your efforts here.Keep up the good work. And please do write more on RMAN.

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

      Apps & system password are now a days stored in obfuscated format in log files . You might be using old version. Whats ur apps version.


    • At 1:38 PM, Anonymous Anonymous said…

      Hi Atul,

      That’s the most detailed explanation of patches I have come across as a newbie…Keep it up and going…Coming to the query part of admrgpch…Do I need to unzip/unbundle the patches in the source directory before merging them to destination???

      Thankz & Regards,

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

      Nice Q's, You need to uzip them and put entire patch directory ( for all patches you want to merge) in to source directory .


    • At 6:55 PM, Anonymous Anonymous said…


      In reply to your question "Hi,
      Apps & system password are now a days stored in obfuscated format in log files . You might be using old version. Whats ur apps version."... Just to be more clear with my question, while applying adpatch, it asks for system and apps password. When I type in the passwords, it displays them. I want to suppress the display of passwords while applying adpatch and not in the log file (yes in the log file it is obfuscated)

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

      Apologies for Misunderstanding,
      As far as I am aware I don't the way to obfuscate password in any of ad utilities on screen. I'll try to find answer & update here or on my blog.

      I have to answer on what's meaning of Y in FNDCPASS or FNDLOAD utilities.


    • At 3:40 AM, Anonymous Murali said…

      to hide password use

      adpatch flags=hidepw
      Note: it is flags not options

      Also you mention that avoid compiledb which in my opinion is wrong, forms libraries/reports are dependant on plsql objects if the objects are not valid then forms compilation takes time since it has to attempt to compile the object then.

      To reduce Downtime
      1. Increase Batch Size Parameter during adpatch
      2. Increase ADJREMX and ADJRIMX Parameters to minimum 1 Gig so XML Uploads happen faster
      3. Set parallel_max_servers to 10 in init.ora parameter.

    • At 3:40 AM, Anonymous Murali said…

      to hide password use

      adpatch flags=hidepw
      Note: it is flags not options

      Also you mention that avoid compiledb which in my opinion is wrong, forms libraries/reports are dependant on plsql objects if the objects are not valid then forms compilation takes time since it has to attempt to compile the object then.

      To reduce Downtime
      1. Increase Batch Size Parameter during adpatch
      2. Increase ADJREMX and ADJRIMX Parameters to minimum 1 Gig so XML Uploads happen faster
      3. Set parallel_max_servers to 10 in init.ora parameter.

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

      Thanks a lot for sharing this information with all.

      Other parameters you suggested

      1. Increase Batch Size Parameter during adpatch - Thats perfect.

      2. Increase ADJREMX and ADJRIMX Parameters to minimum 1 Gig so XML Uploads happen faster - You need to see if you have additianl 1GB memory available on server .

      3. Set parallel_max_servers to 10 in init.ora parameter.
      I need to look into it how it can help in patching & how parallel max serevrs comes in to picture . Would you like to share more on this .

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

      About nocompiledb , Its not that if you use nocompiledb your objects will becoem invalid . They will still be valid (Only thing is database will not specifically try to compile any invalid objects ) and I agree to some extent that if underlying objects is invalid then you need to compile that database object.

      Wish to hear such comments more often & I urge other readers as well to comment in case you think otherwise on any topic or want to add somthing which might be useful for others.


    • At 9:12 PM, Anonymous Murali said…

      parallel_max_servers helps in how many threads the Upgrades happen, if you look at the Timing Report in your Development environment you can identify top time consumting jobs usually which are INV, ONT, AP, AR, GL and WF whic have tons of records. parallel_max_threshold parameter in adpatch is dependant on this.

      also to reduce patching downtime for NLS Patches refer

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

      Thanks Murali,
      I'll wind up your suggestions together & update with your name soon in coming posts about patch timing.
      Thanks once again for your inputs.


    • At 10:11 AM, Anonymous Anonymous said…

      Hi Atul
      Thanks for this great information ,i also wanted to know how do i find out if my patch will execute compiledb or compilejsp so that i can use the option nocompiledb or nocompilejsp.

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

      Most of the patch execute compile db & compile jsp in end but its tough to say . You can open patch & try to read drv file .


    • At 5:29 PM, Anonymous Anonymous said…

      Thanx Atul for reply

    • At 10:32 AM, Anonymous Anonymous said…

      Can we merge any/all the patches??? suppose we have patches for diff products or we have diff family packs. can we use admrgpch option to merge these patches together? If no, why?


    • At 12:49 AM, Blogger Atul Kumar said…

      AD patchset is exception to merging rest all other patches you can merge.
      Yes you can merge different family pack patches including prereq & post req except AD

    • At 7:39 AM, Anonymous Anonymous said…

      thanks for replying. 1 more question is why cant we merge AD patches with any other patches?

    • At 12:36 PM, Anonymous Anonymous said…

      can we know if we can merge pre reqs of a patch with it? if yes, how does admrgpch figure out the order of applying the patches?

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

      Yes anonymous,
      You can merge patch with its prereq. Patch is collection of file (shell script, sql, jsp....) and order of applying these files (called as task).The admerge merges steps in patch task list & adpatch picks them based on file version .

    • At 10:11 PM, Anonymous Dhilip Ranganathan said…

      Hello Atul,

      We are on and have applied ATG RUP 4 patches recently and we found that the system and apps passwords are not displayed anymore while running adpatch.

      Dhilip Ranganathan.

    • At 8:34 AM, Anonymous Anonymous said…


      In using the FNDLOAD command, may i pls know how we could provide the password so while it is executing the FNDLOAD, the password is hidden through the output of ps -aex |grep

      The FNDLOAD is currently being invoked from a shell script and run on backend server.

      While this script is running and if a command ps -aex | grep is issued, the password parameter mentioned in the shell script with the FNDLOAD command is revealed. The client do not want this to happen and would want the password should be hidden.

      Your inputs are appreciated in this regard.


    • At 6:08 AM, Anonymous Rahul said…

      Hi Atul,

      Is there any way of finding the information of the individual patches in a merged patch set.Becuause it seems all tables like ad_patch_drivers ,ad_applied_patches etc contain the information of patch created with merge_name attributes of the admrgpch.I need the merge patch name & all the individual patch contain in the merge patch.

    • At 1:31 AM, Blogger A said…

      Hi Atul,
      can we merge patches with different language patches?

    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