what is the standard practice to upgrade Oracle DB bin dir during a patchset install?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: what is the standard practice to upgrade Oracle DB bin dir during a patchset install?

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    what is the standard practice to upgrade Oracle DB bin dir during a patchset install?

    hi,

    I have not install a patchset in a PRODUCTION Oracle DB,so would like to collect any feedback on the standard practices for doing that?
    Because i understand a patchset installation require it to be performed on the current Oracle Home directory where the production binaries and I guess it's not wise to overwrite that current binary dir,was thinking :

    1) of doing a wholesale cp of the current binary into the new patchset version directory newly created and perform the patchset installation there ?? OR

    2) Installing the current binary version again in the new patachset version newly created and then perform the patchset installation there ??


    Are those industry standard practise?? Any DBA gurus can enlighten?

    thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: what is the standard practice to upgrade Oracle DB bin dir during a patchset inst

    Originally posted by ngwh

    2) Installing the current binary version again in the new patachset version newly created and then perform the patchset installation there ??
    That's the way I do it. New $ORACLE_HOME, patch new $ORACLE_HOME, shutdown db, startup with new $ORACLE_HOME, run catalog/catpatch scripts.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    backup $ORACLE_HOME orainventory, apply patch, if anything goes wrong uninstall patch using OUI, if thing goes wrong after that restore orainventory and $ORACLE_HOME

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    pando,

    ok assumming using your method what if I wanna change my $ORACLE_HOME which is say original under /usr01/9.2.0.1 ?? after i install that 9.2.0.5 patchset..can i rename that '9.2.0.1' UNIX directory into 9.2.0.5 ?? would there be any issue??

    thks in advance

  5. #5
    Join Date
    May 2001
    Posts
    736
    Instead of complicating the things better use Mr.Jeff option.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    who on earth would want to rename ORACLE_HOME after apply a patch...??

  7. #7
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    pando,

    no...given a scenairo like :

    /d01/9.2.0.1 is the original installation later if u wanna install a patchset 9.2.0.3 into /d01/9.2.0.1...then mabbe I wanna hv a direct /d01/9.2.0.3 ???..Dont think i can juz rename /d01/9.2.0.1 to /d01/9.2.0.3 rite?

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    of course not

    again, who on earth would do that, you will be the first one I see...

    you are breaking your orainventory

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