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

copy oracle 8i database between different platform

awk_1
Occasional Visitor

copy oracle 8i database between different platform

hi all,

i know it can copy oracle 8i database to different instance but how to copy 8i database from one platform to another platform (say, from hp-ux 11 to linux)?

thx in advance,
alex
9 REPLIES
Stefan Farrelly
Honored Contributor

Re: copy oracle 8i database between different platform


We copy 8i databses fro HP server to HP server all the time without problems, but as Linux is not binary compatible with HP-UX you're going to have to install 8i for Linux first. When thats done and its up and running then copy over your database (database files, indexes, redo logs) and then get the database up and running, or export your db on your HP and copy over then import it on your Linux server.
Im from Palmerston North, New Zealand, but somehow ended up in London...
Sebastian Galeski_1
Trusted Contributor

Re: copy oracle 8i database between different platform

Hi
i rather suggest You to export and import database. Different OS has different disk layouts for example.

regards seba
awk_1
Occasional Visitor

Re: copy oracle 8i database between different platform

thx your input. but is the exported files binary compatible with linux?
Sebastian Galeski_1
Trusted Contributor

Re: copy oracle 8i database between different platform

yes it is
awk_1
Occasional Visitor

Re: copy oracle 8i database between different platform

thx all.
Stefan Farrelly
Honored Contributor

Re: copy oracle 8i database between different platform

Dont forget to assign points to those who took the time to help you.
Im from Palmerston North, New Zealand, but somehow ended up in London...
Ryan Kogelheide
Frequent Advisor

Re: copy oracle 8i database between different platform

 
Ryan Kogelheide
Frequent Advisor

Re: copy oracle 8i database between different platform

... and then do your export and import :)

Marcos_9
Occasional Advisor

Re: copy oracle 8i database between different platform

The only way certified by Oracle is doing and export / import.

Export the database to a file with "exp sys/change_on_install@INSTANCE FULL=Y FILE=export.dmp LOG=export.log" of course you'll have to change passwords instance name and you can use absolut paths instead of relatives

Create a database with Oracle database assistant

Make an import to the new database
"imp sys/change_on_install@INSTANCE FULL=Y FILE=export.dmp LOG=import.log"

and then check the import.

Check for ORA- messages inside this log

One good thing would be to create non standard tablespaces and non standard users because this will probably generate some errors.

If the plattforms were the same (Both Salaris, HP-UX, Linux) you could create a script to generate the database with "alter database backup controlfile to trace" and then do a binary ftp to the other host of all the datafiles. After this you can edit an run the .trc file generated.