DISCLAIMER: The information and links provided on this site are my personal notes, based on my limited experience installing, using, and deinstalling Oracle databases and application servers on a variety of computers using Windows NT/2000/XP operating systems. The installation and deinstallation procedures found here can cause irreversable loss of data and may damage your operating system. However, you are welcome to use them AT YOUR OWN RISK. I am in no way responsible for data you lose or operating systems you damage or destroy.

Introduction

This how-to contains steps taken to apply Oracle's CPUOct2005 to Oracle 9i database servers and Oracle 10g (9.0.4) application servers with Business Intelligence Forms and Reports installations on the Windows operating systems. It is not intended as an in-depth guide detailing every step, but as a prompt sheet to remind me of the major steps required to apply this security patch.

Required Patches

NOTE: Oracle patches and patchsets are available from Oracle'sMetalink support website. You must have a valid customer support identifier to access this site.

Oracle 9i Database Server Patches

NOTE: Oracle recommends applying the highest available patchset before applying CPUOct2005, however there is problem with the export utility contained with patchset 9.2.0.7. Therefore I recommend applying patchset 9.2.0.6 instead. This is also the minimum patchset that must be applied before applying CPUOct2005.

Oracle 10g (9.0.4) Application Server Patches

OPatch Utility

Order Of Application

  1. Upgrade Oracle 9i database server to patchset 9.2.0.6 (3948480)
  2. Extract OPatch utility into database server's Oracle Home
  3. Apply CPUOct2005 (4579093)
  4. Upgrade Oracle 10g (9.0.4) application server middle-tier(s)to patchset 9.0.4.2 (4365154)
  5. Upgrade Oracle 10g (9.0.4) application server infrastructure to patchset 9.0.4.2 (4365154)
  6. Extract OPatch utility into infrastructure's Oracle Home
  7. Apply CPUOct2005 to infrastructure (4579589)
  8. Extract OPatch utility into middle-tiers' Oracle Home(s)
  9. Apply CPUOct2005 to middle-tier(s) (4572357)

Setting ORACLE_HOME information for the install.js Script

The install.js script is case-sensitive - the ORACLE_HOME environment variable MUST EXACTLY MATCH the LOC value for the corresponding Oracle home listed in the \Program Files\Oracle\Inventory\ContentsXML\inventory.xml file.

9.2.0.6 OUI Complains Files In Use

  1. Stop ALL Oracle services in ALL Oracle homes and change any set to "automatic" to "manual"
  2. Stop the Distributed Transaction Coordinator service and change it to manual
  3. Reboot server
  4. Restart 9.2.0.6 OUI
  5. When patchset is complete, restart and change Oracle Services set to manual in steps 1 and 2 to "automatic"

[Return to HowTo]

Valid XHTML 1.0 Strict