How to Install an Oracle Applications Patch

Every decent DBA ought to know how to patch his /her database. This is a stub, I'll work on it more later

Steps

  1. Image titled Install an Oracle Applications Patch Step 1
    1
    Search meta-link for your patch and anything that supersedes it. Download the patch be aware that patches can be as big as 4 GB!
  2. Image titled Install an Oracle Applications Patch Step 2
    2
    Read the included "readme files".
  3. Image titled Install an Oracle Applications Patch Step 3
    3
    Run through all the steps in the readme... but do it on your test machine first, OK? The main steps include:
    • Stopping all Oracle processes which belong to current $ORACLE_HOME.
      Image titled Install an Oracle Applications Patch Step 4
    • Backing up the database, Oracle Inventory and the $ORACLE_HOME tree.
      Image titled Install an Oracle Applications Patch Step 5
    • Checking the patch file size and unzipping if it is correct.
      Image titled Install an Oracle Applications Patch Step 6
    • Running opatch/runInstaller to finalize the patching process.
      Image titled Install an Oracle Applications Patch Step 7

Article Info

Categories: Install & Uninstall Software