Upgrade Oracle 10.2.0.1 to 10.2.0.4 (with january patch) for a single Instance Installation

Install 10.2.0.4 package

1. Download file p6810189_10204_Win32.zip. Unzip the package, all files are under “Disk1” directory. Read the patch_note.htm. Refer to patch_note.htm for detail steps.
2. patch_note.htm: Section 7.6.1 Stopping All Services for a Single Instance Installation
3. patch_note.htm: Section 8.1 Installing the Oracle Database 10g Patch Set Interactively
4. patch_note.htm: Section 9.3.2 Manually Upgrading a Release 10.2 Database

Install opatch
1. Download p6880880_102000_WINNT.zip and unzip it
2. Read opatch’s readme.txt file and follow the instruction


Install Oracle January critical Patch
1. Download p7584866_10204_Win32.zip
2. Unzip the file and all files are under folder 7584866
3. Follow Readme.html Please read through the whole document and make sure that you understand the process
4. Readme.html Section 3.3.2 Patch Installation Instructions for Single Instance
5. Readme.html Section 3.3.7.2 Recompiling Views in the Database