Oracle- RAC 10.2.0.1 升级到 10.2.0.5
5墨值下载
本实验是从 RAC 10.2.0.1 升级到 10.2.0.5，共两个节点
一、准备
1、Patch 包：
本实验使用的 Pathc 包是 p8202632_10205_Linux-x86-64.zip
注：
10.2.0.5
的集群软件
clusterware
和数据库软件
database
在同一个压缩文件中。
2、当前节点状态
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.racdb.db application ONLINE ONLINE rac1
ora....acdb.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac1
ora....db2.srv application ONLINE ONLINE rac2
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
3、查看当前数据库版本
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 – Production
4、查看当前 CRS 版本
[oracle@rac1 ~]$ crsctl query crs softwareversion rac1
CRS software version on node [rac1] is [10.2.0.1.0]
[oracle@rac1 ~]$ crsctl query crs softwareversion rac2
CRS software version on node [rac2] is [10.2.0.1.0]
5、上传 Patch 包到服务器
解压并把所属用户和组调整为 oracle:oinstall
注：本实验使用
winSCP
上传也可以使用其他工具。
二、开始升级
1、停止所有资源
[oracle@rac1 oraInventory]$ srvctl stop nodeapps -n rac2
[oracle@rac1 oraInventory]$ srvctl stop nodeapps -n rac1
[oracle@rac1 oraInventory]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
ora.racdb.db application OFFLINE OFFLINE
ora....acdb.cs application OFFLINE OFFLINE
ora....db1.srv application OFFLINE OFFLINE
ora....db2.srv application OFFLINE OFFLINE
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application OFFLINE OFFLINE
of 26
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论