Ask the Expert

Migrating Oracle 8i DB from AIX to Windows

I want to migrate Oracle 8i Database from IBM AIX to a Windows platform. I have got the data dump with me. Please guide me.

    Requires Free Membership to View

After installing the Oracle8i software on your Windows server, create a new database. This can be accomplished either through the DBCA (Database Configuration Assistant) or manually with scripts. For a step-by-step process on how to do this, review the Oracle8i Administrator's Guide Release 2

After creating this new database, create all the required application-related tablespaces that the source database currently contains. FTP the export file from your AIX server to the Windows server and uncompress it if it is in a compressed format. You can now perform an import on the Windows server, either via the command line or by first creating an import parameter file. I prefer to create a parameter file called imp.par. The contents would look similar to this:

USERID=SYSTEM
FULL=y
FILE=DBA.DMP
GRANTS=Y
INDEXES=Y

Then invoke the import utility and call the parameter file as such:

imp parfile=imp.par

and provide a password when prompted. For more information about using import, review the Oracle8i Release 2 Utilities guide.

Review the import log to ensure that there were no errors, then run SQL on both the source and target databases to ensure that all objects were imported. Finally, note that a listener will need to be configured on the Windows server and your existing tnsnames.ora files will need to be modified to reflect where this new database resides.

This was first published in December 2006

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: