没有合适的资源?快使用搜索试试~ 我知道了~
首页oracle rac10205升级到11204
oracle rac10205升级到11204
需积分: 46 24 下载量 24 浏览量
更新于2023-03-16
评论 1
收藏 2.61MB DOCX 举报
redhat5.7下oracle rac 10.2.0.5.0升级到11.2.0.4.0
资源详情
资源评论
资源推荐
1.升级 grid
当前 rac 状态:
1. [root@rac1 ~]# crs_stat -t
2. Name Type Target State Host
3. ---------------------------------------------------------
---
4. ora.rac.db application ONLINE ONLINE rac1
5. ora....c1.inst application ONLINE ONLINE rac1
6. ora....c2.inst application ONLINE ONLINE rac2
7. ora....SM1.asm application ONLINE ONLINE rac1
8. ora....C1.lsnr application ONLINE ONLINE rac1
9. ora.rac1.gsd application ONLINE ONLINE rac1
10. ora.rac1.ons application ONLINE ONLINE rac1
11. ora.rac1.vip application ONLINE ONLINE rac1
12. ora....SM2.asm application ONLINE ONLINE rac2
13. ora....C2.lsnr application ONLINE ONLINE rac2
14. ora.rac2.gsd application ONLINE ONLINE rac2
15. ora.rac2.ons application ONLINE ONLINE rac2
16. ora.rac2.vip application ONLINE ONLINE rac2
crs 版本:
1. [root@rac1 ~]# crsctl query crs softwareversion
2. CRS software version on node [rac1] is [10.2.0.5.0]
数据库版本:
1. [oracle@rac1 ~]$ sqlplus / as sysdba
2. SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22
19:07:55 2016
3. Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
4. Connected to:
5. Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
- 64bit Production
6. With the Partitioning, Real Application Clusters, OLAP,
Data Mining
7. and Real Application Testing options
8.
9. SQL> select * from v$version;
10.
11. BANNER
12. ---------------------------------------------------------
-------
13. Oracle Database 10g Enterprise Edition Release 10.2.0.5.0
- 64bi
14. PL/SQL Release 10.2.0.5.0 - Production
15. CORE 10.2.0.5.0 Production
16. TNS for Linux: Version 10.2.0.5.0 - Production
17. NLSRTL Version 10.2.0.5.0 – Production
Ocr 检查:
1. [oracle@rac1 ~]$ ocrcheck
2. Status of Oracle Cluster Registry is as follows :
3. Version : 2
4. Total space (kbytes) : 1043916
5. Used space (kbytes) : 3848
6. Available space (kbytes) : 1040068
7. ID : 1371096888
8. Device/File Name : /dev/raw/raw1
9. Device/File integrity
check succeeded
10.
11. Device/File not
configured
12.
13. Cluster registry integrity check succeeded
表决盘检查:
1. [oracle@rac1 ~]$ crsctl query css votedisk
2. 0. 0 /dev/raw/raw2
3.
4. located 1 votedisk(s).
检查软件包安装
检查/etc/security/limit.conf
检查/etc/sysctl.conf
在 hosts 中添加 scan ip 信息:
1. [root@rac1 ~]# cat /etc/hosts
2. # Do not remove the following line, or various programs
3. # that require network functionality will fail.
4. 127.0.0.1 localhost.localdomain localhost
5. ::1 localhost6.localdomain6 localhost6
6. 192.168.56.110 rac1
7. 192.168.56.111 rac2
8.
9. 192.168.56.112 rac1-vip
10. 192.168.56.113 rac2-vip
11.
12. 172.16.8.1 rac1-priv
13. 172.16.8.2 rac2-priv
14.
15. 192.168.56.115 rac-scan
查看 oracle 用户信息:
1. [oracle@rac1 ~]$ id oracle
2. uid=500(oracle) gid=500(oinstall)
groups=500(oinstall),501(dba)
由于是升级到 11.2.0.4,grid 的安装用户也使用 oracle 来安装,但是需要相应的用户组,手工来创
建:
在所有节点修改 oracle 用户组添加 asmadmin,asmdba,asmoper,oper 组
1. groupadd -g 1020 asmadmin
2. groupadd -g 1021 asmdba
3. groupadd -g 1022 asmoper
4. groupadd -g 1032 oper
5. usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper
oracle
查看修改后的 oracle 用户组:
1. [root@rac1 ~]# id oracle
2. uid=500(oracle) gid=500(oinstall)
groups=500(oinstall),501(dba),1020(asmadmin),1021(asmdba)
,1022(asmoper),1032(oper)
在所有节点创建 11g 安装文件目录
1. mkdir -p /u01/11.2.0/grid
2. chown -R oracle:oinstall /u01/11.2.0/grid
3. chmod -R 775 /u01/11.2.0/grid
4. mkdir -p /u01/app/oracle/product/11.2.0/db_1
5. chown -R oracle:oinstall
/u01/app/oracle/product/11.2.0/db_1
6. chmod -R 775 /u01/app/oracle/product/11.2.0/db_1
在所有节点添加 oracle 和 grid 的环境变量:
vi ~/.bash_prole
添加以下的别名:
1. alias ora="export
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
2. export
PATH=/u01/app/oracle/product/11.2.0/db_1/bin:$CRS_HOME/bi
n:$PATH:$HOME/bin
3. export ORACLE_SID=rac1"
4. alias grid="export ORACLE_HOME=/u01/11.2.0/grid
5. export PATH=/u01/11.2.0/grid/bin:
$CRS_HOME/bin:$PATH:$HOME/bin
6. export ORACLE_SID=+ASM1"
安装 cvudisk 包,用来检测 oracle 环境
1. [root@rac1 ~]# cd /home/oracle/grid/rpm/
2. [root@rac1 rpm]# ls
3. cvuqdisk-1.0.9-1.rpm
4. [root@rac1 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm
5. Preparing...
########################################### [100%]
6. 1:cvuqdisk
########################################### [100%]
7.
8. [oracle@rac1 grid]$ pwd
9. /home/oracle/grid
执行 runcluvfy.sh 来检查升级环境:
1. ./runcluvfy.sh stage -pre crsinst -upgrade -n rac1,rac2 -
rolling -src_crshome /u01/app/oracle/product/10.2.0/crs -
dest_crshome /u01/11.2.0/grid -dest_version 11.2.0.4.0 -
fixup -fixupdir /home/oracle/fixupscript –verbose
1. [oracle@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -
upgrade -n rac1,rac2 -rolling -src_crshome
/u01/app/oracle/product/10.2.0/crs -dest_crshome
/u01/11.2.0/grid -dest_version 11.2.0.4.0 -fixup -
fixupdir /home/oracle/fixupscript -verbose
2.
3. Performing pre-checks for cluster services setup
4.
5. Checking node reachability...
6.
7. Check: Node reachability from node "rac1"
8. Destination Node Reachable?
9. ------------------------------------
------------------------
10. rac2 yes
11. rac1 yes
12. Result: Node reachability check passed from node "rac1"
13.
14.
15. Checking user equivalence...
16.
17. Check: User equivalence for user "oracle"
18. Node Name Status
19. ------------------------------------
------------------------
20. rac2 passed
21. rac1 passed
22. Result: User equivalence check passed for user "oracle"
23.
24. Checking CRS user consistency
25. Result: CRS user consistency check successful
26.
27. Checking node connectivity...
28.
29. Checking hosts config file...
30. Node Name Status
31. ------------------------------------
------------------------
32. rac2 passed
33. rac1 passed
34.
35. Verification of the hosts config file successful
36.
37.
38. Interface information for node "rac2"
剩余63页未读,继续阅读
久违的太阳
- 粉丝: 135
- 资源: 11
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 2022年中国足球球迷营销价值报告.pdf
- 房地产培训 -营销总每天在干嘛.pptx
- 黄色简约实用介绍_汇报PPT模板.pptx
- 嵌入式系统原理及应用:第三章 ARM编程简介_3.pdf
- 多媒体应用系统.pptx
- 黄灰配色简约设计精美大气商务汇报PPT模板.pptx
- 用matlab绘制差分方程Z变换-反变换-zplane-residuez-tf2zp-zp2tf-tf2sos-sos2tf-幅相频谱等等.docx
- 网络营销策略-网络营销团队的建立.docx
- 电子商务示范企业申请报告.doc
- 淡雅灰低面风背景完整框架创业商业计划书PPT模板.pptx
- 计算模型与算法技术:10-Iterative Improvement.ppt
- 计算模型与算法技术:9-Greedy Technique.ppt
- 计算模型与算法技术:6-Transform-and-Conquer.ppt
- 云服务安全风险分析研究.pdf
- 软件工程笔记(完整版).doc
- 电子商务网项目实例规划书.doc
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0