Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: Oracle Applications Patching !!!!!!!

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • Oracle Applications Patching !!!!!!!
    Monday, June 23, 2008
    How to apply patch in 11i instance and which order we need to apply?

    We can apply patch with adpatch utility. i.e – adpatch driver=u203793.drv
    If patch consists of copy driver, database driver, and generate driver then order is
    c.drv – Copying of files
    d.drv – Database updating
    g.drv – Generation of files

    What all are the patch components?

    Read me files:
    Before apply to patch read associated read me file carefully
    Contains patch application instructions
    Also may contain manual steps
    Patch driver files :
    Traditional patches: Copy driver, Database driver, Generate driver.
    Newer patches: unified driver which combines the action of the copy, database and generate drivers in a single consolidated driver.
    Replacement files: Copied over existing files
    These files are listed in the copy driver and replace the forms, reports, SQL scripts, HTML files, object modules and etc.
    Adpatch make a backup before replacement of any file
    Patch metadata files: Contains key patch information
    Metadata files are used by the AD utilities to determine prerequisite patches, analyze the impact of the patch on the system.
    Compare versions of the files in the patch with those of files in the system.
    SQL Scripts: Scripts to modify the database
    Run to perform updates
    Scripts are called by the database driver

    Note: You read the read me file before applying any patch.

    What is Auto Patch?

    It is utility that automates many patching tasks for oracle applications
    It is used to apply oracle applications patches
    Compares version numbers before replacing a file to ensure the most recent file is used
    It doesn’t change files if those on the file system are more recent then the ones in a patch
    Makes a backup copy before replacing any file
    It doesn’t run database tasks that have already been performed
    It unloads patch metadata and verifies prerequisite patches have been applied
    It reads and validates the patch driver files
    It relinks executables
    It generates java archive (JAR) files
    It compiles JSP files
    It updates database objects
    It compiles invalid objects
    It runs AutoConfig to update configuration files, If any template files are introduced or updated by the patch.
    It saves patch history information to the database
    It is platform aware, If u try to apply a sun Solaris specific patch on windows system, AutoPatch fails

    What is needed to be considering before applying a patch?

    Take a cold backup of oracle applications as well as database if it possible
    Bounce the applications tier
    Enable maintenance mode with adadmin utility
    Create patch top directory
    Download patch and unzip the patch under patch top directory
    Make sure there is space in file system to apply patch
    Merge all product specific patches
    posted by Jaswinder Singh @ 5:00 AM  
    Post a Comment
    << Home
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Powered by

    Free Blogger Templates


    click here
    © 2006 Appsdba .