1,先引录如下升级流程图片


2,上述各步骤细述
Step 1: Prepare to Upgrade

• Become familiar with the features of the new Oracle Database 10g release.

• Determine the upgrade path to the new Oracle Database 10g release.

• Choose an upgrade method.

• Choose an Oracle home directory for the new Oracle Database 10g release.

• Develop a testing plan.

• Prepare a backup strategy.

Step 2: Test the Upgrade Process

• Perform. a test upgrade using a test database. The test upgrade should be conducted in an environment created for testing and should not interfere with the actual production database.

Step 3: Test the Upgraded Test Database

• Perform. the tests you planned in Step 1 on the test database and on the test database that was upgraded to the new Oracle Database 10g release.

• Compare results, noting anomalies between test results on the test database and on the upgraded database.

• Investigate ways to correct any anomalies you find and then implement the corrections.

• Repeat Step 1, Step 2, and the first parts of Step 3, as necessary, until the test upgrade is completely successful and works with any required applications.

Chapter 2, "Preparing to Upgrade" provides detailed information about Steps 1 through 3.

Step 4: Prepare and Preserve the Production Database

• Prepare the current production database as appropriate to ensure the upgrade to the new Oracle Database 10g release will be successful.

• Schedule the downtime required for backing up and upgrading the production database.

• Back up the current production database. Perform. a full or an incremental backup, as necessary, to ensure your database is protected against data loss.

Step 5: Upgrade the Production Database

• Upgrade the production database to the new Oracle Database 10g release.

• After the upgrade, perform. a full backup of the production database and perform. other post-upgrade tasks.

Step 6: Tune and Adjust the New Production Database

• Tune the new Oracle Database production database. The new Oracle Database production database should perform. as good as, or better than, the database prior to the upgrade. Chapter 4 describes these adjustments.

• Determine which features of the new Oracle Database 10g release you want to use and update your applications accordingly.

• Develop new database administration procedures, as needed.

• Do not upgrade production users to the new Oracle Database until all applications have been tested and operate properly. Chapter 6 describes considerations for updating applications.

Oracle Release Numbers

Converting Databases to 64-bit Oracle Database Software

If you are installing 64-bit Oracle Database 10g software but were previously using a 32-bit Oracle Database installation, then the databases will automatically be converted to 64-bit during the upgrade to Oracle Database 10g except when upgrading from Release 1 (10.1) to Release 2 (10.2).

Note:

The process is not automatic for the release 1 to release 2 upgrade, but is automatic for all other upgrades. This is because the utlip.sql script. is not run during the release 1 to release 2 upgrade to invalid all PL/SQL objects. You must run the utlip.sql script. as the last step in the release 10.1 environment, before upgrading to release 10.2.

Rolling Upgrades

Oracle Data Guard and logical standby databases


Oracle Streams


Real Application Clusters Rolling Upgrades with the opatch Utility

Moving From the Standard Edition to the Enterprise Edition

If you are using the Standard Edition of the Oracle Database and want to move to the Enterprise Edition, then complete the following steps:

1. Ensure that the release number of your Standard Edition server software is the same release as the Enterprise Edition server software.

   For example, if your Standard Edition server software is release 10.2.0, then you should upgrade to release 10.2.0 of the Enterprise Edition.

2. Shut down your database.

3. If your operating system is Windows, then stop all Oracle services, including the OracleServiceSID Oracle service, where SID is the instance name.

4. Deinstall the Standard Edition server software.

5. Install the Enterprise Edition server software using the Oracle Universal Installer.

   Select the same Oracle home that was used for the de-installed Standard Edition. During the installation, be sure to select the Enterprise Edition. When prompted, choose Software Only from the Database Configuration screen.

6. Start up your database.

Your database is now upgraded to the Enterprise Edition.

Table 2-1 Upgrade Paths

Current Release	Upgrade Path
7.3.3 and lower 7.3.4 8.0.3 8.0.4 8.0.5 8.0.6 8.1.5 8.1.6	Direct upgrade is not supported. Upgrade to an intermediate Oracle Database release before you can upgrade to the new Oracle Database 10g release, as follows: 7.3.3 (or lower) -> 7.3.4 -> 8.1.7.4 -> 10.2 7.3.4 -> 8.1.7.4 -> 10.2 8.0.n -> 8.1.7.4 -> 10.2 8.1.n -> 8.1.7.4 -> 10.2 When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release's documentation. Then, upgrade the intermediate release database to the new Oracle Database 10g release using the instructions in Chapter 3, "Upgrading to the New Oracle Database 10g Release".
8.1.7.4 9.0.1.4 9.2.0.4 10.1.0.2	Direct upgrade from 8.1.7.4, 9.0.1.4 or higher, 9.2.0.4 or higher, and 10.1.0.2 or higher to the newest Oracle Database 10g release is supported. However, you must first apply the specified minimum patch release indicated in the Current Release column. To upgrade to the new Oracle Database 10g release, follow the instructions in Chapter 3, "Upgrading to the New Oracle Database 10g Release".

upgrd001.gif

upgrd004.gif