一、首先升级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;查看升级后的结果 (责任编辑:IT) |