This discussion is archived
6 Replies Latest reply: Sep 4, 2012 12:07 AM by Marco V. RSS

Upgrading from oracle 8i to oracle 11g

673082 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    >

    >
    -> 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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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. Expert
    Currently Being Moderated
    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

Legend

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