分类： Oracle
2010-10-07 09:10:19
如何升级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
