Oracle Rac部署配置文档

1/53OracleRac部署配置文档2014年1月OracleRac部署配置文档文档版本信息属性内容文档名称：OracleRac部署配置文档软件名称：OracleRac软件版本：11gr2文档日期：2014.1.13制作人：北京昆仑联通科技发展有限公司OracleRac部署配置文档目录1.总述..........................................................................................................................................................................22.环境说明..................................................................................................................................................................22.1硬件环境.......................................................................................................................................................22.2软件环境.......................................................................................................................................................22.3网络环境配置...............................................................................................................................................33.系统环境配置..........................................................................................................................................................33.1安装oracle需要的系统软件包...................................................................................................................33.2配置系统hosts文件.....................................................................................................................................43.3配置系统核心参数.......................................................................................................................................43.4其它系统参数配置.......................................................................................................................................53.5创建并配置grid、oracle用户.....................................................................................................................64.安装clusterware......................................................................................................................................................85.创建asm磁盘........................................................................................................................................................236.安装数据库软件....................................................................................................................................................277.创建数据库............................................................................................................................................................36OracleRac部署配置文档文档信息文档信息属性内容文档名称：OracleRac部署配置文档文档编号：201401013.Comlan.Oracle.Rac文档版本：v1.0版本日期：2014.1.13制作人：高立明版本变更记录版本修订日期修订人描述OracleRac部署配置文档1.总述本文档适合安装oracle11gr2Rac环境在任何oracle技术认证OS平台，需要注意的是每个平台安装前期的环境配置会有所不同，本文档目的在于介绍oracle软件的安装配置过程，具体的OS环境配置，请参考oracle的官方文档，本文档部署配置环境为redhat。2.环境说明2.1硬件环境节点配信息节点节点名实例名数据库名RAM操作系统otcdb1otcdb1otcdb130GLinuxredhat6.2otcdb2otcdb2otcdb130GLinuxredhat6.2asm配置信息ASM磁盘组名PV属主权限单个LUN大小冗余OCR/dev/emcpowera1/dev/emcpowerb1/dev/emcpowerc1grid:asmadmin6601GNormalDATA/dev/emcpowerd1grid:asmadmin660300GExternalFRA/dev/emcpowere1grid:asmadmin660100GExternal2.2软件环境操作系统：liunxredhat6.2数据库存储:ASM数据库和集群件版本:ORACLE11gr2用户组和文件系统配置OracleRac部署配置文档用户组和文件系统配置软件组件用户主组辅助组主目录软件目录GridInfragridoinstallasmadminasmdbaasmoperdba/home/grid/u01/cluster/u01/app/grid/11.2.0RACoracleoinstalldbaasmadminasmdbaoper/home/oracle/u01/app/oracle/11.2.0/db_12.3网络环境配置每个节点一个publicIP每个节点一个publicVIP每个节点一个privateIPpublicprivvipeth0eth2eth0nodenameipnodenameipnodenameipotcdb1192.168.80.191otcdb1-priv10.10.0.1otcdb1-vip192.168.80.193otcdb2192.168.80.192otcdb1-priv10.10.0.2otcdb2-vip192.168.80.1943.系统环境配置3.1安装oracle需要的系统软件包对于liunx系统安装oracle11gr2rac需要如下系统补丁包binutils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2OracleRac部署配置文档gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.52glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2libstdc++-devel-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.113.2配置系统hosts文件在两个节点均添加如下信息到hosts文件vi/etc/hosts127.0.0.1localhost.localdomain#PublicNetwork-(eth0)192.168.80.191otcdb1192.168.80.192otcdb2#PrivateInterconnect-(eth2)10.10.0.1otcdb1-priv10.10.0.2otcdb2-priv#PublicVirtualIP(VIP)addresses-(eth0:1)192.168.80.193otcdb1-vip192.168.80.194otcdb2-vip#SCANIP192.168.80.195otcdb-cluster3.3配置系统核心参数在两个节点均需要添加如下信息vi/etc/sysctl.confkernel.shmmax=4294967295kernel.shmall=2097152kernel.shmmni=4096OracleRac部署配置文档kernel.sem=25032000100128fs.file-max=6815744net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048576fs.aio-max-nr=10485763.4其它系统参数配置以root用户身份，在每个OracleRAC节点上，在/etc/security/limits.conf文件中添加以下几行代码：cat/etc/security/limits.confEOFgridsoftnproc2047gridhardnproc16384gridsoftnofile1024gridhardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536EOF在每个OracleRAC节点上