OEL6.3安装11gRAC

最新推荐文章于 2025-09-10 22:21:01 发布

原创最新推荐文章于 2025-09-10 22:21:01 发布 · 101 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #运维 #操作系统

linux版本：OEL6.3 Oracle版本：11.2.0.3 虚拟机：VBOX

学RAC买书千万不要买刘炳林的RAC，垃圾中的战斗机还如此贵~~还是大话RAC经典。

一、操作系统设置

1.# cat /etc/hosts   配置/etc/hosts  网络
192.168.1.181   vmac1   vmac1.oracle.com
192.168.1.182   vmac1-vip
192.168.1.183   vmac2   vmac2.oracle.com
192.168.1.184   vmac2-vip
192.168.1.186   vmac-cluster vmac-cluster-scan
172.168.1.18   vmac1-priv
172.168.1.19   vmac2-priv
2.关闭NTP，检查防火墙及SELINUX是否关闭。
[root@bysrac1 ~]# servicentpd status
ntpd is stopped
[root@bysrac1 ~]# chkconfig ntpd off
[root@bysrac1 ~]# service iptables status
Firewall is stopped.
[root@bysrac1 ~]# getenforce
Disabled
3.修改SSH解决超时自动断开问题
[root@oel-01 ~]# cd /etc/ssh/
[root@oel-01 ssh]# grep "ClientAlive" sshd_config
#ClientAliveInterval 0
#ClientAliveCountMax 3
[root@oel-01 ssh]# cp sshd_config sshd_config.bak
[root@oel-01 ssh]# sed -i "s/#ClientAliveInterval 0/ClientAliveInterval 60/g" sshd_config
[root@oel-01 ssh]# grep "ClientAlive" sshd_config
ClientAliveInterval 60
#ClientAliveCountMax 3
[root@oel-01 ssh]# sed -i "s/#ClientAliveCountMax 3/ClientAliveCountMax 10/g" sshd_config
[root@oel-01 ssh]# grep "ClientAlive" sshd_config
ClientAliveInterval 60
ClientAliveCountMax 10
4. 创建用户和组
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -g oinstall -G dba,asmdba              oracle
passwd oracle
passwd grid
mkdir /s01
mkdir /g01
chown oracle:oinstall /s01
chown grid:oinstall   /g01
5.挂载光盘
df
mount /dev/cdrom /mnt/cdrom
or
mount -o loop /mnt/raid/oracle linux 6.4.iso /mnt/cdrom
[root@vmac6 ~]# cd /etc/yum.repos.d
[root@vmac6 yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak
[root@vmac6 yum.repos.d]# touch public-yum-ol6.repo
[root@vmac6 yum.repos.d]# vi public-yum-ol6.repo   
[base]
name=iso
baseurl=file:///mnt/cdrom
gpgcheck=1
enabled=1
gpgkey=file:///mnt/cdrom/RPM-GPG-KEY-oracle
[root@vmac1 ~]# yum install oracle-rdbms-server-11gR2-preinstall-1.0-6.el6
6.上一步执行完，oracle的限制参数默认已经生成，需要额外添加grid用户的参数
[root@bysrac1 ~]# cat /etc/security/limits.conf
# grid-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
grid   soft   nofile    1024
# grid-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
grid   hard   nofile    65536
# grid-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
grid   soft   nproc    2047
# grid-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
grid   hard   nproc    16384
# grid-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
grid   soft   stack    10240
# grid-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB
grid   hard   stack    32768
7.安装rlwrap软件
[root@bysrac2 Server]# yum install readline-devel-5.1-3.el5.i386.rpm
[root@bysrac2 ~]# cd /home/oracle
[root@bysrac2 oracle]# ls
oradiag_oracle  rlwrap-0.37.tar.gz
[root@bysrac2 oracle]# tar -zxvf rlwrap-0.37.tar.gz
[root@bysrac2 oracle]# cd rlwrap-0.37
[root@bysrac2 rlwrap-0.37]# ./configure
[root@bysrac2 rlwrap-0.37]# make
[root@bysrac2 rlwrap-0.37]# make install
8.检查配置：
[root@bysrac1 ~]# su - grid
[grid@bysrac1 ~]$ ulimit -a
core file size          (blocks, -c) 0
dataseg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 14123
max locked memory       (kbytes, -l) 3500000
max memory size         (kbytes, -m) unlimited
open files                      (-n) 131072
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 131072
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[root@bysrac1 ~]# su - oracle
[oracle@bysrac1 ~]$ ulimit -a
core file size          (blocks, -c) 0
dataseg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 14123
max locked memory       (kbytes, -l) 3500000
max memory size         (kbytes, -m) unlimited
open files                      (-n) 131072
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 131072
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
9.重启计算机

二、环境变量设定

6.配置grid 用户profile
mkdir /g01/orabase
                                                                                       
第一个节点：
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:
$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM1
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
                                                                                       
第二个节点：
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:
$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
7.root用户的环境变量
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:
$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
8.oracle用户的环境变量
mkdir /s01/orabase
第一个节点
export ORACLE_HOME=/s01/oracle/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:
$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=PROD1
export ORACLE_UNQNAME=PROD1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8
                                                                                       
第二个节点
                                                                                       
export ORACLE_HOME=/s01/oracle/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:
$ORACLE_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=PROD2
export ORACLE_UNQNAME=PROD2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORACLE_BASE=/s01/orabase
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="Simplified Chinese"_China.AL32UTF8

http://www.oracle.com/technetwork/server-storage/linux/asmlib/index-101839.html?ssSourceSiteId=ocomen

http://www.oracle.com/technetwork/cn/articles/hunter-rac11gr2-iscsi-083834-zhs.html