Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate Oracle to another OS

Fred Morin_1
Advisor

Migrate Oracle to another OS

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?
9 REPLIES
Steven E. Protter
Exalted Contributor

Re: Migrate Oracle to another OS

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Fred Morin_1
Advisor

Re: Migrate Oracle to another OS

On REDHAT AS 2.1, is the same level of Oracle, 8.1.7.4.
Hari Kumar
Trusted Contributor

Re: Migrate Oracle to another OS

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
Information is Wealth ; Knowledge is Power
Fred Morin_1
Advisor

Re: Migrate Oracle to another OS

Can I make a export/import from a 64bits database to 32bits database?
Tomek Gryszkiewicz
Trusted Contributor

Re: Migrate Oracle to another OS

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

-Tomek
Hari Kumar
Trusted Contributor

Re: Migrate Oracle to another OS

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

Thanks
Information is Wealth ; Knowledge is Power
Fred Morin_1
Advisor

Re: Migrate Oracle to another OS

Our application is SAP.
But is not a problem.
Steven E. Protter
Exalted Contributor

Re: Migrate Oracle to another OS

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Fred Morin_1
Advisor

Re: Migrate Oracle to another OS

SAP dosen't support this operation,

We have to proceed with R3load.

Is anybody know how?