The best way to Upgrade Oracle 9i to Oracle 10 Gb Database

1. Create the same directory as the 9i data file, control file, and redo file on the target server where Oracle 10g software is installed (the data files of the two databases must be in the same location, otherwise, you need to use alter database rename file 'original location 'to 'destination location ')

2. Shut down the 9i source database, copy 9i data files, control files, redo files, password files, initialization parameter files, spfile files, and so on, to the corresponding location of the target database for 10 Gb.

3. Modify the parameters in listener. ora tnsnames. ora according to the actual situation.

4. Use the sys user to log on and start the database in UPGRADE mode. Otherwise, an error is reported.

5. Create a sysaux tablespace, segment, and zone for local management. Because no SYSAUX tablespace exists in 9i, you need to create a MB tablespace after starting the database in UPGRADE mode, otherwise, an error is reported when the upgrade script is executed. The system prompts you to create the sysaux tablespace, and provides the statement for creating the tablespace. You can simply execute it as needed.

6. Execute the catupgrd. SQL upgrade script for about 40 minutes without manual intervention until the execution is complete.

7. After the execution is complete, shut down the database and start the database in normal mode.

8. Run the utlrp. SQL script to re-compile some invalid objects.

9. Complete upgrade

This method is relatively safe. You only need to shut down the source database for a period of time until the copy is complete, and then start and continue running. This method is suitable for large data volumes.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12