RedHat 5.6 Linux环境下oracle11g RAC集群环境搭建 下载本文

多路径配置:

安装多路径所需rpm包:

rpm -ivh device-mapper-multipath-libs-0.4.9-64.el6.x86_64.rpm rpm -ivh device-mapper-multipath-0.4.9-64.el6.x86_64.rpm 执行命令:mpathconfig --enable 生成配置文件 vim /etc/sysconfig/multipath.conf

一、创建用户组和用户(两个节点)

/usr/sbin/groupadd -g 501 oinstall /usr/sbin/groupadd -g 502 dba /usr/sbin/groupadd -g 503 oper /usr/sbin/groupadd -g 504 asmadmin /usr/sbin/groupadd -g 505 asmoper /usr/sbin/groupadd -g 506 asmdba

/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle

/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

passwd oracle passwd grid

(创建完毕后id oracle/id grid查看创建用户id,两个节点id要一致)

二、创建目录(两个节点)

mkdir -p /u01/app/oraInventory

chown -R grid:oinstall /u01/app/oraInventory chmod -R 775 /u01/app/oraInventory mkdir -p /u01/11.2.0/grid

chown -R grid:oinstall /u01/11.2.0/grid mkdir -p /u01/app/grid

chown -R grid:oinstall /u01/app/grid chmod -R 775 /u01/app/grid mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/cfgtoollogs chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1 chmod -R 775 /u01/app/oracle/product/11.2.0/db_1 三、修改Hosts文件(两个节点)hostname查看主机名(/etc/sysconfig/network修改主机名)

vi /etc/hosts #Public ip

10.12.132.25 rac3 10.12.132.26 rac4 #Private ip

192.168.132.25 rac3-priv 192.168.132.26 rac4-priv #Virtual ip

10.12.132.27 rac3-vip 10.12.132.28 rac4-vip #Scan ip

10.12.132.29 rac-scan2

四、修改limits.conf 文件(两个节点)oracle连接数啥的 vi /etc/security/limits.conf #ORACLE SETTING

grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

五、添加pam_limits.so 模块(两个节点) vi /etc/pam.d/login #ORACLE SETTING

session required pam_limits.so

六、修改linux 内核参数(两个节点) vi /etc/sysctl.conf #ORACLE SETTING

fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 8388608 kernel.shmmax = 1288490188 kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586

执行sysctl -p

七、修改profile(两个节点)

vi /etc/profile #ORACLE SETTING

if [ $USER = \if [ $SHELL = %ulimit -p 16384 ulimit -n 65536 else

ulimit -u 16384 -n 65536 fi

umask 022 fi

八、停ntp 时间同步(11G 新增检查选项)(两个节点) /etc/init.d/ntpd stop chkconfig ntpd off

mv /etc/ntp.conf /etc/ntp.conf.org rm /etc/ntp.conf

九、查看tmpfs 大小是否大于1G(两个节点) df -h /dev/shm

Filesystem Size Used Avail Use% Mounted on tmpfs 16G 224M 16G 2% /dev/shm [root@cmsnmdb2 ~]#

十、磁盘划分(一个节点) +OCR_VOTE 三个1G 盘 +DATA 两个100G 盘 +ARCH 两个100G 盘

[root@cmsnmdb1 ~]# fdisk -l

Disk /dev/sda: 298.9 GB, 298999349248 bytes 255 heads, 63 sectors/track, 36351 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System /dev/sda1 * 1 13 104391 83 Linux

/dev/sda2 14 36351 291884985 8e Linux LVM Disk /dev/sdb: 858.9 GB, 858993459200 bytes 255 heads, 63 sectors/track, 104433 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table [root@cmsnmdb1 ~]# fdisk /dev/sdb

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous content won't be recoverable.

The number of cylinders for this disk is set to 104433.

There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with:

1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK)

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): n Command action e extended

p primary partition (1-4) p

Partition number (1-4): 1

First cylinder (1-104433, default 1): 1

Last cylinder or +size or +sizeM or +sizeK (1-104433, default 104433): +1024M Command (m for help): n Command action e extended

p primary partition (1-4) p

Partition number (1-4): 1

Partition 1 is already defined. Delete it before re-adding it. Command (m for help): n Command action e extended

p primary partition (1-4) p

Partition number (1-4): 2

First cylinder (126-104433, default 126): Using default value 126

Last cylinder or +size or +sizeM or +sizeK (126-104433, default 104433): +1024M Command (m for help): n