6 Replies Latest reply: Sep 4, 2012 2:07 AM by Marco V. RSS

    Upgrading from oracle 8i to oracle 11g

    673082
      current Oracle version is 8i
      front end is visual basic 6
      OS is windows xp
      client OS is windows xp

      I guess this question has been asked a lot in here.

      But i guess i have some extra queries here

      -> I m using oracle 8i and now I want to upgrade it to 11g. Is there any complications. I mean can i simply export a dump file from oracle 8i and import it in oracle 11g using imp tool, importing everything. If not what are not imported and what are other complications and consequences.

      -> My front end is vb 6 so is there gonna be any problem. If it's unsupported which version would u prefer for vb 6

      -> Can i install oracle 11g in windows xp or at least can i install oracle client in xp.

      -> what kind of server would you suggest for oracle 11g.


      Is there anybody to help me out here as quickly as possible.

      Thanx a lot

      Edited by: Ishan on Jun 17, 2009 5:35 AM
        • 1. Re: Upgrading from oracle 8i to oracle 11g
          P.Forstmann
          >

          >
          -> I m using oracle 8i and now I want to upgrade it to 11g. Is there any complications. I mean can i simply export a dump file from oracle 8i and import it in oracle 11g using imp tool, importing everything. If not what are not imported and what are other complications and consequences.
          Like any other full export/import, almost everything will be imported but not everything :http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm#i1023130

          Each Oracle version has some incompatibilities with previous version: you should check every Upgrade/Migration Guide starting with Oracle 9i to check the incompatibility list with previous versions.

          It's likely that you will have some performance issues linked to the automatic computing of database statistics http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/stats.htm#CIHDGIID
          and behaviour changes in the way queries are compiled (CBO changes).

          You need to do a lot of testing: http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#i1008175 because a lot of things have changed and only testing your applications in your upgraded test database can give you the problems you will have.

          Edited by: P. Forstmann on Jun 17, 2009 4:18 PM
          • 2. Re: Upgrading from oracle 8i to oracle 11g
            591186
            8i->11g direct is not possible.

            Available option: Export and import.

            You can upgrade to 9i from 9i to 11g is possible.

            Oracle 11gR1 Upgrade Companion-601807.1 from metalink has all the information.
            Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1
            Note 263809.1 Complete checklist for manual upgrades to 10gR1 (10.1.0.x).
            Note 316889.1 Complete checklist for manual upgrades to 10gR2.
            Note 466181.1 10g Upgrade Companion
            Note 601807.1 Oracle 11gR1 Upgrade Companion
            419550.1 - Different Upgrade Methods For Upgrading Your Database-

            Edited by: Anantha on Jun 17, 2009 1:31 PM
            • 3. Re: Upgrading from oracle 8i to oracle 11g
              Saugat Chatterjee
              i have to upgrade the databse from 8.1.4 to 11.2

              i have imported an export file from 8.1.7 to 11.2 it goes fine without errors but i know that there are still something left that dint gets upgraded so

              now please guide me what are the things that i have to change or set to upgrade the 8.1.7 to 11.2 completely
              • 4. Re: Upgrading from oracle 8i to oracle 11g
                Srini Chavali-Oracle
                saugat chatterjee wrote:
                i have to upgrade the databse from 8.1.4 to 11.2
                Pl create a new thread for your question, instead of hijacking an old thread.
                Pl post your OS details.
                i have imported an export file from 8.1.7 to 11.2 it goes fine without errors but i know that there are still something left that dint gets upgraded so
                Were any errors recorded in the export or import logs ? What do you mean by "i know that there are still something left that dint gets upgraded" - how did you determine that ?
                now please guide me what are the things that i have to change or set to upgrade the 8.1.7 to 11.2 completely
                Follow the steps in the Upgrade Guide - http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e17222/toc.htm

                Srini
                • 5. Re: Upgrading from oracle 8i to oracle 11g
                  Saugat Chatterjee
                  os is windows XP

                  and i know that the profiles associated with the users are not upgraded if we use the export/import method for upgradation

                  i want to know that wat are the other things that didnt gets upgraded if we use the export/import method

                  thanx in advance
                  • 6. Re: Upgrading from oracle 8i to oracle 11g
                    Marco V.
                    Your answer is here on metalink:
                    - Complete checklist for manual upgrades of Oracle databases from any version 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>>11.2.x) [ID 421191.1]
                    - Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

                    Read also "Best Practices for Upgrading to Oracle Database 11g Release 2":
                    http://www.oracle.com/technetwork/database/upgrade/best-practices-for-upgrading-11gr2-174946.pdf