oracle10.2.0.1.0升级到10.2.0.4.0

如何升级oracle10.2.0到oracle 10.2.0.4

关闭数据库及listener和oem，都在oracle用户下
SQL> shutdown immediate
lsnrctl stop

emctl status dbconsole  查看状态

emctl stop dbconsole   关闭oem

安装补丁
补丁包：unzip p6810189_10204_Linux-x86.zip
./runInstall

其中要执行一个脚本（root.sh）在root下执行，默认都要覆盖，选y，其他的都默认

[oracle@racdb1 Disk1]$ echo $ORACLE_SID
orc1
[oracle@racdb1 Disk1]$ sqlplus "/ as sysdba"
SQL> startup upgrade
SQL> spool upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
SQL> spool off

Rem   DESCRIPTION
Rem     This script provides information about databases to be
Rem     upgraded to 10.2.
Rem
Rem     Supported releases: 8.1.7, 9.0.1, 9.2.0, and 10.1.0

SQL> spool patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> spool off

Rem   NAME
Rem     catupgrd.sql - CATalog UPGraDe to the new release
Rem
Rem   DESCRIPTION
Rem    This script is to be used for upgrading an 8.1.7, 9.0.1, 9.2
Rem    or 10.1 database to the new release.  This scriptprovides a direct
Rem    upgrade path from these releases to the new Oracle release.

SQL> shutdown immediate
SQL> startup
SQL> @?/rdbms/admin/utlrp.sql

Rem   NAME
Rem     utlrp.sql - Recompile invalid objects
Rem
Rem   DESCRIPTION
Rem    This script recompiles invalid objects in the database.

SQL> select * fromUTL_RECOMP_ERRORS; 

SQL> col comp_name format a30
SQL> col version format a20
SQL> col status format a20
SQL> set line 200
SQL> select comp_name, version, status fromsys.dba_registry;

COMP_NAME                     VERSION             STATUS
------------------------------ ----------------------------------------
Oracle WorkspaceManager      10.2.0.4.3          VALID

Oracle EnterpriseManager     10.2.0.4.0          VALID
Oracle Database Catalog Views 10.2.0.4.0          VALID
Oracle Database Packages and T10.2.0.4.0          VALID