How to upgrade Oracle9i to 10g

Upgrade from Oracle9i to 10 GB: 1. Use an oracle Upgrade utility dbua (databaseupgradeassistant) to directly connect the 9i Database.

Upgrade from Oracle 9i to 10 GB: 1. Use a database upgrade assistant provided by oracle to directly upgrade the 9i database

You can choose from two solutions:

1. Use the database upgrade assistant (dbua) upgrade utility provided by oracle to directly upgrade 9i database to 10 Gb.

2. Create a 10 Gb database and use the import/export (imp/exp) utility of oracle to migrate data.

1. First, let's talk about the first solution (using the Upgrade Program: dbua ):

Suitable: This solution is suitable for large data volumes. It may take a long time to migrate a database using an import/export tool.

Method: If this scheme is used, we need to install 10 Gb software on the original database machine, without installing 10 Gb database. after installing the 10g software, run the 10g Database Upgrade assistant utility dbua, and then use the Upgrade Wizard to complete the upgrade process from 9ig to 10g. during the upgrade, dbua automatically changes the configuration of some databases to a 10 Gb environment, such as database parameter settings, memory configuration, SQL, pl/SQL engine, and database management, the version of the software related to the operation will be automatically upgraded to 10 Gb.

Advantages:

(1) It is the fastest way to upgrade databases with large data volumes.

(2) Retain the physical structure (such as data files and redo log files) and logical structure (tablespace, user, and system permission settings) of the original database, without the need to re-plan the database.

Risk: this solution has certain risks. although the 10 Gb Database Upgrade assistant utility dbua is relatively stable in general, if the upgrade fails, the original database may fail to be used, some functions may be lost, or the database may not run properly. therefore, before the formal upgrade, you must first test all the upgrade processes on the test database, and confirm the correctness before performing the upgrade on the production database.

IT costs: This solution does not require additional hardware investment.

Dbua supports the following database versions:

1. oracle 8 8.0.6

2. oracle 8i 8.1.7

3. oracle 9i 9.0.1

4. oracle 9i 9.2.0

,