Oracle10.2.0.1RAC 升级 Oracle10.2.0.5案例分享 -CRS篇_craeta oci 10.2-程序员宅基地
这是一次数据库升级的案例。原有的数据库是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
到此位置集群软件的升级结束，由于篇幅图片编辑等限制数据库升级再下一篇博客中介绍。
智能推荐
基于内核4.19版本的XFRM框架_linux的xfrm框架-程序员宅基地
文章浏览阅读794次，点赞2次，收藏5次。XFRM框架_linux的xfrm框架
织梦常用标签整理_织梦中什么页面用什么标签教学-程序员宅基地
文章浏览阅读774次。DedeCMS常用标签讲解笔记整理 今天我们主要将模板相关内容，在前面的几节课中已经基本介绍过模板标签的相关内容，大家可以下载天工开物老师的讲课记录：http://bbs.dedecms.com/132951.html,这次课程我们主要讲解模板具体的标签使用，并且结合一些实例来介绍这些标签。 先前课程介绍了，网站的模板就如同一件衣服，衣服的好坏直接决定了网站的好坏，很多网站一看界面_织梦中什么页面用什么标签教学
工作中如何编译开源工具（gdb）_gdb编译-程序员宅基地
文章浏览阅读2.5k次，点赞2次，收藏15次。编译是大部分工程师的烦恼，大家普遍喜欢去写业务代码。但我觉得基本的编译流程，我们还是需要掌握的，希望遇到相关问题，不要退缩，尝试去解决。天下文章一大抄，百度能解决我们90%的问题。_gdb编译
python简易爬虫v1.0-程序员宅基地
文章浏览阅读1.8k次，点赞4次，收藏6次。python简易爬虫v1.0作者：William Ma (the_CoderWM)进阶python的首秀，大部分童鞋肯定是做个简单的爬虫吧，众所周知，爬虫需要各种各样的第三方库，例如scrapy, bs4, requests, urllib3等等。此处，我们先从最简单的爬虫开始。首先，我们需要安装两个第三方库：requests和bs4。在cmd中输入以下代码：pip install requestspip install bs4等安装成功后，就可以进入pycharm来写爬虫了。爬
安装flask后vim出现：error detected while processing /home/zww/.vim/ftplugin/python/pyflakes.vim:line 28_freetorn.vim-程序员宅基地
文章浏览阅读2.6k次。解决方法：解决方法可以去github重新下载一个pyflakes.vim。执行如下命令git clone --recursive git://github.com/kevinw/pyflakes-vim.git然后进入git克降目录，./pyflakes-vim/ftplugin,通过如下命令将python目录下的所有文件复制到~/.vim/ftplugin目录下即可。cp -R ...._freetorn.vim
HIT CSAPP大作业：程序人生—Hello‘s P2P-程序员宅基地
文章浏览阅读210次，点赞7次，收藏3次。本文简述了hello.c源程序的预处理、编译、汇编、链接和运行的主要过程，以及hello程序的进程管理、存储管理与I/O管理，通过hello.c这一程序周期的描述，对程序的编译、加载、运行有了初步的了解。_hit csapp
随便推点
挑战安卓和iOS！刚刚，华为官宣鸿蒙手机版，P40搭载演示曝光！高管现场表态：我们准备好了...-程序员宅基地
文章浏览阅读472次。点击上方 "程序员小乐"关注,星标或置顶一起成长后台回复“大礼包”有惊喜礼包！关注订阅号「程序员小乐」，收看更多精彩内容每日英文Sometimes you play a..._挑战安卓和ios!华为官宣鸿蒙手机版,p40搭载演示曝光!高管表态:我们准备好了
精选了20个Python实战项目(附源码)，拿走就用！-程序员宅基地
文章浏览阅读3.8w次，点赞107次，收藏993次。点击上方“Python爬虫与数据挖掘”，进行关注回复“书籍”即可获赠Python从入门到进阶共10本电子书今日鸡汤昔闻洞庭水，今上岳阳楼。大家好，我是小F。Python是目前最好的编程语言之一。由于其可读性和对初学者的友好性，已被广泛使用。那么要想学会并掌握Python，可以实战的练习项目是必不可少的。接下来，我将给大家介绍20个非常实用的Python项目，帮助大家更好的..._python项目
android在线图标生成工具,图标在线生成工具Android Asset Studio的使用-程序员宅基地
文章浏览阅读1.3k次。在网站的导航资源里看到了一个非常好用的东西：Android Asset Studio，可以在线生成各种图标。之前一直在用一个叫做Android Icon Creator的插件，可以直接在Android Studio的插件里搜索，这个工具的优点是可以生成适应各种分辨率的一套图标，有好几种风格的图标资源，遗憾的是虽然有很多套图标风格，毕竟是有限的。Android Asset Studio可以自己选择其..._在线 android 图标
android 无限轮播的广告位_轮播广告位-程序员宅基地
文章浏览阅读514次。无限轮播广告位没有录屏，将就将就着看，效果就是这样主要代码KsBanner.java/** * 广告位 * * Created by on 2016/12/20. */public class KsBanner extends FrameLayout implements ViewPager.OnPageChangeListener { private List
echart省会流向图（物流运输、地图）_java+echart地图+物流跟踪-程序员宅基地
文章浏览阅读2.2k次，点赞2次，收藏6次。继续上次的echart博客，由于省会流向图是从echart画廊中直接取来的。所以直接上代码<!DOCTYPE html><html><head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" /&_java+echart地图+物流跟踪
Ceph源码解析：读写流程_ceph 发送数据到其他副本的源码-程序员宅基地
文章浏览阅读1.4k次。一、OSD模块简介1.1 消息封装：在OSD上发送和接收信息。cluster_messenger -与其它OSDs和monitors沟通client_messenger －与客户端沟通1.2 消息调度：Dispatcher类，主要负责消息分类1.3 工作队列：1.3.1 OpWQ: 处理ops（从客户端）和sub ops（从其他的OSD）。运行在op_tp线程池。1...._ceph 发送数据到其他副本的源码