Oracle 8i Upgrade Oracle 10g

Oracle 8.1.7 . 4. Upgrade Oracle 10.2

Oracle provides an update tool that allows you to upgrade the database from a lower version to a later version, and the 8i can be upgraded directly 10g But 8i must be 8.1.7 . 4 (inclusive) or later versions, 8.1.7.0 is not supported. Oracle provides two upgrade Methods: Wizard upgrade and manual upgrade. The following describes the upgrade process respectively.

1. Wizard upgrade

1. First, you should back up the 8i Database (however, you can also choose not to back up)

2. Install Oracle 10 Gb in a different home from 8i. Select not to create a database.

3. log on to the 8i database as sysdba,

SQL> spool info. Log

SQL> @ ORACLE_HOME/rdbms/admin/utlu102i.sql

SQL> spool off

4. view info. log, follow the log prompts to modify RBS to conform to the requirements. Other warnings can not be modified. During the upgrade process, the system will prompt you to confirm that the Upgrade Program will modify the RBS.

5. Find the Database Upgrade tool from the Oracle menu and click Run.

6. follow the wizard prompts to upgrade (because you have already backed up, select "backed up" during the upgrade, and no longer need to upgrade the program to back up your backup). In the confirmation window, select "OK" and continue, yes. Wait for the "OK" button to complete the upgrade.

If your initialization parameters are correct, the upgrade operation is generally terminated smoothly. If an error occurs during the process, restore the database and manually upgrade it. I encountered a Ora-00064 error while upgrading a database and ended up upgrading.

2. manual upgrade

1. First, you should back up the 8i Database (however, you can also choose not to back up)

2. Install Oracle 10g Select not to create a database in a home that is different from 8i.

3. log on to the 8i database as sysdba,

SQL> spool info. Log

SQL> @ ORACLE_HOME/rdbms/admin/utlu102i.sql

SQL> spool off

4. Copy the 8i initialization parameter file 10g Home Location

5. Copy the password file 10g Home Location

6. according to info. log prompt, modify the initialization parameter file for 10 Gb, info. which of the following parameters are recommended for log modification? Those parameters are no longer needed. delete them. These parameters are new and need to be added. Modify them as recommended.

7. Modify the redo log, datafile, and RBS Size Based on info. log.

8. Shutdown 8i Database

9. Stop the services of the original database

10. Use oradim to delete Sid

11. Use the parameter file you modified to create a new database instance (oradim)

12. Enter sqlplus as sysdba and start the database to upgrade.

SQL> startup upgrade

I encountered a Ora-00064 error at startup, modify the initialization parameter file, modified several parameters and then run again successfully, so I do not know that the parameter has played an effect, you can try.

13. Create tablespace sysaux

Create tablespace sysaux datafile 'sysaux01. dbf'

Size 500 m Reuse

Extent management local

Segment space management auto

Online;

14. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ catupgrd. SQL

15. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ utlu102s. SQL

16. SQL> shutdown immediate

17. SQL> startup

18. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ olstrig. SQL

19. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ utlrp. SQL

20. Stop the 8 I listener service

21. Create 10g listener service

Upgrade complete