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 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • 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 11.5.10.2
  • 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
    IdM
  • 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 http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch
    Monday, September 25, 2006
    Register for R12 upgrade
    At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was huge bunch of patches (I know everybody has to apply lot of patches initially) and we were applying patches individually one by one. Our team lead came & asked us how come you are still applying patches speed up & finish it early (You can't afford this much downtime for patching) . One of my colleague replied look we are not doing anything its Server (Unix Machine) which is applying patches & we can't do much . My TL said give attention what adpatch is doing & try to remove redundant steps which are repeated with each patch.

    that's where we really started looking at we realized that
    In each patch adpatch is
    1. Asking basic questions like , Default APPL_TOP, Log file name, ORACLE_HOME, apps password, system password
    2. Compiling database at end of some patches
    3. Compiling JSP at end of most of patches
    4. Running maintain MRC Multiple reporting Currency in installation where MRC was configured.
    5. It was by default taking number of workers as twice the CPU + 1
    6. There was some thing called batchsize

    Then I looked at metalink to find if there is anyway I can reduce repeated tasks and came across defaults file which I am going to discuss in subsequent pages.
    Other thing I came across is merging patched via admrgpch I'll discuss about this after defaults file may be tomorrow
    You can also play with batchsize & number of workers to reduce patch timing

    Using Defaults file with adpatch (Non Interactive)
    How to create defaults file ?
    adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt ( You can keep this txt file in any location of your choice)
    Now abort autopatch section at point where it asks for patch directory by ctrl +c or ctrl+d
    Now check if this file exists
    You have to do above steps only once in an environment to create defaults file.


    How to apply patches in future ?
    Now any future patches you apply non interactive using defaults file like
    adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt logfile=654321.log patchtop=/patches/654321 driver=u654321.drv interactive=no

    You will see that it will apply patch by itself using defaults file , adpatch will pick APP_TOP, ORACLE_HOME information, system password and apps password from defaults file.

    This will save lot of time & you can reduce your patch timing usign defaults file .

    More on how to reduce patch time in coming posts ...

    Labels:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  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:50 PM  
    9 Comments:
    • At 6:52 PM, Anonymous Anonymous said…

      impressed.

      How to specify the work number in the command line when apply patch

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

      Thanks a lot (I would love to see name of my readers but you have full right not to disclose it at same time)

      Do you mean by number of workers or any other thing ?

       
    • At 9:05 PM, Anonymous Anonymous said…

      how to register.jsp pages in oracle apps in reg to frame work.i developed a application in jdeveloper and how to convert .xml into .jsp

      bye
      sunny

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

      Sunny,
      Apologies but I don't think I will be able to answer this .

      Check in some developer forum

       
    • At 11:49 AM, Anonymous Anonymous said…

      Great web site. Is there any way to move the app into maintenace mode non-interactively too? SO that I could use the crontab to shut the app down, stick the app into maint mode then use adpatch with the defaults file to apply the patches...all ovwernight?? Thanks

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

      Here it comes

      $AD_TOP/patch/115/sql/ adsetmmd.sql

       
    • At 10:22 PM, Anonymous Anonymous said…

      We first apply patches to the test menvironment. The test environment has a different APPL_TOP, apps password, system password, ORACLE_HOME...etc. I apply a patch to the test environment, do I just copy the default file to th production environment to appl it noninteractively? Looks to me the only way you can apply a patch non interactivley is if you have already applied it same machine, or if you applied it in another machine which has exact passowrd, ORACLE_HOME...etc. Am I right?

       
    • At 11:00 AM, Blogger supriya said…

      hi atul!!


      what is this maintenance patch!! and how can we determine taht we need a maintenance patchand more over how can we get it

       
    • At 8:24 AM, Anonymous Anonymous said…

      Hi,

      You can refer the metalink document(375130.1) for
      How to apply patch without enabling Maintenance Mode

      Regards
      Ash

       
    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 @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • 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
    Archives
    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
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar