gotcha when upgrading from 8i to 9iR2?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: gotcha when upgrading from 8i to 9iR2?

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    gotcha when upgrading from 8i to 9iR2?

    I need to upgrade existing DBs from 8.1.7.3 to 9.2.0.1. For those who have experiences with this upgrade path, are there any gotchas?

    Also, can I upgrade 8.1.7.3 Standard edition to 9.2.0.1 Enterprise edition in one shot?

    Appreciated.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: gotcha when upgrading from 8i to 9iR2?

    Originally posted by a128
    I need to upgrade existing DBs from 8.1.7.3 to 9.2.0.1. For those who have experiences with this upgrade path, are there any gotchas?
    No.

    Originally posted by a128

    Also, can I upgrade 8.1.7.3 Standard edition to 9.2.0.1 Enterprise edition in one shot?

    Appreciated.
    Depends. If you are a good dba then yes. If not then no.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Migration guide spells out if you can go directly from one version to another, or if you have to do an intermediate upgrade.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I wouldn't stop at 9.2.0.1 -- apply the subsequent patches to go to 9.2.0.3(I think that's the most recent version)
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    the gotcha's I have seen are people not testing the migration path, you should really try that
    I'm stmontgo and I approve of this message

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If your concerned about trusting you database to the migration assitant you can always do it manually

    http://support.oracle.co.uk/metalink...&p_id=159657.1

    But as with all things like this make sure you test it first.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  7. #7
    Join Date
    Apr 2001
    Posts
    257
    Thanks guys!

    I have one more question: When upgrading a DB from 8.1.7 to 9.2, I presume I need as much available HD space as the size of the DB to be upgraded? The migration guide says the migration assistant will check for available disk space but currently I am trying to see if my existing server has enough HD space. If not, I won't bother install Oracle 9.2 software on the server (maxed out the storage) but to build anther one.

    What happen after the upgrade? I will have two set of same DB, one for 8i and the other for 9i?

    I hope 8i and 9i's listeners won't both default to 1521 right after the install...

    Thanks again

  8. #8
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    * You will need enough space to install both product sets, i.e. 8i and 9i I think 9i is just over 2.5Gb for a full install.

    * When you perform the migration you will have only one DB the new migrated one.

    * By default it will try to configure the 9i listener on port 1521.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  9. #9
    Join Date
    Apr 2001
    Posts
    257
    I just installed Oracle 9i software only (with no new DB installed) on a Windows 2000 system with existing 8i home. I notice there is NO 9i listener installed but the existing 8i is still there and running.

    The 9i home is completed seperated from the 8i's. Does anybody know why no 9i listener is installed (thus I don't see it in Windows 2000 "Services")

    Thanks,

  10. #10
    Join Date
    Sep 2002
    Posts
    411
    you can simply use lsnrctl of 9i to start the listener and you will have one or create a dummy database so Oracle can create the listener after the datbabase is created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width