Skip to Content
author's profile photo Former Member
Former Member

Upgrade oracle 8.0.4 on NT to 8.1.7 and then to 9.2 on win2k3


my current system is on win NT with kernel 4.0B with oracle 8.0.4.

First i need to upgrade the database from 8.0.X to 8.1.7 on windows NT.

After the above i need to move the production server to windows 2003.

My production server is new hardware. The database size is 2TB.

For moving my production server from winNT to win2k3,

1. R dbexport and dbimport utilities are available.

2. If so, will they work for moving the system from winNT to win2003 and database 8.1.7 to 9.2

3. If so can i take a backup of dbexport on to a tape. Previously i have taken dbexport on HDD.

Please, give me a plan from moving my oracle 8.1.7 on win NT to oracle 9.2 on win2003.

thanx in advance.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Oct 30, 2007 at 10:00 AM

    - use SAPInst/R3load procedures to ex- and import the relevant database

    - upgrade your db to 8.1.7 on WinNT and afterwards start the copy/migration

    you can use r3load in order to export the system under oracle 8.1.7 und use this export as import under oracle 9.2; you will not have to make an upgrade for your oracle database on your taregt machine

    <i>you could make a backup of your 8.1.7. database and use this to build your target database under 8.1.7.; upgrade oracle afterwards to 9.2 on your target machine; <b>BUT: oracle 8.1.7 is not supported to run under windows 2003 server...</b> so, this will not be an option!


    -> which kernel do you use? 40B_COM? 40B_EXT? plz check sapnote 83858 for the right combination of kernel, operating system and database version...

    GreetZ, AH

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2007 at 11:42 AM

    another possibility:

    upgrade to Oracle 8.1.7

    upgrade to Windows 2000

    upgrade to Oracle

    on new hardware:

    install windows 2003

    install Oracle 10g

    copy database (through network or with backup/restore)

    use DBUA tool from Oracle.

    check upgrade documentation to run a few Oracle scripts to complete upgrade.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.