This discussion is archived
7 Replies Latest reply: Aug 20, 2013 6:57 AM by RameshVKhanna RSS

Migration Plan from Oracle 8i to 11g

651277 Newbie
Currently Being Moderated
Dear all.

I've got some questions that are about migration. At the moment I have a customer which has a server as I describe below:

- HP PA Risc 9000/800 Dual Core 800Mhz RP3410, 1 processor, 4Gb RAM and 2 disks SCSI of 72Gb each
- ERP with internal development using Oracle Technology / Web (PL/SQL generating HTML) with packages stored in the same database.
- Oracle 8i Database (8.1.6)
- Database with 44Gb approx.
- OS = HP-UX B.11.11 64 bits
- Backup system = Archives and dump recorded in tapes daily

With those specifications I would like, if it's possible, some recommendations for a migration to 11g.

Questions:

1 - Is it possible to migrate from 8i straight to 11g? Will there be a lot of problems?
2 - What's the best plan to follow? For example: a) backup the entire db. b) create another specific directory for 11g instalation files. c) export and import full db.

Could anyone just reply a plan for a upgrade like that? The best methods and tips?

Thanks a lot
  • 1. Re: Migration Plan from Oracle 8i to 11g
    user097815 Journeyer
    Currently Being Moderated
    take a look at this metalink doc...very helpfull

    Subject:      Complete checklist for manual upgrades of Oracle databases from anyversion to any version on any platform (documents only from 7.3.x>>8.0.x>>8.1.x>>9.0.x>>9.2.x>>10.1.x>>10.2.x>>11.1.x)

    Doc ID:      421191.1
  • 2. Re: Migration Plan from Oracle 8i to 11g
    591186 Guru
    Currently Being Moderated
    ? Is it possible to migrate from 8i straight to 11g? Will there be a lot of problems?
    it depends upon the version release you're in.
    if you're in 8.1.7.4, then
    its a two step process to 11g.

    8.1.7.4 =>10gR2
    10GR2=>11g

    Check this one:
    http://www.oracle.com/technology/products/database/oracle11g/upgrade/presentations/oow2008_upgrade11g_hitchhikersguide.pdf
    Complete Checklist for Manual Upgrades to 11gR1 - 429825.1
    Oracle 11g Upgrade Companion - 601807.1
  • 3. Re: Migration Plan from Oracle 8i to 11g
    user097815 Journeyer
    Currently Being Moderated
    exp/imp would be your best pet....as original exp/imp is still supported by 11g....so create a new DB for 11g...
    then create the same user/roles/profiles on 11g from 8i .... create all the tablespace/datafiles...and export from 8i ...move the .dmp to 11g server and imported it....

    dont forget to gather stats after moving to 11g...
  • 4. Re: Migration Plan from Oracle 8i to 11g
    651277 Newbie
    Currently Being Moderated
    Hi all.

    So, thanks for helping me. I've just read at metalink and I got some informations I needed. And it's recommended some upgrades from 8i to 11g following the matrix below:

    Compatibility Matrix

    Minimum Version of the database that can be directly upgraded to Oracle 11g Release 1

    Source Database -->Target Database
    9.2.0.4.0 (or higher) --> 11.1.x
    10.1.0.2.0 (or higher) --> 11.1.x
    10.2.0.1.0 (or higher) --> 11.1.x

    The following database version will require an indirect upgrade path.

    Source Database --> Upgrade Path for Target Database --> Target Database
    7.3.3.0.0 (or lower) --> 7.3.4.x --> 9.2.0.8 --> 11.1.x
    8.0.5.0.0 (or lower) --> 8.0.6.x --> 9.2.0.8 --> 11.1.x
    8.1.7.0.0 (or lower) --> 8.1.7.4 --> 9.2.0.8 --> 11.1.x
    9.0.1.3.0 (or lower) --> 9.0.1.4 --> 9.2.0.8 --> 11.1.x

    For example:

    If source database is 8.1.7.0.0, the upgrade path to be followed is as below:
    8.1.7.0.0 --> 8.1.7.4 --> 9.2.0.8 --> 11.1.x.

    Does that mean if I want to upgrade from 8i to 11g that I must install the 9i in a new ORACLE_HOME and to upgrade for 11g I must install in another new ORACLE_HOME?

    Thanks a lot

    Edited by: Bruno Palma on Apr 1, 2009 4:47 PM
  • 5. Re: Migration Plan from Oracle 8i to 11g
    591186 Guru
    Currently Being Moderated
    Does that mean if I want to upgrade from 8i to 11g that I must install the 9i in a new ORACLE_HOME and to upgrade for 11g I must install in another new >ORACLE_HOME?
    Yes.


    Take a full cold-backup of the database and pfile at every level.
  • 6. Re: Migration Plan from Oracle 8i to 11g
    651277 Newbie
    Currently Being Moderated
    Hey Anhanta, thank you very much.

    Just some doubts I still have.

    OK, I understand I must upgrade from 8i (8.1.6) to 9i (last release) "Reading that document in Metalink I could see that", creating a new ORACLE_HOME for the installation. And then upgrade from 9i to 11g (11.1.x) installing another new ORACLE_HOME. It means I'll have 3 ORACLE_HOMES .. right?

    Basicly, what are the steps after the version updates?
    - Let's think I updated from 8i to 9i and everything was fine. I created a database to receive the data from my old database. How should I do this process? Exporting the entire database from 8i and importing on 9i? Test the conection? After that, if all are OK, backup the entire database again, right?

    And do the same things at the 11g update progress?

    Thanks a lot for the informations.
  • 7. Re: Migration Plan from Oracle 8i to 11g
    RameshVKhanna Newbie
    Currently Being Moderated

    I know this question posted on Apr 1, 2009 8:56 PM and ended up with wrong direction so I want reiterate with right directions.

     

     

    Since this is 8i DB and exp/imp approach we can directly upgrade the DB to 11g instead of (staging ) going to 9i.

    1.create the db at 11g.

    2.export (exp) from 8i db

    3.move the dump file to 11g db server.

    4.import(imp) using the 11g binary.

     

    _rameshK.

Legend

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