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 script provides 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 * from UTL_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 from sys.dba_registry;

COMP_NAME                      VERSION              STATUS
------------------------------ -------------------- --------------------
Oracle Workspace Manager       10.2.0.4.3           VALID

Oracle Enterprise Manager      10.2.0.4.0           VALID
Oracle Database Catalog Views  10.2.0.4.0           VALID
Oracle Database Packages and T 10.2.0.4.0           VALID