This discussion is archived
12 Replies Latest reply: Jun 15, 2011 9:39 AM by user130038 RSS

Upgrade 9i to 11gR2

736258 Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    >
    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 Oracle ACE Director
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    >
    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 Newbie
    Currently Being Moderated
    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
    SalmanQureshi Expert
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Great - thank you so much!

    Amer

Legend

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