当前位置:文档之家› Linux+Oracle10g+RAC

Linux+Oracle10g+RAC

RAC应用集群一.实施规划1.平台:操作系统:RedHat Enterprise Linux Advanced Server 5.0内存大小:2048M交换空间:2048M硬盘空间:10G网卡配置:2(public IP,Vitual IP ,Private IP)主机结点:2(node1,node2)存储设备:1 (DB fies)2.网络规划Node1 公共192.168.100.101Node2 公共192.168.100.102Node1-vip 虚拟192.168.100.201Node2-vip 虚拟192.168.100.202Node1-priv 专用19.168.100.101Node2-priv 专用19.168.100.1023.安装流程>安装虚拟机vmware Server 1.0.9>安装RHEL5.4>配置RHEL操作系统>复制第二台虚拟机>配置双机信任关系>建立ASM存储>安装clusterware软件>安装database软件>配置监听Listener>建立数据库实例二.新建虚拟机1.选择-》新建,虚拟机名为RAC1,location为F:\vmware\RAC1,网卡接口选择桥接网络方式(Use bridged networking),适配器选择LSI Logic,虚拟硬盘选择SCSI,硬盘容量选择10G,然后选择每次扩充扩充2G(Split disk into 2GB files),不选择立即分配。

然后按Add添加硬盘,先添加一个100M的硬盘,选择立即分配方式(Allocate all disk space now),该盘作为V otingDisk盘,目录存放位置为F:\vmware\sharedisk\V otingdisk,虚拟设备结点选择SCSI 1:1 Hard Disk2,模式选择一致即:independent->persistent。

然后再添加一个100M的硬盘,选择立即分配,该盘作为OCRdisk盘,目录存放位置为:F:\vmware\sharedisk\OCRdisk,硬盘选择SCSI 1:2,模式为一致。

再添加一个2G的硬盘用作ASM的数据文件的空间,选择立即分配和2G扩充一个文件,目录位置为F:\vmware\sharedisk\ASMdisk,硬盘选择SCSI 1:3,模式选择一致。

再添加一个 1.3G的硬盘用作ASM的闪回区,选择立即分配,目录位置为F:\vmware\sharedisk\ASMdisk2,硬盘选择SCSI 1:4,模式选择一致性。

再添加一块网卡,用作两台虚拟机之间的通信,连接方式选择Host-only模式并选择(connect at power on)。

2. 开启该虚拟机,安装RHEL 5.4,注意事项:交换分区分2G,主机名为node1,eth0为192.168.100.101,eth1为19.168.100.101 作为node1-priv,自定义安装包时,选择开发、服务器以及基本系统的全部,防火墙关闭,selinux 设为enabled禁用。

安装好之后,编辑F:\vmware\RAC1\Red Hat Linux.vmx,添加如下一段(可以使那四个磁盘真正的作为共享盘):disk.locking = “false”disklib.dataCacheMaxSize = “0”disklib.dataCacheMaxReadAheadSize = “0”disklib.dataCacheMinReadAheadSize = “0”disklib.dataCachePageSize = “4096”disklib.maxUnsyncedWrites = “0”scsi1:1.deviceType = “disk”scsi1:2.deviceType = “disk”scsi1:3.deviceType = “disk”scsi1:4.deviceType = “disk”4.RHEL系统配置#uname –r2.6.128-164.el5#vim /etc/hosts(加上如下一段)192.168.100.101 node1192.168.100.102 node2192.168.100.201 node1-vip192.168.100.202 node2-vip19.168.100.101 node1-priv19.168.100.102 node2-priv#vim /etc/sysctl.conf(加上如下一段)Kernel.shmall = 2097152Kernel.shmmax = 536870912Kernel.shmmni = 4096Kernel.sem = 250 32000 100 128Fs.file-max = 65536Net.ipv4.ip_local_port_range = 1024 65000Net.core.rmem_default = 1048576Net.core.rmem_max = 1048576Net.core.wmem_default = 262144Net.core.wmem_max = 262144#sysctl –p (是该文件生效)#vim /etc/security/limits.conf(加上如下一段)Oracle soft nproc 2047Oracle hard nproc 16384Oracle soft nofile 1024Oracle hard nofile 65536#vim /etc/pam.d/login(加上如下一段)Session required /lib/security/pam_limits.so#vim /etc/rc.loal (挂起检测时间定时器,检测对方有没有宕机)Modprobe hangcheck-timer hangcheck-tick=30 hangcheck_margin=20#groupadd oinstall#groupadd dba#useradd –m –g oinstall –G dba#passwd oracle#vim /home/oracle/.bash_profileExport TMPDIR=/tmpExport ORACLE_BASE=/u01/app/oracleExport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1Export ORACLE_SID=RACDB1Export ORACLE_TERM=xtermExport PATH=$ORACLE_HOME/bin:/usr/bin:$PATHExport LD_LIBRARY_PA TH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ExportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Ulimit –u 16384 –n 65536Umask 022#mkdir –p /u01/app/oracle#chown –R oracle:oinstall /u01#chmod –R 775 /u01#fdisk /dev/sdb#fdisk /dev/sdc#fdisk /dev/sdd#fdisk /dev/sde#partprobe#rpm –ivh oracleasm-support-*#rpm –ivh oracleasm-2.6.18-164.el5.*#rpm –ivh oracleasmlib*#rpm –ivh compat-gcc-7.3.2-2.96.128.i386.rpm#rpm –Uvh compat-libstdc++-7* --force#rpm –ivh compat-libstdc---devel-7.3.2#rpm –ivh compat-gcc-c++*#service oracleasm configureOracleOinstallYY#vim /etc/udev/rules.d/60-raw.rules(加上如下一段)ACTION==”add”,KERNEL==”/dev/sdb1”,RUN+=”/bin/raw /dev/raw1 %N”ACTION==”add”,ENV{MAJOR}==”8”,ENV{MINOR}==”17”,RUN+=”/bin/raw/dev/raw/raw1 %M %m” ( 其中的主设备号可以通过ls –l /dev/sd*查看)ACTION==”add”,KERNEL==”/dev/sdc1”,RUN+=”/bin/raw /dev/raw2 %N”ACTION==”add”,ENV{MAJOR}==”8”,ENV{MINOR}==”33”,RUN+=”/bin/raw/dev/raw/raw2 %M %m”KERNEL==”raw[1-2]”,OWNER=”oracle”,GROUP=”oinstall”,MODE=”640”#start_udev#ls –l /dev/raw/*#shutdown –h now三.复制出第二台虚拟机1.将复制之后的名称为RAC1的改为RAC2,另外编辑Red Hat Linux.vmx查找文件中的RAC1将它改为RAC2,然后编辑RAC2.vmdk将文件中的RAC1改为RAC2(如下所示): RW 4192256 SPARSE “RAC2-s001.vmdk”RW 4192256 SPARSE “RAC2-s002.vmdk”RW 4192256 SPARSE “RAC2-s003.vmdk”RW 4192256 SPARSE “RAC2-s004.vmdk”RW 4192256 SPARSE “RAC2-s005.vmdk”RW 10240 SPARSE “RAC2-s006.vmdk”2.打开RAC2,选择Create3.配置node2操作系统#hostname node2#vim /etc/sysconfig/networkHOSTNAME=node2#vim /etc/hosts127.0.0.1 node2 localhost.localdomain localhost#cd /etc/sysconfig/network-scripts/#cat ifcfg-eth0.bak#cat ifcfg-eth0#cat ifcfg-eth1.bak#cat ifcfg-eth1#mv ifcfg-eth0.bak ifcfg-eth0#mv ifcfg-eth1.bak ifcfg-eth1#ifconfig eth0 | grep HWaddr#cat ifcfg-eth0 | grep ADDR#ifconfig eth1 | grep Hwaddr#cat ifcfg-eth1 | grep ADDR#cat /home/oracle/.bash_profile | grep ORACLE_SIDExport ORACLE_SID=RACDB2#ping node1#ping node2#ping node1-priv#ping node2-priv4.时间同步Node2]# ssh node1Node1]# service xinetd startNode1]# chkconfig time-stream onNode1]# chkconfig xinetd onNode1]# chkconfig ntpd onNode1]#service ntpd restartNode1]#exitNode2]#crontab –e0-59/1 * * * * rdate –s 192.168.100.1010-59/1 * * * * ntpdate 192.168.100.101Node2]# > /etc/resolv.confNode2]# ssh node1Node1]# > /etc/resolv.conf四.配置双机信任关系Node1]#su – oracleNode1]$ mkdir .sshNode1]$ chmod 700 .sshNode1]$ ssh-keygen –t rsaNode1]$ ssh-keygen -t dsaNode2]#su – oracleNode2]$mkdir .sshNode2]$chmod 700 .sshNode2]$ssh-keygen -t rsaNode2]$ssh-keygen -t dsaNode1]$ cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keysNode1]$ cat /home/oracle/.ssh/id_dsa.pub >> /home/oracle/.ssh/authorized_keysNode1]$ssh node2 cat /home/oracle/.ssh/id_rsa.pub >> /home/oracle/.ssh/authorized_keys Node1]$ssh node2 cat /home/oracle/.ssh/id_dsa.pub >> /home/oracle/.ssh/authorized_keys Node1]$ scp /home/oracle/.ssh/authorized_keys node2:/home/oracle/.ssh/authorized_keys五.配置ASMNode1]#service oracleasm configureNode1]#service oracleasm createdisk vol1 /dev/sdd1Node1]#service oracleasm createdisk vol2 /dev/sde1Node1]#service oracleasm scandisksNode1]#service oracleasm listdisksNode1]#ssh node2Node2]#service oracleasm scandisksNode2]#service oracleasm listdisksNode2]#exitNode1]#cd /oradiskNode1]#unzip oracle10g01_cluster*****Node1]#chown –R oracle:oinstall /oradiskNode1]#chmod –R 775 /oradisk然后注销以oracle登录Node1]$cd /oradisk/clusterware/cluvfyNode1]$./runcluvfy.sh stage –pre crsinst -n node1.node2 -verboseNode1]$export LANG=en_USNode1]$/oradisk/clusterware/runInstaller -ignoreSysPreReqs这里注意1.安装路径为/u01/app/oracle/product/10.2.0/crs_12.Specify Cluster Configuration 中添加上node2的信息3.Specify Network Interface Usage中检查一下eth0和eth1的接口类型有没有反,应该eth0为public,eth1为private。

相关主题