你好,游客 登录 注册 搜索
背景:
阅读新闻

RedHat Linux 5.7下Oracle RAC 10.2.0.5 升级到11.2.0.4 PDF

[日期:2016-12-11] 来源:Linux社区  作者:su377486 [字体: ]

RedHat Linux 5.7下Oracle RAC 10.2.0.5 升级到11.2.0.4

RedHat Linux 5.7下Oracle RAC 10.2.0.5 升级到11.2.0.4

1.升级grid
当前rac状态:

[root@rac1 ~]# crs_stat -t
NameTypeTargetStateHost
------------------------------------------------------------
ora.rac.db application ONLINE ONLINE rac1
ora....c1.inst application ONLINE ONLINE rac1
ora....c2.inst application ONLINE ONLINE rac2
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
crs版本:

[root@rac1 ~]# crsctl query crs softwareversion
CRS software version on node [rac1] is [10.2.0.5.0]
数据库版本:

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus:Release10.2.0.5.0-Production on TueNov2219:07:552016
Copyright(c)1982,2010,Oracle.AllRightsReserved.
Connected to:
OracleDatabase10gEnterpriseEditionRelease10.2.0.5.0-64bitProduction
With the Partitioning,RealApplicationClusters, OLAP,DataMining
and RealApplicationTesting options
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
OracleDatabase10gEnterpriseEditionRelease10.2.0.5.0-64bi
PL/SQL Release10.2.0.5.0-Production
CORE 10.2.0.5.0Production
TNS forLinux:Version10.2.0.5.0-Production
NLSRTL Version10.2.0.5.0–Production
Ocr检查:

[oracle@rac1 ~]$ ocrcheck
Status of OracleClusterRegistry is as follows :
Version:2
Total space (kbytes):1043916
Used space (kbytes):3848
Available space (kbytes):1040068
ID :1371096888
Device/FileName:/dev/raw/raw1
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
表决盘检查:

[oracle@rac1 ~]$ crsctl query css votedisk
0.0/dev/raw/raw2
located 1 votedisk(s).
检查软件包安装

检查/etc/security/limit.conf

检查/etc/sysctl.conf

在hosts中添加scan ip信息:

[root@rac1 ~]# cat /etc/hosts
#Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.56.110 rac1
192.168.56.111 rac2
192.168.56.112 rac1-vip
192.168.56.113 rac2-vip
172.16.8.1 rac1-priv
172.16.8.2 rac2-priv
192.168.56.115 rac-scan
查看Oracle用户信息:

[oracle@rac1 ~]$ id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
由于是升级到11.2.0.4,grid的安装用户也使用oracle来安装,但是需要相应的用户组,手工来创建:
在所有节点修改oracle用户组添加asmadmin,asmdba,asmoper,oper组

groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1022 asmoper
groupadd -g 1032 oper
usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle
查看修改后的oracle用户组:
[root@rac1 ~]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),1020(asmadmin),1021(asmdba),1022(asmoper),1032(oper)
在所有节点创建11g安装文件目录

mkdir -p /u01/11.2.0/grid
chown -R oracle:oinstall /u01/11.2.0/grid
chmod -R 775/u01/11.2.0/grid
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1
chmod -R 775/u01/app/oracle/product/11.2.0/db_1
在所有节点添加oracle和grid的环境变量:

vi ~/.bash_profile

添加以下的别名:

alias ora="export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export PATH=/u01/app/oracle/product/11.2.0/db_1/bin:$CRS_HOME/bin:$PATH:$HOME/bin
export ORACLE_SID=rac1"
alias grid="export ORACLE_HOME=/u01/11.2.0/grid
export PATH=/u01/11.2.0/grid/bin:$CRS_HOME/bin:$PATH:$HOME/bin
export ORACLE_SID=+ASM1"
安装cvudisk包,用来检测oracle环境

[root@rac1 ~]# cd /home/oracle/grid/rpm/
[root@rac1 rpm]# ls
cvuqdisk-1.0.9-1.rpm
[root@rac1 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm
Preparing...###########################################[100%]
1:cvuqdisk ###########################################[100%]
[oracle@rac1 grid]$ pwd
/home/oracle/grid

RedHat Linux 5.7下Oracle RAC 10.2.0.5 升级到11.2.0.4图文详解PDF到Linux公社资源站下载:

------------------------------------------分割线------------------------------------------

免费下载地址在 http://linux.linuxidc.com/

用户名与密码都是www.linuxidc.com

具体下载目录在 /2016年资料/12月/11日/RedHat Linux 5.7下Oracle RAC 10.2.0.5 升级到11.2.0.4/

下载方法见 http://www.linuxidc.com/Linux/2013-07/87684.htm

------------------------------------------分割线------------------------------------------

本文永久更新链接地址http://www.linuxidc.com/Linux/2016-12/138204.htm

linux
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款