oracle 数据库相关搭建学习使用配置RAC文档

一、操作系统层面参数配置

1：关闭防火墙

service iptables stop

chkconfig iptables off

2：（选做）修改图形界面安装为中文

将字体文件 zysong.ttf 放在/usr/share/fonts/zh_CN/TrueType/下（手动创建/zh_CN/TrueType

目录）

将安装包及两个 RPM 的文件也拷入/gj/RHEL 下

3：修改 yum 源

enabled=1

gpgcheck=0

gpgkey=file:///gj/RHEL/RPM-GPG-KEY-redhat-release

[rhel-source-beta]

name=Red Hat Enterprise Linux $releasever Beta - $basearch - Source

baseurl=file:///gj/RHEL/

enabled=1

gpgcheck=0

gpgkey=file:///gj/RHEL/RPM-GPG-KEY-redhat-beta,file:///gj/RHEL/RPM-GPG-KEY-redhat-release

CentOS 配置本地 yum

#

# To use this repo, put in your DVD and use it with the other repos too:

# yum --enablerepo=c6-media [command]

#

# or for ONLY the media repo, do this:

#

# yum --disablerepo=\* --enablerepo=c6-media [command]

[c6-media]

name=CentOS-$releasever - Media

baseurl=file:///home/gj/

yum install tigervnc*

vncserver 输完后，要设置密码，需输入 2 遍

--加入 VNC 自启动

chkconfig vncserver on

5：优化最大连接数，防止 too many open files

vi /etc/security/limits.conf

--在文件末尾加上如下 2 行内容：（注意*也需要）

* soft nofile 65536

* hard nofile 65536

切记！！安装前必须需配置完成 yum 源！！！！！

#public

10.25.114.101 lzcgs1

10.25.114.102 lzcgs2

#private

192.168.114.101 lzcgs1-priv

10.25.114.103 lzcgs1-vip

#Scan

10.25.114.105 lzcgs-scan

7：格式化硬盘

fdisk -l 查看所有硬盘后将安装所需硬盘列出来

用下面的命令进行格式化

fdisk /dev/sddlmaa(硬盘名称) 回车

n

1

回车

w

########全部格式化完成需两台服务器都需要重启！！！！##########

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add", KERNEL=="sdd1", RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add", KERNEL=="sde1", RUN+="/bin/raw /dev/raw/raw4 %N"

ACTION=="add", KERNEL=="sdf1", RUN+="/bin/raw /dev/raw/raw5 %N"

ACTION=="add", KERNEL=="sdg1", RUN+="/bin/raw /dev/raw/raw6 %N"

ACTION=="add", KERNEL=="sdh1", RUN+="/bin/raw /dev/raw/raw7 %N"

ACTION=="add", KERNEL=="sdi1", RUN+="/bin/raw /dev/raw/raw8 %N"

ACTION=="add", KERNEL=="sdj1", RUN+="/bin/raw /dev/raw/raw9 %N"

ACTION=="add", KERNEL=="sdk1", RUN+="/bin/raw /dev/raw/raw10 %N"

ACTION=="add", KERNEL=="sdn1", RUN+="/bin/raw /dev/raw/raw13 %N"

ACTION=="add", KERNEL=="sdo1", RUN+="/bin/raw /dev/raw/raw14 %N"

ACTION=="add", KERNEL=="sdr1", RUN+="/bin/raw /dev/raw/raw17 %N"

ACTION=="add", KERNEL=="sds1", RUN+="/bin/raw /dev/raw/raw18 %N"

ACTION=="add", KERNEL=="sdt1", RUN+="/bin/raw /dev/raw/raw19 %N"

ACTION=="add", KERNEL=="sdu1", RUN+="/bin/raw /dev/raw/raw20 %N"

ACTION=="add", KERNEL=="sdv1", RUN+="/bin/raw /dev/raw/raw21 %N"

ACTION=="add", KERNEL=="sdw1", RUN+="/bin/raw /dev/raw/raw22 %N"

ACTION=="add", KERNEL=="sdx1", RUN+="/bin/raw /dev/raw/raw23 %N"

ACTION=="add", KERNEL=="sdy1", RUN+="/bin/raw /dev/raw/raw24 %N"

ACTION=="add", KERNEL=="sdz1", RUN+="/bin/raw /dev/raw/raw25 %N"

ACTION=="add", KERNEL=="sdaa1", RUN+="/bin/raw /dev/raw/raw26 %N"

ACTION=="add", KERNEL=="sdab1", RUN+="/bin/raw /dev/raw/raw27 %N"

ACTION=="add", KERNEL=="sdac1", RUN+="/bin/raw /dev/raw/raw28 %N"

ACTION=="add", KERNEL=="sdad1", RUN+="/bin/raw /dev/raw/raw29 %N"

groupadd -g 1000 oinstall

groupadd -g 1001 dba

groupadd -g 1002 oper

groupadd -g 1003 asmadmin

groupadd -g 1004 asmoper

groupadd -g 1005 asmdba

groupadd -g 1006 orauser

usermod -g oinstall -G dba,asmdba oracle

usermod -g oinstall -G dba,asmdba,oper,oinstall,asmadmin grid

passwd grid

11：两台服务器均创建目录

mkdir -p /u01/app/grid/

mkdir -p /u01/soft/grid/

mkdir -p /u01/app/oracle/

mkdir -p /u01/soft/oraInventory

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

12：两台服务器均设置目录所有者

chown -R oracle:oinstall /u01/app/oracle

chown -R grid:oinstall /u01/app/grid

chown -R grid:oinstall /u01/soft/oraInventory

chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1/

13：两台服务器均更改文件权限

chmod -R 775 /u01/

chmod -R 775 /u01/app/grid/

#for oracle

#kernel.shmall = 2097152

#kernel.shmmax = 4294967295

kernel.shmmni = 4096