This discussion is archived
14 Replies Latest reply: Sep 25, 2012 3:56 AM by Srini Chavali-Oracle RSS

apply patch from 10.2.0.1 to 10.2.0.5

Harsh_v Newbie
Currently Being Moderated
Hi Experts,


i want upgrade my oracle 10.2.0.1 to 10.2.0.5.

But on office side not able access oracle GUI. work only on Putty. please tell me how to upgrade my oracle using commands only.

Can we upgrade it, if yes please me how to do and which patch required for it.

>

using Oracle version = 10.2.0.1
OS = Red hat 5.5

>


Reg,
Harshit
  • 1. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Balazs Papp Expert
    Currently Being Moderated
    there is a sample response file provided with the installer media
    edit this, than run the installer with it
    ./runInstaller -silent -responseFile response.rsp
    patch can be obtained from https://support.oracle.com/
  • 2. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Veeresh.S Pro
    Currently Being Moderated
    Download the patch 8202632, have a look on its readme, there is something like silent upgrade where you dont required GUI to upgrade.

    Ref : http://docs.oracle.com/cd/B19306_01/server.102/b14238/upgrade.htm#i1011981
  • 3. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    Hi

    please tell me.... oracle database and oracle software upgrade separate or together.

    Reg...
  • 4. Re: apply patch from 10.2.0.1 to 10.2.0.5
    KuljeetPalSingh Guru
    Currently Being Moderated
    928992 wrote:
    Hi

    please tell me.... oracle database and oracle software upgrade separate or together.

    Reg...
    not together but one by one.
    first you have to install the 10.2.0.5 software on existing oracle home
    then run catpatch.sql script in database.
    you can find complete detail in README.txt file available under PATCH software.
  • 5. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Marco V. Expert
    Currently Being Moderated
    Always read the README.txt file in the patchset
  • 6. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    Thanks for all the replies,

    Please clear something not clear in patching-

    >

    1) what is diff between Opatch and interim patch.

    >

    >

    2) I have Oracle database 10g release 10.2.0.1, and I want to upgrade it to release 10.2.0.5.
    Then, in this case should I use OPatch? or should I run the OUI (./ runInstaller downloaded path)?

    >

    >

    3) if i want apply patch using "-silent" installation, can you please step by step installation.
    when i go for "-silent", every time i am facing issue in very basic steps.

    >

    >

    4) Also, how many types of patches are there like bug fixes, enhancements, upgrades, and how they are applied? do they affect only the software? or, do they also affect the database too.

    >


    Reg...
    Harshit
  • 7. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    please help
  • 8. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Balazs Papp Expert
    Currently Being Moderated
    1) what is diff between Opatch and interim patch.
    Opatch is just the tool for applying interim/one-off patches and PSU/CPU-s
    2) I have Oracle database 10g release 10.2.0.1, and I want to upgrade it to release 10.2.0.5.
    Then, in this case should I use OPatch? or should I run the OUI (./ runInstaller downloaded path)?
    no need for OPatch, you use OUI
    (you cant even use OPatch for this kind of upgrade)
    3) if i want apply patch using "-silent" installation, can you please step by step installation.
    when i go for "-silent", every time i am facing issue in very basic steps.
    ./runInstaller -silent -responseFile myResponseFile.rsp

    Fill the sample response file provided with the install media by appropriate values for your enviroment.
    4) Also, how many types of patches are there like bug fixes, enhancements, upgrades, and how they are applied? do they affect only the software? or, do they also affect the database too.
    Base release: 11.2.0.1
    Patch set: 11.2.0.3

    these are installed with OUI, the rest with opatch
    also, since 11.2, Patch sets can be installed individually without the base release

    Patch set update, for example: 11.2.0.3.3 - general fixes
    Critical patch update: released in every 4 months (JAN-APR-JUL-OCT), contains security patches

    The last two tend to come together in the same pack since a while.

    One-off patch: patch for one specific bug
    Interim patch: patch for specific bug for a specific customer (received through support service request)

    of course they affect both software and database (majority of them)
    to mention one exception, there is a one-off patch for 10.2 databases that issues the SSL certification problem for Enterprise Manager database console - actually this patch just updates some .jar files in $ORACLE_HOME and has no effect on the database
  • 9. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    thank you so much Balazs Papp......


    one thing please more explain.
    when we install patch using "-silent" ,as you tell me

    >
    ./runInstaller -silent -responseFile myResponseFile.rsp
    >

    this statement required GUI or not. if yes it required GUI, so please tell me sir how to install patch without GUI.
    I asking because in my office i have not support GUI, only working on Putty and i want install oracle patch 8202632 (which upgrade 10.2.0.1 to 10.2.0.5).


    Reg,
    Harshit
  • 10. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Balazs Papp Expert
    Currently Being Moderated
    silent install doesn't require GUI
  • 11. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    thanks sir... for give ur good timing
  • 12. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Harsh_v Newbie
    Currently Being Moderated
    hi 928992 ............

    can u please send ur response file for silent installation. Actually i am facing this issue from long time. something always wrong.

    u can send this file to my email id too
    email id = harshitverma87@gmail.com


    Reg...
    harshit
  • 13. Re: apply patch from 10.2.0.1 to 10.2.0.5
    964103 Newbie
    Currently Being Moderated
    I have oracle 10g 10.2.0.1 and I want update it to 10.2.0.5,can it do ?
  • 14. Re: apply patch from 10.2.0.1 to 10.2.0.5
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    961100 wrote:
    I have oracle 10g 10.2.0.1 and I want update it to 10.2.0.5,can it do ?
    Pl open a new thread for your issue - it is considered to be rude to hijack another thread.

    For your question, the answer is yes - just follow the steps in the README for 10.2.0.5 patch

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points