APEX

First try to upgrade Opatch to last version 10.2.0.5

Oracle s/w needs to be at V10.2.0.4 before applying the patch

The patch you tried to apply should be applied on top of 10.2.0.4.0, you have 10.2.0.1.0. First apply the 10.2.0.4 patchset, then apply the one-off. Or better yet skip all the way to 10.2.0.5.

Were is your oracle inventory location ?

KDSDBA
OCP

Do you mean I should down load software 10.2.0.4.0 and install by using OUI installer ?

My Inventory path as below:
C:\oracle\product\10.2.0\Inventory

Since V10 is no longer fully supported, I recommend that you install V11.2 & use it.

I don't quite understand. Do you mean I need to upgrade to 10.2.0.4 then do the patch?
I have never done patch before, so please help.

You should review the README file in the patch zip file and besure you have the correct database install.
You may also need to upgrade your OPatch as well it is too lower of verison.

On WINDOWS the location is usually C:\Program Files\Oracle...


KDSDBA
OCP

Hello,
You need to upgrade to 10.2.0.4.0, after that you can apply the patch.

To upgrade from 10.2.0.1 to 10.2.0.4 the patchset number is Patch 6810189

check Quick Reference For Patchset Numbers/Availability And Download [ID 554256.1] in the metalink.
Also, I would recommand to backup your whole database including control file, spfile etc... before doing any patch.

Good luck!

Thank you very much for providing the information.

I have another system is Window server 2003 with 10.2.0.2.0
Should I upgrade to 10.2.0.4.0 before patching ? And, which patch number should I use ? What ID number in the metalink ?
Thank you for you help.





=============================================

Hello,
You need to upgrade to 10.2.0.4.0, after that you can apply the patch.

To upgrade from 10.2.0.1 to 10.2.0.4 the patchset number is Patch 6810189

check Quick Reference For Patchset Numbers/Availability And Download [ID 554256.1] in the metalink.
Also, I would recommand to backup your whole database including control file, spfile etc... before doing any patch.

Good luck!

Hello,
The same thing, upgrade to 10.2.0.4, You can refer to the same document [ID 554256.1] in the metalink

Good luck!

As now I have system windows 2003 with 10.2.0.2.0. And I have patch software as below. Do I still need to get a set of software to upgrade
to 10.2.0.4.0 and patch the below software - 10349197



D:\Oracle 32-Bit\10349197>dir
Volume in drive D is Oracle
Volume Serial Number is E796-16C2

Directory of D:\Oracle 32-Bit\10349197

03/30/2011 02:33 PM <DIR> .
03/30/2011 02:33 PM <DIR> ..
02/18/2010 04:37 AM 497,024 ocfs.sys.2k
02/18/2010 04:37 AM 486,400 ocfs.sys.2k8
01/13/2010 10:14 AM 9,088 orafencedrv.sys
01/13/2010 10:14 AM 10,240 orafencedrv.sys.2k8
01/07/2011 10:01 AM 2,925 patchmd.xml
01/12/2011 05:25 AM 86,223 README.html
05/15/2008 05:36 PM 37 README.txt
03/30/2011 02:33 PM <DIR> custom
03/30/2011 02:33 PM <DIR> etc
03/30/2011 02:37 PM <DIR> files



under files directory are:

Directory of D:\Oracle 32-Bit\10349197\files

03/30/2011 02:37 PM <DIR> .
03/30/2011 02:33 PM <DIR> ..
03/30/2011 02:33 PM <DIR> assistants
03/30/2011 02:34 PM <DIR> bin
03/30/2011 02:34 PM <DIR> Bundle
03/30/2011 02:34 PM <DIR> cfs
03/30/2011 02:34 PM <DIR> crs
03/30/2011 02:34 PM <DIR> ctx
03/30/2011 02:34 PM <DIR> dv
03/30/2011 02:35 PM <DIR> instantclient
03/30/2011 02:36 PM <DIR> javavm
03/30/2011 02:36 PM <DIR> jlib
03/30/2011 02:36 PM <DIR> lib
03/30/2011 02:36 PM <DIR> md
03/30/2011 02:37 PM <DIR> oci
03/30/2011 02:37 PM <DIR> odbc
03/30/2011 02:37 PM <DIR> odp.net
03/30/2011 02:37 PM <DIR> olap
03/30/2011 02:37 PM <DIR> rdbms
03/30/2011 02:37 PM <DIR> srvm
03/30/2011 02:37 PM <DIR> sysman

Oracle has retired metalink it is now My Oracle Support > MOS.

KDSBDA
OCP

How to get there MOS ? Would you please provide a link? Thanks

You must use the OPatch utility release 10.2.0.4.3 or later. You can download it from Oracle Metalink.

Oracle has retired metalink it is now My Oracle Support > MOS.
This includes other countries outside of USA.

KDSBDA
OCP

Ensure that your Oracle Database installation is the same release for which you are applying this patch. In other words, only apply the Release 10.2.0.4 Bundle patch to an Oracle Database Release 10.2.0.4.

The link was already provided. Why you don't just read the doc?

I have never done patch before, so please help.>
Skip 10.2.0.4 and patch to 10.2.0.5 while you still can. Download the 10.2.0.5 patchset from MOS and follow the instructions. Then download and install current OPatch and then download and apply current patch bundle on top of 10.2.0.5.