Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2003
    Location
    Tijuana, BC, Mexico
    Posts
    2

    Unanswered: Migrating an Oracle Instance from Windows 2000 to Linux (RH AS)

    Hello, I need help... i hope anybody can help me.... I need to migrate or move my Oracle database , which is now on a Windows 2000 server, to a Linux Server (Red Hat AS).. is it possible?? any suggestions?

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    export the win2K databases
    install the oracle sw on redhat

    build the instances

    imp the exported datasets

  3. #3
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25

    Re: Migrating an Oracle Instance from Windows 2000 to Linux (RH AS)

    Originally posted by mfalomir
    Hello, I need help... i hope anybody can help me.... I need to migrate or move my Oracle database , which is now on a Windows 2000 server, to a Linux Server (Red Hat AS).. is it possible?? any suggestions?
    Hi the Db-version of your win2k should be the same or lower
    as the version on Linux

    you cannot import for example 8.1.6 into 8.0.6

    Orca

  4. #4
    Join Date
    Apr 2003
    Posts
    6
    Not mandatory Orca, you could export using 8.1.7 database using exp utility 8.0.6 and import there without problem

    cheers

  5. #5
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25
    Hi,
    this is luck, isn't it?
    We had problems imp/exp (views were missing ) even between 8.1.7.0.0 and 8.1.7.4.50 Databases

    Orca

  6. #6
    Join Date
    Apr 2003
    Posts
    6
    Did you downgraded 50 databases? Really? Why?

  7. #7
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25
    No,
    this would not be my dream-job ;-),
    but all this happens thru consulting day by day.
    Orca

  8. #8
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25
    Looked at metalink :

    1. From 7.3.3 to 8.1.6 => Use the EXPORT 7.3.3 to export the data from the 7.3.3 database and IMPORT 8.1.6 to import the data into the 8.1.6 database.

    2. From 8.1.6 to 8.1.6 => Use the EXPORT 8.1.6 to export the data from the 8.1.6 database and IMPORT 8.1.6 to import the data into the 8.1.6 database.
    3. From 8.1.5 to 8.0.6 => Use the EXPORT 8.0.6 to export the data from the 8.1.5 database and IMPORT 8.0.6 to import the data into the 8.0.6 database.
    4. From 9.0.1 to 8.1.7 => Use the EXPORT 8.1.7 to export the data from the 9.0.1 database and IMPORT 8.1.7 to import the data into the 8.1.7 database.
    5. From 8.1.7 to 9.2.0 => Use the EXPORT 8.1.7 to export the data from the 8.1.7 database and IMPORT 9.2.0 to import the data into the 9.2.0 database.
    6. From 9.0.1 to 9.2.0 => Use the EXPORT 9.0.1 to export the data from the 9.0.1 database and IMPORT 9.2.0 to import the data into the 9.2.0 database.
    7. From 8.1.7 to 7.3.4 => Only if never run before, first run CATEXP7.SQL on the 8.1.7 database in order to create the Oracle7 data dictionary views; then use the EXPORT 7.3.4 to export the data from the 8.1.7 database
    and IMPORT 7.3.4 to import the data into the 7.3.4 database.



    You are totally right downgrading is possible (From 8.1.5 to 8.0.6 => Use the EXPORT 8.0.6)
    Sorry
    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •