当前位置: > 数据库 > Oracle >

oracle 10g 10.2.0.1升级到10.2.0.4

时间:2016-06-12 21:40来源:linux.it.net.cn 作者:IT
一、首先升级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)
------分隔线----------------------------