Ask the Expert

Upgrading from Oracle 8.1.7.3 to 9.2.0.6 on Sun

How to upgrade an Oracle database from 8.1.7.3 to 9.2.0.6 on Sun 5.8? Actually we have to add disk and some of the mount points into the server. Could you please let us know the complete steps to do so? Thanks in advance.

    Requires Free Membership to View

The Oracle9i Release 2 (9.2) Database Migration guide provides information on a number of methods available for upgrading your database. The method you choose will depend on how large your database is, how long of an outage window you have to perform the migration, etc. Keep in mind that a solid back-out plan is very important in case the migration does not go well in the production environment.

I would recommend testing this migration several times in a non-production environment; be sure to involve the application support team members, as well as business users. Each time the migration is completed in the test environment, everyone involved should test application functionality, batch jobs, and other critical functions thoroughly.

This was first published in February 2007

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: