12 Replies Latest reply: Dec 12, 2012 9:46 AM by 940673 RSS

    Oracle Upgrade From 11.2.0.1 to 11.2.0.3

    940673
      Hi All,

      I am perfoming a upgradation from 11.2.0.1 to 11.2.0.3. This is the first time I am performing this task, so I need help you to assist me in this.

      Should I have to download latest software from Oracle Support i.e 11.2..0.3 for this as a initial task???

      Any important links for this will be helpful for me. I tried searching this in google but those are helpful or may I am not able to understand. :(

      Please help me in this..

      Regards,
      Arijit
        • 1. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
          Fran
          check:
          http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD52700
          • 2. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
            940673
            Hi Fran,

            Can I download the software available in OTN. I mean is the software version is 11.2.0.3, if it is so can I download it??

            Regards,
            Arijit
            • 3. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
              Fran
              yes.
              patch ID 10404530:
              https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530

              Another interesting link:
              http://g-tech-blog.blogspot.com.es/2012/04/update-oracle-from-11201-to-11203.html
              • 4. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                Rob_J
                Hello,

                I have written out my exact notes that I used when upgrading from 10g to 11g. Although there might be differences and you should most definitely check the documentation, there will be a lot of similarities and this guide will help you upgrade.

                [url http://www.ora00600.com/articles/10g-to-11g-database-upgrade.html] Oracle 10g to 11g upgrade

                Also, this might not be relevant to you because you are already on 11g but there was a new [url http://www.ora00600.com/scripts/11g/10g-to-11g-upgrade.html]Resource Manager Plan in 11g which was enabled by default and it caught me out after we had rolled the upgrade to PROD so check for that.

                Hope it helps,
                Rob
                • 5. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                  P.Forstmann
                  You can only download 11.2.0.3 patchset from My Oracle Support site. You cannot download it from OTN.
                  README with media gives high level upgrade instructions.

                  You need also to use Upgrade Guide: http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm.
                  • 6. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                    940673
                    HI,

                    As per your reply Oracle 11.2.0.3 software is not readily available in ORCALE Site. Only I can download the patch set of 11.2.0.3, which I wil be surely download for the site.

                    My first task wil be of creating a new ORACLE_HOME for the latest version. How can I do it if I dont have the software??

                    Please assist me as I am compeletly new to it..

                    Regards,
                    Arijit
                    • 7. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                      Srini Chavali-Oracle
                      Pl post your OS details. As noted above, 11.2.0.3 is only available from MOS for those customers who have a paid support contract with Oracle.

                      The Install Guides for 11.2.0.3 are at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

                      Upgrade Guide is at http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

                      HTH
                      Srini
                      • 8. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                        940673
                        Hi,

                        Thanks for all your reply. I am using teh below OS version:-

                        Linux blrulvremoradb01 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

                        I will download the mentioned patch sets as I have metalink support id with Oracle Support. I will let you know if I face any issues.

                        Regards,
                        Arijit
                        • 9. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                          940673
                          HI All,

                          Steps I have done is given below till now:-

                          Step 1:- I have created a new oracle home as "/u01/app_new/oracle/product/11.2.0.3/db_1" for the latest version.

                          My existing oracle home is at "/u01/app/oracle/product/11.2.0/db_1".

                          Step 2: Earlier I have downloaded 11.2.0.1 binaries and kept it in a location. I have start the runInstaller file and chosen the upgrade existing database.

                          Am I in a right track??

                          Regards,
                          Arijit
                          • 10. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                            Srini Chavali-Oracle
                            You need to download 11.2.0.3 from MOS and install it in the new ORACLE_HOME "/u01/app_new/oracle/product/11.2.0.3/db_1" before you can start the upgrade.

                            Pl follow the steps in the Upgrade Guide linked above.

                            HTH
                            Srini
                            • 11. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                              Rob_J
                              Read through all the guides and write down the parts which apply to your environment and do the necessary checks. Once complete, you should have a full list of what needs to be done and in what order. Then double check it. Only then should you start attempting to upgrade your DB, even if it's DEV. An Oracle upgrade is where the saying "If you fail to plan, you plan to fail" comes from...If you don't plan it out properly I can guarantee you that it will not work first time.
                              • 12. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
                                940673
                                Thanks for your suggestions. I am downloading the patches from the link given. Post that I will go through the upgradation guide and do the needful.

                                I'll let you know if I face any problems.

                                Thanks again all for your help..

                                Regards,
                                Arijit