ORACLE 10.2.01 Upgrade 10.2.05 for Windows detailed documentation

Recently to do a database upgrade work, in advance on their own PC to practice a bit, this document on the Internet a lot, but most of the use of command editing scripts, in fact, the database also has a DBUA upgrade tool can be used, so that the upgrade work more convenient.

OS environment: Windows XP 32-bit PC

Database version: 10.20.01

Upgrade Version: 10.20.05

Operation steps: 1. Back up the database software and database, because once the migration fails, you can recover quickly.

2. Download the upgrade package using Metalink

3. Close all background services in the database and stop within the management tool.

4. Upgrading the Database software

5. Upgrading the Database

Metalink Download the patch Pack, Patch number: 8202632

/Close all service processes, Windows within management tools/services

Upgrading database Software

Select the Oracle_home path that you want to upgrade, and then click Next to install it all the way, and the usual steps for installing Oracle software are the same.

After the software upgrade, start the background service, using the local connection to the database, through the output prompt can be seen that the software has been installed successfully for 10.2.0.5

C:/Documents and Settings/songyang>sqlplus/as Sysdba

Sql*plus:release 10.2.0.5.0-production on Wednesday May 15:55:04

Copyright (c) 1982, Oracle. All rights Reserved.

Connected to the idle routine.

Starting the database will be an error, because the database is still 10.2.0.1 version, so you need to upgrade the database, the main upgrade is the data dictionary and trial map .

Sql> Startup
The ORACLE routine has been started.

Total System Global area 603979776 bytes
Fixed Size 1304728 bytes
Variable Size 180356968 bytes
Database buffers 415236096 bytes
Redo buffers 7081984 bytes
The database is loaded.
The Ora-01092:oracle instance terminates. Force Disconnect

We have the upgrade mode startup upgrade can open the database, open, use the Dbua tool to upgrade the database.

Sql> Startup upgrade
The ORACLE routine has been started.

Total System Global area 603979776 bytes
Fixed Size 1304728 bytes
Variable Size 180356968 bytes
Database buffers 415236096 bytes
Redo buffers 7081984 bytes
The database is loaded.
The database is already open.

Run Dbua under DOS command, bring up the upgrade page, the following is the window to upgrade the page.

C:/Documents and Settings/songyang>dbua

Select the database SID to upgrade

If you want to migrate the data files, the default is not migration

Select the number of CPUs to use at compile time to speed up compilation times

Be sure to make a backup of the database migration as it is possible to fail

Click Finish to start the upgrade, the upgrade time depends on your data size to calculate, is a very long process

View View v$version After upgrade, view database version

Sql> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-prod
PL/SQL Release 10.2.0.5.0-production
CORE 10.2.0.5.0 Production
TNS for 32-bit windows:version 10.2.0.5.0-production
Nlsrtl Version 10.2.0.5.0-production

After the upgrade query Sys.dba_registry attempted, when the status of valid indicates that the upgrade was successful

Sql> select Comp_id,comp_name,version,status from Sys.dba_registry;

comp_id comp_name VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ --------------------
Catalog Oracle Database catalog views 10.2.0.5.0 VALID
Catproc Oracle Database Packages and Types 10.2.0.5.0 VALID
OWM Oracle Workspace Manager 10.2.0.5.0 VALID
JAVAVM jserver Java Virtual machine 10.2.0.5.0 VALID
XML Oracle XDK 10.2.0.5.0 VALID
Catjava Oracle Database Java Packages 10.2.0.5.0 VALID
EXF Oracle Expression Filter 10.2.0.5.0 VALID
ODM Oracle Data Mining 10.2.0.5.0 VALID
CONTEXT Oracle Text 10.2.0.5.0 VALID
XDB Oracle XML Database 10.2.0.5.0 VALID
RUL Oracle Rule Manager 10.2.0.5.0 VALID
Ordim Oracle intermedia 10.2.0.5.0 VALID
APS OLAP Analytic Workspace 10.2.0.5.0 VALID
Xoq Oracle OLAP API 10.2.0.5.0 VALID
AMD OLAP Catalog 10.2.0.5.0 VALID
SDO Spatial 10.2.0.5.0 VALID
EM Oracle Enterprise Manager 10.2.0.5.0 VALID

ORACLE 10.2.01 Upgrade 10.2.05 for Windows detailed documentation