7 Replies Latest reply: Aug 20, 2013 8:57 AM by RameshVKhanna RSS

    Migration Plan from Oracle 8i to 11g

    Bruno Palma
      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
          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
            ? 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
              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
                Bruno Palma
                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
                  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
                    Bruno Palma
                    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

                      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.