oracle 10g 10.2.0,oracle 10g 10.2.0.1升级到10.2.0.4

一、首先升级crs软件：

1，停止数据库、asm、nodeapps

$ srvctl stop database -d hnzz

$ srvctl stop asm -n node1

$ srvctl stop asm -n node2

$ srvctl stop nodeapps -n node1

$ srvctl stop nodeapps -n node2

crs_stat -t 差可能所有资源都是offline状态

2，解压升级包

$su - oracle

$ unzip p6810189_10204_Linux-x86.zip

3,开始执行升级操作

$ cd /tmp/1024/Disk1/

$./runInstaller

开始界面首先选择CRS,中间看看检查结果，确保没错继续

安装过程中执行两个安装脚本

/oracle/app/product/crs/bin/crsctl stop crs

# /oracle/app/product/crs/install/root102.sh

两个都执行完毕后在节点2重复执行操作

二，升级数据库软件

1，停止所有服务

$ srvctl stop database -d hnzz

$ srvctl stop asm -n node1

$ srvctl stop asm -n node2

$ srvctl stop nodeapps -n node1

$ srvctl stop nodeapps -n node2

确认所有节点都offline

2，开始升级数据库软件

$ cd /tmp/1024/Disk1/

$./runInstaller

选择oracle目录

OraDb10g_home1

确保检查全部通过

安装过沉重要执行一个脚本

/oracle/app/product/10.2.0/db_1/root.sh

执行脚本签先备份bin文件(两个节点都执行)

# cd /usr/local/

# cp -rf bin bin.old

执行完成后退出，数据库软件升级完成

三，升级数据库

确保crs在至少一个节点上启动，如果没有启动可以按照下面的方式进行启动

$crs_start -all

$crs_stat -t

开始下面的操作

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 10 11:22:27 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> shutdown immediate;

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1267068 bytes

Variable Size             121637508 bytes

Database Buffers          159383552 bytes

Redo Buffers                2924544 bytes

SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL>

运行升级脚本

SQL>startup upgrade

SQL>spool patch.log

SQL>@?/rdbms/admin/catupgrd.sql  此处执行时间较长

SQL>shutdown immediate;

SQL>spool off

编译无效对象

SQL>startup

SQL>@?/rdbms/admin/utlrp.sql

SQL> alter system set cluster_database=true scope=spfile;

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1267068 bytes

Variable Size             159386244 bytes

Database Buffers          121634816 bytes

Redo Buffers                2924544 bytes

Database mounted.

Database opened.

select comp_name,version,status from sys.dba_registry;查看升级后的结果