14 Replies Latest reply: Sep 25, 2012 5:56 AM by Srini Chavali-Oracle RSS

    apply patch from 10.2.0.1 to 10.2.0.5

    Harsh_v
      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
          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
            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
              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
                kuljeet singh -
                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.
                  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
                    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
                      please help
                      • 8. Re: apply patch from 10.2.0.1 to 10.2.0.5
                        Balazs Papp
                        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
                          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
                            silent install doesn't require GUI
                            • 11. Re: apply patch from 10.2.0.1 to 10.2.0.5
                              Harsh_v
                              thanks sir... for give ur good timing
                              • 12. Re: apply patch from 10.2.0.1 to 10.2.0.5
                                Harsh_v
                                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
                                  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
                                    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