How to apply patch

[castlerock]

hi,
I have a database created on windows with 9.2.0.1.0 and want to make it as 9.2.0.6.0. How to do this? what patch should i download?What steps need to be followed?Pls send in your valuable suggestions.


Many Thanks,

[davey23uk]

download the 9.2.0.6 patchset from metalink - read the instructions

[Mr.Hanky]

Originally posted by davey23uk
download the 9.2.0.6 patchset from metalink - read the instructions

FOOKIN GENIUS!!

[castlerock]

Hi ,
Not able to find it in .....this is what i have selected in the metalink.

product:RDBMS Server (OR)Database Upgrade Assistant (dbua)
oracle 9.2.0
patchtype: patchset/minipack
Platform: windows XP

If i select patch instead of patchset in patchtype..i am able to see a list of patch to download....

Patch 395943:
--------------
SOLARIS 9.2.0.6.0 PATCHSET TC3:ORA-06550; COMPONENT 'VALIDATE_COMPONENTS'

Patch 4051461:
-------------
CANNOT CREATE CHANGE TABLES ON LOGICAL STANDBY SYSTEM

Patch 2727824:
--------------
SDO_WITHIN_DISTANCE FAILS WITH 2D WINDOW AGAINST 3D DATA INDEXED 2D


etc....

which one shoould i download.

Many Thanks,

[davey23uk]

download the patchset for 9.2.0.6 for windows xp 86 database server, under the patches menu

It is quite clearly listed there.

[castlerock]

metalink>
patches&update(leftside)>
two menus 1.patches 2.updates

selecting simpleserach/advance search in patches
Serachby: product and family>RDBMS Server
Release: 9.2.0
patchtypeatchset/minpack
platform:Microsoft windows

Patchset 2632931:
-----------------
9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER

Pls confirm the above patchset is the correct one??

[davey23uk]

no, you want 9.2.0.6 !!!!

[adewri]

Originally posted by castlerock
metalink>
patches&update(leftside)>
two menus 1.patches 2.updates

In patches there is

"Quick Links to the Latest Patchsets, Mini Packs, and Maintenance Packs" Click on this link.

Then in the next page under "Latest Oracle Server/Tools Patchsets" in " Patch Sets for Product Bundles" bring your mouse over "Oracle Database" > and from the list choose "Microsoft Windows(32-Bit)" > "9.2.0.6.0"

download the patch from here...