Oracle10.2.0.1RAC 升级 Oracle10.2.0.5案例分享 -CRS篇_craeta oci 10.2-程序员宅基地
Oracle10.2.0.1RAC 升级 Oracle10.2.0.5案例分享 -CRS篇
这是一次数据库升级的案例。原有的数据库是Oracle9i 9.2.0.7 双节点RAC，运行在AIX5.3.0.0操作系统上。由于应用程序的限制，只能升级到Oracle10g 10.2.0.5。 Oracle10g 10.2.0.5没有独立的安装包，需要先安装Oracle10.2.0.1在通过升级包来升级到该版本。在新服务器上安装和升级的好处是不需要升级数据字典，在完成集群软件和数据库软件的升级后直接使用dbca创建数据库就可以了，省去一些步骤。
oracle10.2.0.5升级包解压缩后是一个Disk1文件夹，并没有区分集群软件和数据库软件。在我们手动安装时根据输入CRS_HOME和ORACLE_HOME来区分所升级的项目。
本次采用的介质如下
集群软件 ： 10gr2_aix5l64_cluster.cpio.gz,
数据库软件：10gr2_aix5l64_database.cpio.gz,
升级包： p8202632_10205_AIX64-5L_1of2.zip, p8202632_10205_AIX64-5L_2of2.zip
实施环境
Oracle10g RAC+ASM
AIX:5.3_X86_64
SQL> sqlplus / as sysdba
DB version:10.2.0.1
$ crsctl query crs softwareversion
CRS version:10.2.0.1
节点1：scgl1
Instance:PROD1
$ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
$CRS_HOME:/u01/app/oracle/product/10.2.0/crs_1
节点2：scgl2
Instance:PROD2
$ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
$CRS_HOME:/u01/app/oracle/product/10.2.0/crs_1
集群软件升级（10.2.0.1 - 10.2.0.5）
PATCH: p8202632_10205_AIX64-5L_1of2.zip, p8202632_10205_AIX64-5L_2of2.zip
1. 关闭crs资源
$ crs_stop -all
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.scgl1.gsd application OFFLINE OFFLINE
ora.scgl1.ons application OFFLINE OFFLINE
ora.scgl1.vip application OFFLINE OFFLINE
ora.scgl2.gsd application OFFLINE OFFLINE
ora.scgl2.ons application OFFLINE OFFLINE
ora.scgl2.vip application OFFLINE OFFLINE
2. 解压升级文件
$ pwd
/backup/install/10205
unzip p8202632_10205_AIX64-5L_1of2.zip
unzip p8202632_10205_AIX64-5L_2of2.zip
3. 确保图像化正常启动
cd Disk1
$ export DISKPLAY=10.67.224.26:0.0
4. 启动升级
$ ./runInstaller
5. 开始图像界面升级
6. 先开始CRS的升级，注意Patch路径选择$ORA_CRS_HOME
可以点击Installed Products按钮来查看Name与Path的对应关系
7. 点击Next
8. 完成环境检查，Next
9. 点击Install,开始真正的安装
10. 等待进度条满后，Next
11. 根据要求执行1. 2.两步操作
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
#
# /u01/app/oracle/product/10.2.0/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
< CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs_1
Relinking some shared libraries.
Relinking of patched files is complete.
Copying opriproc to /etc/oracle/bin for AIX
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: scgl1 scgl1_priv scgl1
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
#
# /u01/app/oracle/product/10.2.0/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
< CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs_1
Relinking some shared libraries.
Relinking of patched files is complete.
Copying opriproc to /etc/oracle/bin for AIX
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: scgl2 scgl2_priv scgl2
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs
脚本执行结束后，crs及各项服务已经自动启动了
12. 验证版本信息
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl query crs softwareversion scgl1
CRS software version on node [scgl1] is [10.2.0.5.0]
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl query crs softwareversion scgl2
CRS software version on node [scgl2] is [10.2.0.5.0]
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
# su - oracle
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.scgl1.gsd application ONLINE ONLINE scgl1
ora.scgl1.ons application ONLINE ONLINE scgl1
ora.scgl1.vip application ONLINE ONLINE scgl1
ora.scgl2.gsd application ONLINE ONLINE scgl2
ora.scgl2.ons application ONLINE ONLINE scgl2
ora.scgl2.vip application ONLINE ONLINE scgl2
到此位置集群软件的升级结束，由于篇幅图片编辑等限制数据库升级再下一篇博客中介绍。
这是一次数据库升级的案例。原有的数据库是Oracle9i 9.2.0.7 双节点RAC，运行在AIX5.3.0.0操作系统上。由于应用程序的限制，只能升级到Oracle10g 10.2.0.5。 Oracle10g 10.2.0.5没有独立的安装包，需要先安装Oracle10.2.0.1在通过升级包来升级到该版本。在新服务器上安装和升级的好处是不需要升级数据字典，在完成集群软件和数据库软件的升级后直接使用dbca创建数据库就可以了，省去一些步骤。
oracle10.2.0.5升级包解压缩后是一个Disk1文件夹，并没有区分集群软件和数据库软件。在我们手动安装时根据输入CRS_HOME和ORACLE_HOME来区分所升级的项目。
本次采用的介质如下
集群软件 ： 10gr2_aix5l64_cluster.cpio.gz,
数据库软件：10gr2_aix5l64_database.cpio.gz,
升级包： p8202632_10205_AIX64-5L_1of2.zip, p8202632_10205_AIX64-5L_2of2.zip
实施环境
Oracle10g RAC+ASM
AIX:5.3_X86_64
SQL> sqlplus / as sysdba
DB version:10.2.0.1
$ crsctl query crs softwareversion
CRS version:10.2.0.1
节点1：scgl1
Instance:PROD1
$ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
$CRS_HOME:/u01/app/oracle/product/10.2.0/crs_1
节点2：scgl2
Instance:PROD2
$ORACLE_HOME:/u01/app/oracle/product/10.2.0/db_1
$CRS_HOME:/u01/app/oracle/product/10.2.0/crs_1
集群软件升级（10.2.0.1 - 10.2.0.5）
PATCH: p8202632_10205_AIX64-5L_1of2.zip, p8202632_10205_AIX64-5L_2of2.zip
1. 关闭crs资源
$ crs_stop -all
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.scgl1.gsd application OFFLINE OFFLINE
ora.scgl1.ons application OFFLINE OFFLINE
ora.scgl1.vip application OFFLINE OFFLINE
ora.scgl2.gsd application OFFLINE OFFLINE
ora.scgl2.ons application OFFLINE OFFLINE
ora.scgl2.vip application OFFLINE OFFLINE
2. 解压升级文件
$ pwd
/backup/install/10205
unzip p8202632_10205_AIX64-5L_1of2.zip
unzip p8202632_10205_AIX64-5L_2of2.zip
3. 确保图像化正常启动
cd Disk1
$ export DISKPLAY=10.67.224.26:0.0
4. 启动升级
$ ./runInstaller
5. 开始图像界面升级
6. 先开始CRS的升级，注意Patch路径选择$ORA_CRS_HOME
可以点击Installed Products按钮来查看Name与Path的对应关系
7. 点击Next
8. 完成环境检查，Next
9. 点击Install,开始真正的安装
10. 等待进度条满后，Next
11. 根据要求执行1. 2.两步操作
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
#
# /u01/app/oracle/product/10.2.0/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
< CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs_1
Relinking some shared libraries.
Relinking of patched files is complete.
Copying opriproc to /etc/oracle/bin for AIX
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: scgl1 scgl1_priv scgl1
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
#
# /u01/app/oracle/product/10.2.0/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
< CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs_1
Relinking some shared libraries.
Relinking of patched files is complete.
Copying opriproc to /etc/oracle/bin for AIX
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Adding daemons to inittab
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: scgl2 scgl2_priv scgl2
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs
脚本执行结束后，crs及各项服务已经自动启动了
12. 验证版本信息
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl query crs softwareversion scgl1
CRS software version on node [scgl1] is [10.2.0.5.0]
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl query crs softwareversion scgl2
CRS software version on node [scgl2] is [10.2.0.5.0]
节点scgl1
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
节点scgl2
# /u01/app/oracle/product/10.2.0/crs_1/bin/crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
# su - oracle
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.scgl1.gsd application ONLINE ONLINE scgl1
ora.scgl1.ons application ONLINE ONLINE scgl1
ora.scgl1.vip application ONLINE ONLINE scgl1
ora.scgl2.gsd application ONLINE ONLINE scgl2
ora.scgl2.ons application ONLINE ONLINE scgl2
ora.scgl2.vip application ONLINE ONLINE scgl2
到此位置集群软件的升级结束，由于篇幅图片编辑等限制数据库升级再下一篇博客中介绍。
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
智能推荐
前端开发之vue-grid-layout的使用和实例-程序员宅基地
文章浏览阅读1.1w次，点赞7次，收藏34次。vue-grid-layout的使用、实例、遇到的问题和解决方案_vue-grid-layout
Power Apps-上传附件控件_powerapps点击按钮上传附件-程序员宅基地
文章浏览阅读218次。然后连接一个数据源，就会在下面自动产生一个添加附件的组件。把这个控件复制粘贴到页面里，就可以单独使用来上传了。插入一个“编辑”窗体。_powerapps点击按钮上传附件
C++ 面向对象（Object-Oriented）的特征 & 构造函数& 析构函数_"object(cnofd[\"ofdrender\"])十条"-程序员宅基地
文章浏览阅读264次。(1) Abstraction (抽象)(2) Polymorphism (多态)(3) Inheritance (继承)(4) Encapsulation (封装)_"object(cnofd[\"ofdrender\"])十条"
修改node_modules源码，并保存，使用patch-package打补丁，git提交代码后，所有人可以用到修改后的_修改 node_modules-程序员宅基地
文章浏览阅读133次。删除node_modules，重新npm install看是否成功。在 package.json 文件中的 scripts 中加入。修改你的第三方库的bug等。然后目录会多出一个目录文件。_修改 node_modules
【】kali--password:su的 Authentication failure问题，&sudo passwd root输入密码时Sorry, try again._password: su: authentication failure-程序员宅基地
文章浏览阅读883次。【代码】【】kali--password:su的 Authentication failure问题，&sudo passwd root输入密码时Sorry, try again._password: su: authentication failure
整理5个优秀的微信小程序开源项目_微信小程序开源模板-程序员宅基地
文章浏览阅读1w次，点赞13次，收藏97次。整理5个优秀的微信小程序开源项目。收集了微信小程序开发过程中会使用到的资料、问题以及第三方组件库。_微信小程序开源模板
随便推点
Centos7最简搭建NFS服务器_centos7 搭建nfs server-程序员宅基地
文章浏览阅读128次。Centos7最简搭建NFS服务器_centos7 搭建nfs server
Springboot整合Mybatis-Plus使用总结(mybatis 坑补充)_mybaitis-plus ruledataobjectattributemapper' and '-程序员宅基地
文章浏览阅读1.2k次，点赞2次，收藏3次。前言mybatis在持久层框架中还是比较火的，一般项目都是基于ssm。虽然mybatis可以直接在xml中通过SQL语句操作数据库，很是灵活。但正其操作都要通过SQL语句进行，就必须写大量的xml文件，很是麻烦。mybatis-plus就很好的解决了这个问题。..._mybaitis-plus ruledataobjectattributemapper' and 'com.picc.rule.management.d
EECE 1080C / Programming for ECESummer 2022 Laboratory 4: Global Functions Practice_eece1080c-程序员宅基地
文章浏览阅读325次。EECE 1080C / Programming for ECESummer 2022Laboratory 4: Global Functions PracticePlagiarism will not be tolerated:Topics covered:function creation and call statements (emphasis on global functions)Objective:To practice program development b_eece1080c
洛谷p4777 【模板】扩展中国剩余定理-程序员宅基地
文章浏览阅读53次。被同机房早就1年前就学过的东西我现在才学，wtcl。设要求的数为\(x\)。设当前处理到第\(k\)个同余式，设\(M = LCM ^ {k - 1} _ {i - 1}\) ，前\(k - 1\)个的通解就是\(x + i * M\)。那么其实第\(k\)个来说，其实就是求一个\(y\)使得\(x + y * M ≡ a_k(mod b_k)\)转化一下就是\(y * M ...
android 退出应用没有走ondestory方法,[Android基础论]为何Activity退出之后，系统没有调用onDestroy方法？...-程序员宅基地
文章浏览阅读1.3k次。首先，问题是如何出现的？晚上复查代码，发现一个activity没有调用自己的ondestroy方法我表示非常的费解，于是我检查了下代码。发现再finish代码之后接了如下代码finish();System.exit(0);//这就是罪魁祸首为什么这样写会出现问题System.exit(0);////看一下函数的原型public static void exit (int code)//Added ..._android 手动杀死app,activity不执行ondestroy
SylixOS快问快答_select函数 导致堆栈溢出 sylixos-程序员宅基地
文章浏览阅读894次。Q: SylixOS 版权是什么形式, 是否分为<开发版税>和<运行时版税>.A: SylixOS 是开源并免费的操作系统, 支持 BSD/GPL 协议(GPL 版本暂未确定). 没有任何的运行时版税. 您可以用她来做任何 您喜欢做的项目. 也可以修改 SylixOS 的源代码, 不需要支付任何费用. 当然笔者希望您可以将使用 SylixOS 开发的项目 (不需要开源)或对 SylixOS 源码的修改及时告知笔者.需要指出: SylixOS 本身仅是笔者用来提升自己水平而开发的_select函数 导致堆栈溢出 sylixos