Ask the Expert

Can I FTP files in a Unix-to-Linux Oracle migration?

I will be migrating Oracle 9.2.0.4 from Unix to Red Hat Advanced Server 3.0.1. Should I do a reinstall of the Oracle software on the server and then do an import of the database or can I do a file copy of the Oracle software and datafiles and just FTP them to the box?

    Requires Free Membership to View

As much as I'm sure you'd like to, you can't just FTP Oracle software from Unix to Linux and expect it to work. The hardware is different, which means that many binaries are recompiled to the native platform.

Even if this were not the case, there are also licensing issues that would compel you to do a reinstall. You'll have to go through the usual steps to set up your Oracle environment (including running root.pre), which involves reinstalling Oracle and setting up your entire environment, including Oracle_Home, tnsnames.ora, oratab, etc.

Please don't forget about any shell scripts that you may have written in Unix that at the very least will have to be copied over and tested. In all likelihood, some of these scripts will need to be modified for them to work on your new host. Oracle provides a ton of information on Linux, you might want to start your research here.

The good news is that your data should be able to be imported succesfully, provided you are familiar with the DBA related steps involved in porting the actual data. Good luck.

This was first published in March 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: