Oracle migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle migration

  1. #1
    Join Date
    May 2007
    Posts
    2

    Unhappy Oracle migration

    Hello all,
    I need a little help here. I'm looking for the file where it is described, step by step, how to migrate from Oracle 8.1.5 to Oracle 8.1.6. on Windows environment (NT and 2000Server).

    I have a big problem with a 8.1.5 bug linked with the Wrap number that blocked my DB's (more than 100!!!! :( ). The only solution Metalink and Oracle support gave me is to upgrade the 8.1.5 to any other version. Since the impact of an upgrade on my machines could be huge I want to start upgrading to the 8.1.6 before moving to newer version. Unfortunately I don't seem to find any docs like the one I found to migrate to 8.1.7 "Upgrading from a previous version 8 release to the new oracle8i release". I could download the whole docs from the oracle site, but the file is too big and my internet connection si slow and jumps quite often. So if any of you could tell me where to find the part of the document that I need I would be very grateful.

    The document I'm talking about is at this link, but, as I said, it is too big for me.

    http://www.oracle.com/technology/doc..._arch_815.html

    I hope I was clear enough. I tend to get a bit mixed up with my brain :P
    Thank you from now for any help or interest.

    Phelit Leafwise

  2. #2
    Join Date
    Sep 2001
    Posts
    200
    What if you just create a new db and export and dump in the new/higher version?
    Life is what is happening today while you were planning tomorrow.

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Did Oracle specifically recommend you to move from 8.1.5 to 8.1.6?
    8.1.6 is not even the top of 8i version.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    May 2007
    Posts
    2
    ndisang: I could create a new db and start again, but we are talking of more than 100 db's arount one whole country for a total of about 50.000.000 rows and more! It would be WAY too long!!

    PAVB: Oracle said we should move to at least 9i, but the problem is that we have a lot of programs and applications that are linked to these db's so we are trying to update to 8.1.6 first so that we don't have to create new applications, and then test new possibilities.

    Thx!

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