CentOS 64下RAC集群搭建.docx
- 文档编号:17231043
- 上传时间:2023-07-23
- 格式:DOCX
- 页数:37
- 大小:1.97MB
CentOS 64下RAC集群搭建.docx
《CentOS 64下RAC集群搭建.docx》由会员分享,可在线阅读,更多相关《CentOS 64下RAC集群搭建.docx(37页珍藏版)》请在冰点文库上搜索。
CentOS64下RAC集群搭建
InstallOracle11gRAConCentOS6.4环境说明:
本文搭建的是OracleDatabase11g的两节点RAC。
操作系统版本:
CentOS6.4
节点一:
主机名:
node1
公共网卡:
10.118.52.105
私有网卡:
192.168.0.1
节点二:
主机名:
node2
公共网卡:
10.118.52.106
私有网卡:
192.168.0.2
运行setup工具将以上IP地址设置完成
确认配置信息
运行ifconfig查看node1状态
[root@11g-node1~]#ifconfig
eth0 Linkencap:
Ethernet HWaddr00:
0C:
29:
2B:
AF:
D0
inetaddr:
10.118.52.105 Bcast:
192.168.56.255 Mask:
255.255.255.0
inet6addr:
fe80:
:
20c:
29ff:
fe2b:
afd0/64Scope:
Link
UPBROADCASTRUNNINGMULTICAST MTU:
1500 Metric:
1
RXpackets:
726errors:
0dropped:
0overruns:
0frame:
0
TXpackets:
599errors:
0dropped:
0overruns:
0carrier:
0
collisions:
0txqueuelen:
1000
RXbytes:
71049(69.3KiB) TXbytes:
73742(72.0KiB)
eth1 Linkencap:
Ethernet HWaddr00:
0C:
29:
2B:
AF:
DA
inetaddr:
192.168.0.1 Bcast:
192.168.10.255 Mask:
255.255.255.0
inet6addr:
fe80:
:
20c:
29ff:
fe2b:
afda/64Scope:
Link
UPBROADCASTRUNNINGMULTICAST MTU:
1500 Metric:
1
RXpackets:
30errors:
0dropped:
0overruns:
0frame:
0
TXpackets:
86errors:
0dropped:
0overruns:
0carrier:
0
collisions:
0txqueuelen:
1000
RXbytes:
6121(5.9KiB) TXbytes:
15787(15.4KiB)
运行ifconfig查看node2状态(同上)
查看网卡详细配置信息
cat/etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
#BOOTPROTO=dhcp
BOOTPROTO=static
IPADDR=10.118.52.105
MASK=255.255.255.0
GATEWAY=10.118.52.255
DHCPCLASS=
HWADDR=00:
0C:
29:
2B:
AF:
D0
ONBOOT=yes
关闭防火墙和SELinux
Iptanbles–F
Vim/etc/sysconfig/selinuxSELinux将selinux=enforcing改为disable
查看防火墙(iptables)与SELinux状态:
[root@11g-node1~]#serviceiptablesstatus
Firewallisstopped.
[root@11g-node1~]#sestatus
SELinuxstatus:
disabled
配置yum仓库
/etc/yum.repos,d/base.repo
Yum仓库状态
[root@11g-node1~]#yumrepolist
Loadedplugins:
product-id,security,subscription-manager
ThissystemisnotregisteredtoRedHatSubscriptionManagement.Youcanusesubscription-managertoregister.
Cluster |1.5kB 00:
00
Cluster/primary |6.1kB 00:
00
Cluster 32/32
ClusterStorage |1.5kB 00:
00
ClusterStorage/primary |8.6kB 00:
00
ClusterStorage 39/39
Server |1.5kB 00:
00
Server/primary |942kB 00:
00
Server 3358/3358
VT |1.3kB 00:
00
VT/primary | 19kB 00:
00
VT 59/59
repoid reponame status
Cluster Cluster 32
ClusterStorage ClusterStorage 39
Server Server 3,358
VT VT 59
repolist:
3,488
.对配置文件的修改
/etc/hosts
#Localhost
127.0.0.1 localhost
#forOracleDatabase11gRealApplicationCluster
#PublicDomain
192.168.0.1 11g-node1
192.168.0.2 11g-node2
#VirtualIPDomain,VIP
10.118.52.105 11g-node1-vip
10.118.52.106 11g-node2-vip
#PrivateDomain
10.118.52.107 11g-node1-priv
10.118.52.108 11g-node2-priv
#SCAN
10.118.52.109 scan
配置内核参数
/etc/sysctl.conf
内核参数信息:
#forOracledatabase11gRAC
kernel.shmmax=4294967295
kernel.shmall=2097152
kernel.shmmni=4096
kernel.sem=25032000100128
fs.file-max=6815744
net.ipv4.ip_local_port_range=900065500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr=1048576
使立即生效
sysctl–p
新增系统用户和系统组
groupadd-g1000oinstall
groupadd-g1200asmadmin
groupadd-g1201asmdba
groupadd-g1202asmoper
useradd-m-u1100-goinstall-Gasmadmin,asmdba,asmoper-c"GridInfrastructureOwner"grid
echo"oracle"|passwdgrid--stdin
groupadd-g1300dba
groupadd-g1301oper
useradd-m-u1101-goinstall-Gdba,oper,asmdba-c"OracleSoftwareOwner"oracle
echo"oracle"|passwdoracle--stdin
用户(grid)环境变量的设定
User:
grid(注意环境变量两个节点oracleSID不一致)
节点一:
ORACLE_SID=hbstsg1;exportORACLE_SID
节点二:
ORACLE_SID=hbstsg2;exportORACLE_SID
GRID环境变量状态:
#.bash_profile
#Getthealiasesandfunctions
if[-f~/.bashrc];then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms
PATH=$PATH:
$HOME/bin
exportPATH
#OracleDatabase11gRAC
#GridNode1
ORACLE_SID=hbstsg1;exportORACLE_SID
JAVA_HOME=/usr/local/java;exportJAVA_HOME
ORACLE_BASE=/u01/app/grid;exportORACLE_BASE
ORACLE_HOME=/u01/app/11.2.0/grid;exportORACLE_HOME
ORACLE_PATH=/u01/app/oracle/common/oracle/sql;exportORACLE_PATH
ORACLE_TERM=xterm;exportORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYYHH24:
MI:
SS";exportNLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin;exportTNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data;exportORA_NLS11
PATH=.:
${JAVA_HOME}/bin:
${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
PATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
PATH=${PATH}:
/u01/app/common/oracle/bin
exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportCLASSPATH
THREADS_FLAG=native;exportTHREADS_FLAG
exportTEMP=/tmp
exportTMPDIR=/tmp
User:
oracle
节点一:
ORACLE_SID=hbstsg1;exportORACLE_SID
节点二:
ORACLE_SID=hbstsg2;exportORACLE_SID
User:
oracle(注意环境变量两个节点oracleSID不一致)
ORACLE用户环境变量信息
#.bash_profile
#Getthealiasesandfunctions
if[-f~/.bashrc];then
.~/.bashrc
fi
#Userspecificenvironmentandstartupprograms
PATH=$PATH:
$HOME/bin
exportPATH
#OracleDatabase11gRAC
#OracleNode1
ORACLE_SID=hbstsg1;exportORACLE_SID
ORACLE_UNQNAME=edendb;exportORACLE_UNQNAME
JAVA_HOME=/usr/local/java;exportJAVA_HOME
ORACLE_BASE=/u01/app/oracle;exportORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;exportORACLE_HOME
ORACLE_PATH=/u01/app/common/oracle/sql;exportORACLE_PATH
ORACLE_TERM=xterm;exportORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYYHH24:
MI:
SS";exportNLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin;exportTNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data;exportORA_NLS11
PATH=.:
${JAVA_HOME}/bin:
${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
PATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
PATH=${PATH}:
/u01/app/common/oracle/bin
exportPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportCLASSPATH
THREADS_FLAG=native;exportTHREADS_FLAG
exportTEMP=/tmp
exportTMPDIR=/tmp
使环境变量立刻生效
source~/.bash_profile
.创建ORACLE_BASE、ORACLE_HOME需要的目录结构
切换为ROOT用户
mkdir/u01
chown-Rgrid.oinstall/u01/
chmod-R755/u01/
mkdir/u01/app/oracle
chown-Roracle.oinstall/u01/app/oracle/
切换为grid用户
[grid@11g-node1~]$env|grep--colorORACLE_
ORACLE_PATH=/u01/app/oracle/common/oracle/sql
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/grid
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/11.2.0/grid
[grid@11g-node1~]$
[grid@11g-node1~]$mkdir-p$ORACLE_BASE
[grid@11g-node1~]$mkdir-p$ORACLE_HOME
[grid@11g-node1~]$mkdir-p$ORACLE_PATH
切换为oracle用户
[oracle@11g-node1~]$env|grep--colorORACLE_
ORACLE_PATH=/u01/app/common/oracle/sql
ORACLE_UNQNAME=edendb
ORACLE_SID=edendb1
ORACLE_BASE=/u01/app/oracle
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@11g-node1~]$
[oracle@11g-node1~]$mkdir-p$ORACLE_HOME
.Oracle需要的操作系统软件包支持
通过上面配置的yum安装一下oracle所依赖的包:
yuminstallbinutils*compat-libstdc++-*elfutils-libelf-*elfutils-libelf-devel-*elfutils-libelf-devel-static-*gcc-*gcc-c++-*glibc-*glibc-common-*glibc-devel-*glibc-headers-*kshlibaio-*libaio-devel-*libgcclibstdc++-*libstdc++-develmakesysstatunixODBCunixODBC-develcompat-libstdc++-33.i386compat-libstdc++-296.i386glibc.i686glibc-devel.i386unixODBC.i386unixODBC-devel.i386libaio.i386libaio-devel.i386libgcc.i386libstdc++.i386libstdc++-devel.i386libaio-devel.i386libXp.i386
.SSH等价性
SSH等价性的配置是针对OracleRAC与操作系统关联的用户(grid、oracle)实施的。
它的目的是:
在主机一上,通过grid用户SSH到主机二,不需要验证密码,反之亦然。
而针对oracle用户,也需要实现同样的策略。
相关命令:
1.ssh-keygen
2.ssh-copy-id
(每个节点的每个用户到各个节点的同一用户都要做出相关操作)
下面,仅通过主机一的grid用户做说明,其他的各个主机的各个用户(grid、oracle)类似的操作。
Grid:
生成一对私钥与公钥
su–grid
ssh-keygen-trsa
将公钥传递给各个节点
ssh-copy-id-i.ssh/id_rsa.pub11g-node1
ssh-copy-id-i.ssh/id_rsa.pub11g-node2
ssh-copy-id-i.ssh/id_rsa.pub11g-node1-priv
ssh-copy-id-i.ssh/id_rsa.pub11g-node2-priv
验证
ssh11g-node1date
ssh11g-node2date
ssh11g-node1-privdate
ssh11g-node2-privdate
配置Rawdevices
(对/etc/sysconfig/rawdevices的操作要在各个节点间同步)
[root@11g-node1~]#cat/etc/sysconfig/rawdevices
#rawdevicebindings
#f
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- CentOS 64下RAC集群搭建 64 RAC 集群 搭建