12 Replies Latest reply: Jun 15, 2011 11:39 AM by user130038 RSS

    Upgrade 9i to 11gR2

    736258
      Hi,

      Is it possible to upgrade a 9.2.0.8 database to 11gR2 without grid infrastructure and asm?

      Thank you.

      Sam
        • 1. Re: Upgrade 9i to 11gR2
          Srini Chavali-Oracle
          Absolutely yes - see the Upgrade Guide at http://download.oracle.com/docs/cd/E11882_01/server.112/e10819/toc.htm

          HTH
          Srini
          • 2. Re: Upgrade 9i to 11gR2
            736258
            Thank you for your response, Srini.

            Before the upgrade begins, we need to install Oracle 11gR2 in a seperate home first. During the Oracle 11gR2 software installation, can we ignore the grid infrasturucutre/ASM installation?

            The link you provided seems not saying that. Can you point me to the page#?


            Thanks for your help.
            • 3. Re: Upgrade 9i to 11gR2
              725039
              >
              Before the upgrade begins, we need to install Oracle 11gR2 in a seperate home first.
              >

              Can not happen.... Oracle will not let you install Oracle 11gR2 binaries into a pre-existing Oracle Home.

              Regards,
              Phiri
              • 4. Re: Upgrade 9i to 11gR2
                Srini Chavali-Oracle
                Pl choose the option to "Install Database Software Only" to install the binaries in a new ORACLE_HOME.

                http://download.oracle.com/docs/cd/E11882_01/install.112/e10848/inst_task.htm#BABBBHJH

                HTH
                Srini
                • 5. Re: Upgrade 9i to 11gR2
                  725039
                  >
                  The link you provided seems not saying that. Can you point me to the page#?
                  >

                  I would go through the entire 178 page upgrade manual if I were you. You might also want to go through the link below.

                  http://www.oracle.com/technology/products/database/oracle11g/upgrade/index.html

                  Regards,
                  Phiri
                  • 6. Re: Upgrade 9i to 11gR2
                    736250
                    It's confirmed that Grid Infrastructure is not required. We can continue using the standard file systems.

                    Thank you for sharing your knowlege. You're awesome!!!
                    • 7. Re: Upgrade 9i to 11gR2
                      Salman Qureshi
                      Hello,
                      Just admiration will not work :), it would be good if you can reward the people with points :)
                      Any way, you need following patch to apply before you upgrade to 11gR2, other wise upgrade might face error "sys.dbms_java must be declared"

                      p9315778_112010_Generic.zip


                      Salman
                      • 8. Re: Upgrade 9i to 11gR2
                        user130038
                        Hi there,

                        I know this is over an year old thread. I was looking for a manual/guide to help me with oracle *9i (non-rac) to 11gr2 (with ASM+RAC)* migration [both 9i and 11gr2 on OEL 4.7 - I am doing this exercise at home using VMWare to prepare myself for actual upcoming project at work]. The URLs provided in the previous posts are no loger valid. I'll continue my search but if someone can help point to the valid documents/guides, it will be highly appreciated.

                        Thanks in advance!

                        Amer
                        • 9. Re: Upgrade 9i to 11gR2
                          Srini Chavali-Oracle
                          I would recommend you upgrade to 11gR2 first, then convert to ASM and RAC.

                          Oracle 11gR2 Upgrade Companion (Doc ID 785351.1)
                          http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/toc.htm (http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/afterup.htm#CEGEDDAE)

                          HTH
                          Srini
                          • 10. Re: Upgrade 9i to 11gR2
                            user130038
                            Hi Srini,

                            Thank you for the URL. I'll go through it.

                            Is there also a document/guideline for converting to AMS and RAC after the upgrade?

                            And one more question - how do people award points for helpful answers?

                            Thanks again!

                            Amer
                            • 11. Re: Upgrade 9i to 11gR2
                              Srini Chavali-Oracle
                              I do not have experience with ASM/RAC - the GI Install Guide has the needed steps to install ASM - http://download.oracle.com/docs/cd/E11882_01/install.112/e17212/toc.htm

                              RAC Guides are here

                              http://download.oracle.com/docs/cd/E11882_01/install.112/e17214/toc.htm
                              http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/toc.htm

                              There are dedicated fora for ASM/RAC at http://forums.oracle.com/forums/category.jspa?categoryID=140 that can hopefully provide better answers.

                              HTH
                              Srini

                              PS - Points are meaningless - they can only be awarded by the original poster.
                              • 12. Re: Upgrade 9i to 11gR2
                                user130038
                                Great - thank you so much!

                                Amer