如何升级oracle10.2.0到oracle 10.2.0.4

关闭数据库及listener
SQL> shutdown immediate
lsnrctl stop

关闭ASM
[oracle@racdb1 ~]$ sqlplus "/ as sysdba"
SQL> shutdown immediate

[root@racdb1 ~]# $ORACLE_HOME/bin/crsctl stop crs
安装补丁
unzip p6810189_10204_Linux-x86.zip
runInstall

[root@racdb1 ~]# $ORACLE_HOME/root.sh

[root@racdb1 ~]# $ORACLE_HOME/bin/crsctl check cssd
CSS appears healthy

[oracle@racdb1 ~]$ echo $ORACLE_SID
+ASM
[oracle@racdb1 ~]$ sqlplus "/ as sysdba"
SQL> startup
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1265912 bytes
Variable Size              57454344 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

[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

www.ixdba.net

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