Current Patches for Windows (32bit) 9.2.0.8

[george_hamilton]

We have recently upgraded to Windows 32-bit Oracle 9.2.0.8. Note 539921 lists the patchset for Windows 32-bit as follows:

NT_I386 32-bit

/Oracle/Oracle 32-Bit/Oracle 9.2.0. 32-Bit/Oracle 9.2.0.8. 32-bit/

NT_I386/Patchset_9208_WINNT.zip

The patch set is installed with the runInstaller - see README.html

For more information about installing patch sets, see Note 578683.

*In addition, use opatch to install patch 12 for 9.2.0.8.

/Oracle/Oracle 32-Bit/Oracle 9.2.0. 32-Bit/Oracle 9.2.0.8. 32-bit/

NT_I386/9208_Patch12_WINNT.zip*

So, after an upgrade to Windows 32-bit 9.2.0.8 you should then immediately apply patch 12? The problem is reading note 1107601 - CPU Patches October 2007 (Oracle Critical Update Program)

states the following:

*The CPU patches are not a patch set, but rather a collection of patches. If

there is a critical problem, you may have to install a separate fix, which

conflicts with the CPU patch. In this case, you must uninstall the CPU

patch.*

But there is nothing specific for 9.2.0.8 (it implies there are no conflicts for 9.2.0.8):

For Oracle 9.2.0.7, note the following:

Unfortunately, the CPU patches for Oracle 9.2.0.7 conflict with patches

that have already been installed and that are important for an SAP system.

Therefore, there will be no further release of the patches for Oracle

9.2.0.7. *We therefore recommend that you upgrade the database to Oracle

9.2.0.8 and use the CPU patches for Oracle 9.2.0.8 instead.*

So I'm assuming that after installing patchset 9.2.0.8 for Windows 32-bit I should apply patch 12 (which is CPU October 2007). There are some patches listed under "Oracle Other" that seem to be generic patches listed under the download section for oracle 9.2.0.8. Do these patches cause a conflict with patch 12? I haven't seen a note that says to install them.

I haven't found a note that says to install anything other than patchset 9.2.0.8 and then patch 12. Is this right? I need to find out pretty quick so any help is appreciated!

[Former Member · Accepted solution]

Hi,

do following as of note 539921

first apply patch set 9.2.0.8

/Oracle/Oracle 32-Bit/Oracle 9.2.0. 32-Bit/Oracle 9.2.0.8. 32-bit/

NT_I386/Patchset_9208_WINNT.zip

than apply cpupatch CPUOct2007 patch 12 for 9.2.0.8 if you found critical problem with CPU it's optional

use opatch to install patch 12 for 9.2.0.8.

/Oracle/Oracle 32-Bit/Oracle 9.2.0. 32-Bit/Oracle 9.2.0.8. 32-bit/

NT_I386/9208_Patch12_WINNT.zip

regards,

kaushal

[george_hamilton · Accepted solution]

Thanks for the quick reply. Do I check that patch 12 is installed on windows by using the "opatch" executable?