rhel6.5 oracle RAC 2节点

yum groupinstall "X Window System" -y
yum groupinstall "KDE Desktop" -y
yum groupinstall "Desktop" -y
yum groupinstall "Desktop Debugging and Performance Tools" -y
yum groupinstall "Desktop Platform Development" -y

########1.3.2设置ip地址###########################
vi  /etc/sysconfig/network-scripts/ifcfg-eth0
vi  /etc/sysconfig/network-scripts/ifcfg-eth1
vi /etc/sysconfig/network
    GATEWAY=10.10.10.254

################################################
vi /etc/hosts

10.10.10.2    racdb1
10.10.10.4    racdb1-vip
172.10.10.10    racdb1-priv

10.10.10.3    racdb2
10.10.10.5    racdb2-vip
172.10.10.20    racdb2-priv

10.10.10.6    pgisdb-scan
###############################################
#######禁用防火墙和SELNUX(所有节点)##########
service iptables stop
chkconfig iptables off

service ip6tables stop
chkconfig ip6tables off

vi /etc/selinux/config

###############################################
#######1.7检查软件需求#########################
yum install -y binutils*
yum install -y compat-libstdc++*
yum install -y compat-libcap*
yum install -y elfutils*
yum install -y gcc*
yum install -y glibc*
yum install -y ksh*
yum install -y libaio*
yum install -y libgcc*
yum install -y libstdc++*
yum install -y make*
yum install -y sysstat*
yum install -y unixODBC*
yum install -y libaio-devel*

##############################################
#######2.1 修改/etc/security/limits.conf######

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
##############################################
#########2.2修改/etc/pam.d/login##############

vi /etc/pam.d/login
#for oracle 
session required pam_limits.so

#############################################
########2.3 shell 的限制#####################

vi /etc/profile
**************
#for oracle 
if [ /$USER = "oracle" ] || [ /$USER = "grid" ]; then
if [ /$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
**************
sysctl -p

#############################################
#########2.4修改sysctl参数###################
vi /etc/sysctl.conf
***********************
#for oracle 
kernel.shamall = 2097152
kernel.shmmax = 64424509440
kernel.sem = 250 32000 100 128 
kernel.shmmni = 4096 
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
fs.aio-max-nr = 1048576
************************
##############################################
######2.5 停止NTP配置#########################
/sbin/service ntpd stop
chkconfig ntpd off
mv /etc/ntp.conf  /etc/ntp.conf.org.
crsctl check ctss
##############################################
######3raw设置#################################
fdisk -l
vi /etc/udev/rules.d/99-oracle-asmdevice.rules
**********************************************
#1T
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx226121894780c650", NAME="DATA1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx26c60b055dde4be4", NAME="DATA2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx4751c31a426c6273", NAME="DATA3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx6cb37bcd376cbe99", NAME="DATA4", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx39429b875746b297", NAME="DATA5", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx18e030916355be8f", NAME="DATA6", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx6d16368e6d7423a8", NAME="DATA7", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx1554caea11ef40f2", NAME="DATA8", OWNER="grid", GROUP="asmadmin", MODE="0660"

#2G
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx6c3006d837ba258b", NAME="OCRVT1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx5b774a5e7c319ab5", NAME="OCRVT2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx180244c842fa9471", NAME="OCRVT3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx32da637771368229", NAME="OCRVT4", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx32689636413e8a1e", NAME="OCRVT5", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx76f5919b7d89d266", NAME="OCRVT6", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx1896a4527883fcc7", NAME="OCRVT7", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="34edx309d8c3c56cf9824", NAME="OCRVT8", OWNER="grid", GROUP="asmadmin", MODE="0660"

**********************************************
##############################################
#######4创建用户及配置环境变量################
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 505 asmoper
groupadd -g 506 asmdba
useradd -g oinstall -G dba,asmdba,oper oracle
useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

passwd oracle
passwd grid

*************************************
mkdir -p /oracle
chown -R oracle:oinstall /oracle
chown oracle:oinstall /oracle
chmod -R 775 /oracle

#oracle主目录
mkdir -p /oracle/11.2.0.4/grid
mkdir -p /oracle/11.2.0.4/oracle
    
#oracle根目录
mkdir -p /oracle/grid
mkdir -p /oracle/oracle        

mkdir -p /oracle/cfgtoollogs 

#oracle日志目录
mkdir -p /oracle/oraInventory    
chown -R grid:oinstall /oracle/oraInventory    
chmod -R 775 /oracle/oraInventory    

chown -R grid:oinstall /oracle/11.2.0.4/grid
chown -R oracle:oinstall /oracle/11.2.0.4/oracle
chmod -R 775 /oracle/11.2.0.4/grid
chmod -R 775 /oracle/11.2.0.4/oracle
chown -R grid:oinstall /oracle/grid/
chown -R oracle:oinstall /oracle/oracle/
chmod -R 755 /oracle/grid/
chmod -R 755 /oracle/oracle
###############################
节点1:
su - grid
vi .bash_profile
---------------------------------
#for oracle 
export ORACLE_SID=+ASM1
export ORACLE_BASE=/oracle/grid
export ORACLE_HOME=/oracle/11.2.0.4/grid
export GRID_BASE=/oracle/grid
export GRID_HOME=/oracle/11.2.0.4/grid
export PATH=$GRID_HOME/bin:$PATH:/usr/local/bin/:.
export LD_LIBRARY_PATH=$GRID_HOME/lib:/lib:/usr/lib
#export DISPLAY=:0.0 
umask=022 

export PATH
----------------------------------
source .bash_profile   #使环境生效
echo $GRID_HOME   #检查环境是否生效

节点2:
su - grid
vi .bash_profile
----------------------------------
#for oracle 
export ORACLE_SID=+ASM2
export ORACLE_BASE=/oracle/grid
export ORACLE_HOME=/oracle/11.2.0.4/grid
export GRID_BASE=/oracle/grid
export GRID_HOME=/oracle/11.2.0.4/grid
export PATH=$GRID_HOME/bin:$PATH:/usr/local/bin/:.
export LD_LIBRARY_PATH=$GRID_HOME/lib:/lib:/usr/lib
#export DISPLAY=:0.0 
umask=022 

export PATH
-----------------------------------
source .bash_profile   #使环境生效
echo $GRID_HOME   检查环境是否生效
#########################################
编辑oracle用户环境

节点1: 
su - oracle
vi .bash_profile
----------------------------------
#for oracle 
export ORACLE_SID=racdb1
export ORACLE_UNQNAME=racdb;
export ORACLE_BASE=/oracle/oracle
export ORACLE_HOME=/oracle/11.2.0.4/oracle

export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export NLS_LANG=american_america.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS11=$ORACLE_HOME/nls/data

export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/oracm/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 
#export DISPLAY=:0.0 
umask=022 
------------------------------------
source .bash_profile   #使环境生效

节点2:
su - oracle
vi .bash_profile
------------------------------------
#for oracle 
export ORACLE_SID=racdb2
export ORACLE_UNQNAME=racdb
export ORACLE_BASE=/oracle/oracle
export ORACLE_HOME=/oracle/11.2.0.4/oracle

export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export NLS_LANG=american_america.ZHS16GBK
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS11=$ORACLE_HOME/nls/data

export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/oracm/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 
#export DISPLAY=:0.0 
umask=022 
---------------------------------------
source .bash_profile   #使环境生效
######################################################
######################################################
su - grid
mkdir ~/.ssh
chmod 755 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa

在一个节点1 上
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

在传到另一个节点
scp ~/.ssh/authorized_keys racdb2:~/.ssh/authorized_keys

在一个节点2 上
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

在传到另一个节点
scp ~/.ssh/authorized_keys racdb1:~/.ssh/authorized_keys

验证等效性
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add
ssh racdb1 date 
ssh racdb2 date
ssh racdb1-priv date
ssh racdb2-priv date

################################################
su - oracle
mkdir ~/.ssh
chmod 755 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
在一个节点1 上
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
在传到另一个节点
scp ~/.ssh/authorized_keys racdb2:~/.ssh/authorized_keys
在一个节点2 上
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
在传到另一个节点
scp ~/.ssh/authorized_keys racdb1:~/.ssh/authorized_keys
验证等效性
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add
ssh racdb1 date
ssh racdb2 date
ssh racdb1-priv date
ssh racdb2-priv date

####################################################

date -s 12:39:30

rpm -Uvh cvuqdisk-1.0.9-1.rpm

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

末点

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值