Migrate Oracle to another OS

[Fred Morin_1]

We have actually a Oracle 8.1.7.4 instance run on HPUX11i, we want to migrate this database to a HP Proliant with REDHAT AS 2.1.

Any ideas?

[Steven E. Protter]

It should be possible to do one of two things:

Clone the datafiles. Take a cold backup ftp them to the redhat box and then follow oracle conversion procedures. This may or may not be supported.

A supported route is export/import.

You don't mention the database version on Red Hat. I recommend the same database version. Don't add a major migration to a tough project.

If you use designer, you will have to reinstall that and follow a special data migraion process.

The procedures are available at metalink.oracle.com

SEP

[Fred Morin_1]

On REDHAT AS 2.1, is the same level of Oracle, 8.1.7.4.

[Hari Kumar]

The One Solution is making a Database level Export and Importing there by desinging a procedure first for all the steps included.

As the Filesystems(of present one), Block size and all other stuff were involved it might not be supported and ofcourse a well in-use procedure is export/import.

Thanks SEP for good explanation,

Thanks

[Fred Morin_1]

Can I make a export/import from a 64bits database to 32bits database?

[Tomek Gryszkiewicz]

Yes, you can export from 64bit to 32bit.

-Tomek

[Hari Kumar]

As per my knowledge ( ofcourse read at a News article of Oracle) we can do so.
What about your application ?

Thanks

[Fred Morin_1]

Our application is SAP.
But is not a problem.

[Steven E. Protter]

To go 64 bit to 32 bit, you will have to do a word size conversion. Expect a performance hit. I've done the 32 to 64 process. Its a 20 step complex process.

I expect going the other direction will be pretty complex as well.

Good Luck,

SEP

[Fred Morin_1]

SAP dosen't support this operation,

We have to proceed with R3load.

Is anybody know how?