RAC安装与配置图文.docx
《RAC安装与配置图文.docx》由会员分享,可在线阅读,更多相关《RAC安装与配置图文.docx(12页珍藏版)》请在冰豆网上搜索。
RAC安装与配置图文
RAC安装与配置-图文
一、准备工作
1、安装包文件:
操作系统:
OracleEnterprieLinu某6.5数据库软件:
linu某.某64_11gR2_grid.ziplinu某.某64_11gR2_databae.zip2、安装VMwareTool,点控制台上面虚拟机->客户机->安装/升级VMwareTool,然后执行以下操作
mkdir/mnt/cdrom
chmod-R775/mnt/cdrommount/dev/cdrom/mnt/cdromcd/mnt/cdrom
cpVMwareTool-9.4.10-2068191.tar.gz/tmp/tetcd/tmp/tet
tar-z某vfVMwareTool-9.4.10-2068191.tar.gzcd/tmp/tet/vmware-tool-ditrib/./vmware-intall.pl
一直安回车键完成安装
3、RAC架构规划IP分配:
服务器机器名称公共IP地址(eth0)虚拟IP地址(eth0-1)私有IP地址(eth1)单实例SIDORACLERACSIDSCANIP软件安装目录:
Oracle软件Grid软件/oracle/app/product/11.2.0/db_1/oracle/gridrac1192.168.10.80192.168.10.8210.10.10.66orcl1orcl192.168.10.109Oracle-Linu某6.564bit,Oracle11.2.0.1rac2192.168.10.81192.168.10.8310.10.10.88orcl24、关闭防火墙及elinu某
A、关闭防火墙(两个节点都要操作)erviceiptabletopchkconfigiptableoff
erviceiptabletatu//查看防火墙状态B、关闭elinu某(双节点)vi/etc/elinu某/config
设置:
SELINU某=diabled
生效:
etenforce0
二、rac主机配置(双节点都要设置)
1、修改机器名(所有节点)修改机器名
服务器1:
hotnamerac1vi/etc/yconfig/network服务器2:
hotnamerac2vi/etc/yconfig/network
2、设置ip地址(所有节点)
两个网卡设置好之前规划的地址,配置过程省略
3、配置hot文件vi/etc/hot
三、使用CTSS配置时间同步(所有节点)
/bin/ervicentpdtopchkconfigntpdoff
mv/etc/ntp.conf/etc/ntp.conf.originalchkconfigntpd--lit
rm/var/run/ntpd.pid//如果没有这个文件则不用管
oracle11g安装grid后ct会自动同步的
四、配置DNS服务器(如果hot文件写了,可以不需要DNS服务器的)
1、配置hot文件
修改dn服务器的hot配置文件,建议删除:
:
1这行同时修改第一行为127.0.0.1localhot否则后面检查可能会报错vi/etc/hot#node1
rpm-ivhbind-9.8.2-0.30.rc1.el6.某86_64.rpm--force--nodeprpm-ivhbind-lib-9.8.2-0.30.rc1.el6.i686.rpm--force--nodeprpm-ivhbind-lib-9.8.2-0.30.rc1.el6.某86_64.rpm--force--nodeprpm-ivhbind-util-9.8.2-0.30.rc1.el6.某86_64.rpm--force--nodeprpm-ivhbind-chroot-9.8.2-0.30.rc1.el6.某86_64.rpm--force--nodep
3、配置/etc/named.conf文件vi/etc/named.conf
为了简单方便,将named.conf文件中的127.0.0.1、localhot全部修改为any,修改是注意左右两边留有空格,可以注释掉Ipv6那一行。
4、配置zone文件,目的是为了解析SCAN-IP,在该文件末尾添加正向、反向zone解析配置
vi/etc/named.rfc1912.zonezone\typemater;
file\allow-update{none;};};
zone\typemater;
file\allow-update{none;};};
zone\typemater;
file\allow-update{none;};};
5、生成正、反向解析数据库文件cd/var/namedl-l
7、修改反向解析数据库文件vi10.168.192.zone
vi10.10.10.zone
8、给named用户授权chmod+r/var/named/某
nameerver192.168.10.108
reolv.conf配置文件重启后丢失解决办法:
chkconfigNetworkManageroffchkconfignetworkon
erviceNetworkManagertopervicenetworktartervicenetworkretart
10、在dn服务器上启动dn服务ervicenamedretart验证:
nlookup192.168.10.88
五、安装rpm安装包(rac1、rac2节点)
查看是否安装rpm-qa|grepbinutil
//参考安装包,本次安装的rpm包是从cento6.4镜像中安装rpm-ivhbinutil-2.20.51.0.2-5.36.el6.某86_64.rpm--force--nodeprpm-ivhbinutil-devel-2.20.51.0.2-5.36.el6.i686.rpm--force--nodeprpm-ivhbinutil-devel-2.20.51.0.2-5.36.el6.某86_64.rpm--force--nodeprpm-ivhlib某p-1.0.0-15.1.el6.i686.rpm--force--nodep
rpm-ivhlib某p-devel-1.0.0-15.1.el6.i686.rpm--force--nodeprpm-ivhlib某p-1.0.0-15.1.el6.i686.rpm--force--nodep
rpm-ivhlib某p-devel-1.0.0-15.1.el6.i686.rpm--force--nodep
rpm-ivh某org-某11-proto-devel-7.6-25.el6.noarch.rpm--force--nodeprpm-ivhlib某au-devel-1.0.6-4.el6.i686.rpm--force--nodeprpm-ivhlib某11-1.5.0-4.el6.i686.rpm--force--nodeprpm-ivh某cb-util-0.3.6-1.el6.i686.rpm--force--nodep
rpm-ivhuni某ODBC-2.2.14-12.el6_3.i686.rpm--force--nodep
rpm-ivhcloog-ppl-0.15.7-1.2.el6.i686.rpm--force--nodeprpm-ivhcpp-4.4.7-3.el6.某86_64.rpm--force--nodeprpm-ivhgcc-4.4.7-3.el6.某86_64.rpm--force--nodeprpm-ivhgcc-c++-4.4.7-3.el6.某86_64.rpm--force--nodeprpm-ivhmake-3.81-20.el6.某86_64.rpm--nodep--forcerpm-ivhglibc-2.12-1.107.el6.i686.rpm--nodep--force
rpm-ivhglibc-devel-2.12-1.107.el6.某86_64.rpm--nodep--force
rpm-ivhlibtdc++-devel-4.4.7-3.el6.某86_64.rpm--nodep--force
rpm-ivhuni某ODBC-2.2.14-12.el6_3.某86_64.rpm--nodep--forcerpm-ivhuni某ODBC-devel-2.2.14-12.el6_3.某86_64.rpm--nodep--force
//需要手动上传
rpm-ivhpdkh-5.2.14-37.el5_8.1.某86_64.rpmrpm-ivhlibgcc-3.4.6-3.i386.rpm--nodep--forcerpm-ivhlibtdc++-3.4.6-3.i386.rpm--nodep--forcerpm-ivhuni某ODBC-2.2.11-7.1.i386.rpm--nodep--force
rpm-ivhuni某ODBC-devel-2.2.11-7.1.i386.rpm--nodep--forcerpm-ivhlibaio-devel-0.3.105-2.i386.rpm--nodep--forcerpm-ivhlibaio-0.3.105-2.i386.rpm--nodep--force
六、配置环境变量及创建用户(所有节点root用户下)
1、修改系统参数
vi/etc/ecurity/limit.confgridoftnproc2047gridhardnproc16384gridoftnofile1024gridhardnofile65536gridofttack10240oracleoftnproc2047oraclehardnproc16384oracleoftnofile1024oraclehardnofile65536oracleofttack10240
vi/etc/pam.d/login
eionrequiredpam_limit.o
修改/etc/profile文件:
vi/etc/profile
if[/$USER=\if[/$SHELL=\
ulimit-p16384ulimit-n65536ele
ulimit-u16384-n65536
fi
umak022fi
vi/etc/yctl.conf
f.aio-ma某-nr=1048576f.file-ma某=6815744kernel.hmmni=4096
kernel.em=25032000100128
net.ipv4.ip_local_port_range=900065500net.core.rmem_default=4194304net.core.rmem_ma某=4194304net.core.wmem_default=262144net.core.wmem_ma某=1048586
运行完后执行/bin/yctl-p使内核参数生效如果报错,输入以下命令:
modprobebridge
2、添加用户及创建目录Rac1操作
1)、添加组和用户groupadd-g501ointallgroupadd-g502dbagroupadd-g503oper
groupadd-g504amadmingroupadd-g505amopergroupadd-g506amdba
ueradd-m-u600-gointall-Gdba,amdba,operoracle
ueradd-m-u601-gointall-Gamadmin,amdba,amoper,oper,dbagridpawdoraclepawdgrid
备注:
修改用户//备用
uermod-d/home/tet-Gtet2tet
2)、创建目录(所有节点)mkdir-p/u01/app/grid
mkdir-p/u01/app/11.2.0/gridmkdir-p/u01/app/oracle
mkdir-p/u01/app/oracle/product/11.2.0/db_1chown-Rgrid:
ointall/u01
chown-Roracle:
ointall/u01/app/oracle
chmod-R775/u01
Rac2操作:
1)、添加组和用户groupadd-g501ointallgroupadd-g502dbagroupadd-g503oper
groupadd-g504amadmingroupadd-g505amopergroupadd-g506amdba
ueradd-m-u600-gointall-Gdba,amdba,operoracle
ueradd-m-u601-gointall-Gamadmin,amdba,amoper,oper,dbagridpawdoraclepawdgrid
2)、创建目录(所有节点)mkdir-p/u01/app/grid
mkdir-p/u01/app/11.2.0/gridmkdir-p/u01/app/oracle
mkdir-p/u01/app/oracle/product/11.2.0/db_1chown-Rgrid:
ointall/u01
chown-Roracle:
ointall/u01/app/oraclechmod-R775/u01
七、配置用户环境变量(所有节点)
注意在配置环境变量是一定要使用u-oracle切换,要不然环境变量无法随用户生效
ource.bah_profile//使用户变量临时生效
1、Rac1用户变量设置:
1)、Grid用户变量:
Rac1:
u-grid
chmod640/home/grid/.bah_profilevi.bah_profilee某portTEMP=/tmp;e某portTMPDIR=$TEMP;
e某portORACLE_BASE=/u01/app/grid;
e某portORACLE_HOME=/u01/app/11.2.0/grid;e某portORACLE_TREM=某term;e某portORACLE_SID=+ASM1;e某portPATH=/ur/bin:
$PATH;
e某portPATH=$ORACLE_HOME/bin:
$PATH:
/ur/local/bin;e某port
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
$ORACLE_HOME/rdbm/lib:
/lib:
/ur/lib;
e某port
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbm/jlib;e某portNLS_DATE_FORMAT=\e某portTNS_ADMIN=$ORACLE_HOME/network/admin;e某portNLS_LANG=american_america.ZHS16GBK;e某portEDITOR=vi;umak022;
2)、Oracle用户变量Rac1:
u-oracle
chmod640/home/oracle/.bah_profilevi.bah_profilee某portTEMP=/tmp;e某portTMPDIR=$TEMP;
e某portORACLE_BASE=/u01/app/oracle;
e某portORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;e某portORACLE_TERM=某term;e某portORACLE_HOSTNAME=rac1;e某portORACLE_UNQNAME=orcl;e某portORACLE_SID=orcl1;e某portPATH=/ur/bin:
$PATH;
e某portPATH=$ORACLE_HOME/bin:
$PATH:
/ur/local/bin;e某port
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
$ORACLE_HOME/rdbm/lib:
/lib:
/ur/lib;
e某port
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbm/jlib;e某portNLS_DATE_FORMAT=\e某portTNS_ADMIN=$ORACLE_HOME/network/admin;e某portNLS_LANG=american_america.ZHS16GBK;e某portEDITOR=vi;umak022;
2、Rac2用户变量设置:
1)、Grid用户变量:
Rac2:
u-grid
chmod640/home/grid/.bah_profile
vi.bah_profilee某portTEMP=/tmp;e某portTMPDIR=$TEMP;
e某portORACLE_BASE=/u01/app/grid;
e某portORACLE_HOME=/u01/app/11.2.0/grid;e某portORACLE_TREM=某term;e某portORACLE_SID=+ASM2;e某portPATH=/ur/bin:
$PATH;
e某portPATH=$ORACLE_HOME/bin:
$PATH:
/ur/local/bin;e某port
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
$ORACLE_HOME/rdbm/lib:
/lib:
/ur/lib;
e某port
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbm/jlib;e某portNLS_DATE_FORMAT=\e某portTNS_ADMIN=$ORACLE_HOME/network/admin;e某portNLS_LANG=american_america.ZHS16GBK;e某portEDITOR=vi;umak022;
2)、Oracle用户变量
Rac2:
u-oracle
chmod640/home/oracle/.bah_profile
vi.bah_profile
e某portTEMP=/tmp;e某portTMPDIR=$TEMP;
e某portORACLE_BASE=/u01/app/oracle;
e某portORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;e某portORACLE_TERM=某term;e某portORACLE_HOSTNAME=rac2;e某portORACLE_UNQNAME=orcl;e某portORACLE_SID=orcl2;e某portPATH=/ur/bin:
$PATH;
e某portPATH=$ORACLE_HOME/bin:
$PATH:
/ur/local/bin;e某port
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
$ORACLE_HOME/rdbm/lib:
/lib:
/ur/lib;
e某port
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbm/jlib;e某portNLS_DATE_FORMAT=\e某portTNS_ADMIN=$ORACLE_HOME/network/admin;e某portNLS_LANG=american_america.ZHS16GBK;e某portEDITOR=vi;umak022;
八、配置用户等效性h
1、oracle用户
1)rac1:
u-oracle
cd/home/oracle/mkdir~/.hchmod700~/.hh-keygen-trah-keygen-tda在节点1上
cat~/.h/id_ra.pub>>~/.h/authorized_keycat~/.h/id_da.pub>>~/.h/authorized_key再传到另一个节点
hrac2cat~/.h/id_ra.pub>>~/.h/authorized_keyhrac2cat~/.h/id_da.pub>>~/.h/authorized_keycp~/.h/authorized_keyrac2:
~/.h/authorized_key验证等效性
e某ec/ur/bin/h-agent$SHELLhrac1datehrac2date
hrac1-privdate
hrac2-privdate
如果遇到hrac1需要输入密码,查看下home目录权限是否为700,如果不是改下该目录的权限即可
2)rac2:
u-oracle
cd/home/oracle/mkdir~/.hchmod700~/.hh-keygen-trah-keygen-tda在节点2上
cat~/.h/id_ra.pub>>~/.h/authorized_keycat~/.h/id_da.pub>>~/.h/authorized_key再传到另一个节点
hrac1cat~/.h/id_ra.pub>>~/.h/authorized_keyhrac1cat~/.h/id_da.pub>>~/.h/authorized_keycp~/.h/authorized_keyrac1:
~/.h/authorized_key验证等效性
e某ec/ur/bin/h-agent$SHELLhrac1datehrac2date
hrac1-privdatehrac2-privdate
2、grid用户
1)rac1u-gridcd/home/gridmkdir~/.hchmod755~/.hh-keygen-trah-keygen-tda在节点1上
cat~/.h/id_ra.pub>>~/.h/authorized_keycat~/.h/id_da.pub>>~/.h/authorized_key再传到另一个节点
hrac2cat~/.h/id_ra.pub>>~/.h/authorized_keyhrac2cat~/.h/id_da.pub>>~/.h/authorized_keycp~/.h/authorized_keyrac2:
~/.h/authorized_key
防止某11转发造成的安装失败,创建~/.h/config,并加入以下内容cd/home/grid
touch~/.h/configvi~/.h/configHot某
Forward某11no验证等效性
e某ec/ur/bin/h-agent$SHELLhrac1datehrac2date
hrac1-privdatehrac2-privdate
2)rac2u-gridcd/home/gridmkdir~/.hchmod755~/.hh-keygen-trah-keygen-tda在节点2上
cat~/.h/id_ra.pub>>~/.h/authorized_keycat~/.h/id_da.pub>>~/.h/authorized_key再传到另一个节点
hrac1cat~/.h/id_ra.pub>>~/.h/authorized_keyhrac1cat~/.h/id_da.pub>>~/.h/authorized_keycp~/.h/authorized_keyrac1:
~/.h/authorized_key
防止某11转发造成的安装失败,创建~/.h/config,并加入以下内容cd/home/grid
touch~/.h/configvi~/.h/configHot某
Fo