11 Replies Latest reply: Nov 29, 2012 4:03 PM by F.Munoz Alvarez RSS

    Migrating from 8i to 11g

    Nishant Santhan
      Dear all,

      I would like to know which is the best method for migrating 8i database to 11g..? (Exp/imp, Manually ( Both the OS are Same) or DBUA)

      If you are going for exp/imp.. Can we do it directly?

      OS is HP unix
      Database size would be around 10 GB.

      Thanks in advance
      Nishant
        • 1. Re: Migrating from 8i to 11g
          F.Munoz Alvarez
          Dear Nishant,

          You can't go direct to 11g from 8i (except using exp/imp), All depend of your 8i version; if you are using 8.1.7.4 you will need to upgrade to 9.2.0.8 and then to 11.1, if using a lower version you will need to upgrade to 8.1.7.4, then to 9.2.0.8 and to 11.1.

          Please read the upgrade guide, there you will find all the information you need, like all the options you have to migrate and how to migrate using them


          http://download.oracle.com/docs/cd/B28359_01/server.111/b28300.pdf

          Best Regards,

          Francisco Munoz Alvarez
          http://oraclenz.wordpress.com

          Edited by: F.Munoz Alvarez on Nov 30, 2012 11:02 AM
          • 2. Re: Migrating from 8i to 11g
            Sabdar Syed
            First of all direct upgrade is not possible from Oracle 8i to 11g.
            What's your four digit of the Oracle 8i Database? indirect upgrade can be done as the foolowing version,

            8.0.5 (or lower) -> 8.0.6 -> 9.2.0.8 -> 11.1
            8.1.7 (or lower) -> 8.1.7.4 -> 9.2.0.8 -> 11.1

            First decide the upgrade path

            http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#i1007814

            Second Choose an Upgrade Method

            * Database Upgrade Assistant
            * Manual Upgrade
            * Export/Import

            http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#i694345

            Export/Import Method (as you wish to do)

            http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#BABFHFIJ

            References:

            Oracle® Database Upgrade Guide 11g Release 1 (11.1)

            http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/toc.htm

            Oracle Metalink Note:429825.1
            Subject: Complete Checklist for Manual Upgrades to 11gR1

            Oracle Metalink Note:132904.1
            Subject: Compatibility Matrix for Export And Import Between Different Oracle Versions

            Regards,
            Sabdar Syed.
            • 3. Re: Migrating from 8i to 11g
              Nishant Santhan
              Thanks Mr.Francisco Munoz Alvarez,
              You can't go direct to 11g from 8i (except using exp/imp)
              That mean using exp/imp we can do direct right?

              I am planning to go for exp/imp.. I did not read the document which you provided, before doing the operation I will read that..

              Once more thanks for the reply

              Nishant
              • 4. Re: Migrating from 8i to 11g
                Nishant Santhan
                Thanks Mr.Sabdar Syed,

                I am going for exp/imp.

                Thanks for the references..

                Regards,
                Nishant
                • 5. Re: Migrating from 8i to 11g
                  Sabdar Syed
                  Welcome.

                  Refer the Oracle Metalink Note which I have already specified in the above reply.

                  Oracle Metalink Note:132904.1
                  Subject: Compatibility Matrix for Export And Import Between Different Oracle Versions

                  Regards,
                  Sabdar Syed.
                  • 6. Re: Migrating from 8i to 11g
                    Nishant Santhan
                    Thanks Sabdar Syed, I will do that
                    • 7. Re: Migrating from 8i to 11g
                      F.Munoz Alvarez
                      Dear Nishant,


                      Take a look in this Metalink note that Sabdar Syed mention on his post.

                      Oracle Metalink Note:132904.1
                      Subject: Compatibility Matrix for Export And Import Between Different Oracle Versions

                      Can you let us know your current Version of Oracle? 8.x.x.x

                      Best Regards,

                      Francisco Munoz Alvarez
                      http://oraclenz.wordpress.com

                      Edited by: F.Munoz Alvarez on Nov 30, 2012 11:02 AM
                      • 8. Re: Migrating from 8i to 11g
                        Nishant Santhan
                        Hi,

                        Today I directly migrated 8i dump to 11g DB in widows 2003 Server. Its worked well but only thing is 209 invalid objects are there.
                        Can you let us know your current Version of Oracle? 8.x.x.x
                        I guess its 8.1.5

                        While importing I got some errors like unique constraint violated..

                        I just wanted to know because of this error I got invalid objects?

                        I ran utlrp script but its not reducing..

                        The command I used to import is

                        imp file=/dumpfile path full=y ignore=y log=/logfile path

                        is there any other way to import the full dumpfile which will avoid these invalid objects issues?

                        Thanks in advance

                        Nishant Santhan
                        • 9. Re: Migrating from 8i to 11g
                          F.Munoz Alvarez
                          Hi Nishant,

                          Recreate the invalid synonyms.
                          Recompile the views, packages, functions, procedures, triggers,etc...

                          run:
                          select owner, object_name, object_type, status
                          from dba_objects
                          where status != 'VALID';
                          Regards,

                          Francisco Munoz Alvarez
                          http://oraclenz.wordpress.com

                          Edited by: F.Munoz Alvarez on Nov 30, 2012 11:03 AM
                          • 10. Re: Migrating from 8i to 11g
                            Nishant Santhan
                            Thanks..
                            Recreate the invalid synonyms.
                            Recompile the views, packages, functions, procedures, triggers,etc...
                            I did that but still I am getting errors like complied with errors.. Is there any other way? or can we avoid this by using another parameter while importing time itself?

                            Thanks
                            • 11. Re: Migrating from 8i to 11g
                              F.Munoz Alvarez
                              Hi,

                              did you fix all the synonyms?

                              Please run this query and post the result.
                              select owner, object_type, count(*)
                              from dba_objects
                              where status =  'INVALID'
                              group by owner, object_type;
                              Regards,

                              Francisco Munoz Alvarez
                              http://oraclenz.wordpress.com

                              Edited by: F.Munoz Alvarez on Nov 30, 2012 11:03 AM