Oracle11g RAC 实施手册

一系统网络资源1.1网络分配：主机名公网(public)专网(private)虚拟网(vip)Rac1IPIPIPRac2IPIPIP1.2硬件资源Cpu：Intel(R)Xeon(TM)MPCPU3.16GHz*2内存：1G硬盘：20G共享磁盘：6G1.3操作系统安装1.3.1操作系统版本：RedHatEnterpriseLinuxASrelease4(NahantUpdate4)1.3.2系统分区分区信息分区类型分区大小/bootext3100M/ext310240MSwapswap2048/oracleext310240M/optext35120M/tmpext31024M1.3.3系统语言简体中文，ENGLISH（USA）1.3.4安装模式完全安装二数据安装资源2.1数据库安装包2.1.1ORACLE11G软件包：下载地址：(11.1.0.6.0)forLinuxx86OracleDatabase11gRelease1Client(11.1.0.6.0)forLinuxx86OracleDatabase11gExamples(formerlyCompanion)OracleClusterwareRelease1(11.1.0.6.0)forLinuxx86OracleDatabaseGateways11gRelease1(11.1.0.6.0)forLinuxx862.1.2ORACLE11G-ASMlib工具包：下载地址：系统补丁的下载下载地址：三系统安装配置3.1系统参数配置3.1.1关闭没必要的服务chkconfig--level35autofsoffchkconfig--level35acpidoffchkconfig–level35sendmailoffchkconfig–level35cups-config-daemonoffchkconfig–level35cpusoffchkconfig–level35xfsoffchkconfig–level35lm_sensorsoffchkconfig–levelgpmoffchkconfig–levelopenibdoffchkconfig–leveliiimoffchkconfig–levelpcmciaoffchkconfig–levelcpuspeedoffchkconfig–levelnfslockoffchkconfig–levelip6tablesoffchkconfig–levelrpcidmapdoffchkconfig–levelapmdoffchkconfig–levelsendmailoffchkconfig–levelarptables_jfoffchkconifg–levelmicrocode_ctloffchkconfig–levelrpcgssdoff3.1.2设置主机表vi/etc/hosts127.0.0.1localhost.localdomainlocalhostIPrac1IPracp1IPracv1IPrac2IPracp2IPracv23.1.3修改内核参数vi/etc/sysctl.confkernel.shmmax=536870912kernel.shmmni=4096kernel.shmall=2097152kernel.sem=25032000100128fs.file-max=65536net.ipv4.ip_local_port_range=102465000net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=4194304net.core.wmem_max=4194304kernel.panic=603.1.4设置oracle登录使用资源数vi/etc/security/limits.conforaclesoftnofile65536oraclehardnofile65536oraclesoftnproc16384oraclehardnproc16384vi/etc/pam.d/login–末行加入以下sessionrequiredpam_limits.somultipleopen3.1.5建立hangcheck模块加载检测是否安装了hangcheck模块[root@rac1]#find/lib/modules-namehangcheck-timer.ko/lib/modules/2.6.9-42.ELsmp/kernel/drivers/char/hangcheck-timer.ko设置模块为自动加载su–echooptionshangcheck-timerhangcheck_tick=30hangcheck_margin=180/etc/modprobe.conf或者echo/sbin/modprobehangcheck-timerhangcheck_tick=30hangcheck_margin=180/etc/rc.local检测模块是否运行su-modprobehangcheck-timergrepHangcheck/var/log/messages|tail-23.1.6禁用selinuxgetseboolgetsebool:SELinuxisdisabledvi/etc/selinux/configSELINUX=disabled3.1.7添加oracle用户和用户组mkdir–p/oracle/oraclegroupadd–g502dbagroupadd–g501oinstalluseradd–g501–G502–d/oracle/oracleoraclepasswdoraclechown-Roracle.oinstall/oracle/oracle3.1.8修改主机名vi/etc/sysconfig/networkHOSTNAME=rac1#hostnamerac1Rac2上同样执行3.2设置oracle用户vi.bash_profileumask022exportORACLE_BASE=/oracle/oracleexportORACLE_HOME=$ORACLE_BASE/product/10.2.0/dbexportORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crsexportORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin#exportORACLE_SID=rac2exportORACLE_SID=rac1exportNLS_LANG=AMERICAN_AMERICA.zhs16gbkexportNLS_DATE_FORMAT=YYYY-MM-DDHH24:MI:SSexportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportLD_ASSUME_KERNEL=2.4.19#forRHELAS4exportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativeexportTEMP=/tmpexportTMPDIR=/tmpif[$USER=oracle];thenif[$SHELL=/bin/ksh];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fifi3.3配置ASM服务3.3.1安装asm包rpm-Uvhoracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpmoracleasmlib-2.0.2-1.i386.rpmoracleasm-support-2.0.3-1.i386.rpm安装asm包一定要和系统的内核相对应3.3.2配置asm服务cd/etc/init.d/[root@localhostinit.d]#./oracleasmconfigureConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('[]').HittingENTERwithouttypingananswerwillkeepthatcurrentvalue.Ctrl-Cwillabort.Defaultusertoownthedriverinterface[]:oracleDefaultgrouptoownthedriverinterface[]:dbaStartOracleASMlibrarydriveronboot(y/n)[n]:yFixpermissionsofOracleASMdisksonboot(y/n)[y]:yWritingOracleASMlibrarydriverconfiguration:[OK]Creating/dev/oracleasmmountpoint:[OK]Loadingmoduleoracleasm:[OK]MountingASMlibdriverfilesystem:[OK]ScanningsystemforASMdisks:[OK]3.4建立ssh等效性（在oracle用户操作）3.4.1建立相关目录生成密钥和公钥su-oraclemkdir-p~/.sshchmod755~/