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

mfalomir · #1 (**permalink**) 04-24-03, 20:52

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?

osy45 · #2 (**permalink**) 04-25-03, 02:29

export the win2K databases
install the oracle sw on redhat

build the instances

imp the exported datasets

Orca777 · #3 (**permalink**) 04-25-03, 03:21

Quote:

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

aarroyob · #4 (**permalink**) 04-25-03, 11:01

Not mandatory Orca, you could export using 8.1.7 database using exp utility 8.0.6 and import there without problem

cheers

Orca777 · #5 (**permalink**) 04-25-03, 11:06

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

aarroyob · #6 (**permalink**) 04-25-03, 11:09

Did you downgraded 50 databases? Really? Why?

Orca777 · #7 (**permalink**) 04-25-03, 11:52

No,
this would not be my dream-job ;-),
but all this happens thru consulting day by day.
Orca

Orca777 · #8 (**permalink**) 04-25-03, 12:05

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