How to apply patch
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How to apply patch

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    How to apply patch

    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,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    download the 9.2.0.6 patchset from metalink - read the instructions

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131

    Thumbs up

    Originally posted by davey23uk
    download the 9.2.0.6 patchset from metalink - read the instructions
    FOOKIN GENIUS!!
    I remember when this place was cool.

  4. #4
    Join Date
    Jan 2003
    Posts
    141
    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,

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    download the patchset for 9.2.0.6 for windows xp 86 database server, under the patches menu

    It is quite clearly listed there.

  6. #6
    Join Date
    Jan 2003
    Posts
    141
    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??

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    no, you want 9.2.0.6 !!!!

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width