Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Patches for upgrading from Oracle 9i release 1 to release 2

I have Oracle 9i release 1 and now I want to upgrade to release 2. Where can I download the required patches for upgrading?

I have Oracle 9i release 1 and now I want to upgrade to release 2. Please tell me if I can upgrade without any complications. At the moment I don't have a Metalink account. Where can I download the required patches for upgrading?
If you are, in fact, planning to upgrade from Oracle9i release 1 (i.e., 9.0.1.x) to Oracle9i release 2 (9.2.0.x) you do not need to download patches from Metalink. This is not a minor patch set upgrade (e.g., 9.2.0.6 to 9.2.0.7); you are essentially migrating your database from one release to another. You can download Oracle9i release 2 from Oracle's Technology Network Web site.

Choose the appropriate software for your operating system, and install it in a separate ORACLE_HOME from where the current Oracle9i release 1 software resides. Review the Oracle9i Release 2 (9.2) Database Migration guide to determine which method to use to upgrade your database. Basically, you have three options:

  • Upgrade your database in place to Oracle9i release 2.
  • Use export/import utilities to upgrade your database.
  • Copy your data via a database link between the two databases.
The first two options are the most commonly used, but you should review the procedures for each of these options and determine which best suits your needs.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close