CentOS 7 oracle rac + nfs 部署

CentOS 7 oracle rac + nfs 部署
rac1，rac2 均需要配置
1.#################### hosts解析
echo “#publice ip
192.168.180.2 rac1
192.168.180.3 rac2
#private ip
10.10.10.2 rac1-priv
10.10.10.3 rac2-priv
#vip
192.168.180.4 rac1-vip
192.168.180.5 rac2-vip
#scan ip
192.168.180.6 rac-scan”>>/etc/hosts
2.######################新增用户，创建安装目录
groupadd -g 1000 oinstall
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1022 asmoper
groupadd -g 1031 dba
groupadd -g 1032 oper
useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
useradd -u 1101 -g oinstall -G dba,asmdba,oper oracle
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/grid
mkdir /u01/app/oracle
chown -R grid:oinstall /u01
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
3.#########################配置/etc/sysctl.conf
echo “kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 68719476736
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
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304”>>/etc/sysctl.conf
sysctl -p
4.#####################配置/etc/security/limits.conf
echo “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”>>/etc/security/limits.conf
5.####################
cat >> /etc/pam.d/login <<EOF

session required pam_limits.so
EOF
cat >>/etc/profile<<EOF
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
EOF
source /etc/profile

6 ##################配置grid环境变量
su - grid
echo “export TMP=/tmp
export TMPDIR=KaTeX parse error: Expected 'EOF', got '#' at position 30: …CLE_SID=+ASM1 #̲ RAC1 export OR…PATH
export PATH=$ORACL{E}_{H}OME/bin:$PATH
export LD_LIBRARY_PATH=$ORACL{E}_{H}OME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/JRE:$ORACL{E}_{H}OME/jlib:$ORACLE_HOME/rdbms/jlib
umask 022”>> .bash_profile
source .bash_profile
7######################配置oracle环境变量
su - oracle
echo “export TMP=/tmp
export TMPDIR=KaTeX parse error: Expected 'EOF', got '#' at position 30: …CLE_SID=orcl1 #̲ RAC1 export OR…ORACLE_BASE/product/11.2.0/db_1
export TNS_ADMIN=$ORACL{E}_{H}OME/network/adminexportPATH=/usr/sbin:$PATH
export PATH=$ORACL{E}_{H}OME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib”>>.bash_profile
source .bash_profile
8#############################oracle 双机互信 可以跳过
ssh-keygen -t rsa
ssh-keygen -t dsa
su - oracle
ssh rac1 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh rac2 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh rac1 cat ~/.ssh/id_dsa.pub >> authorized_keys
ssh rac2 cat ~/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys rac2:~/.ssh/
chmod 600 authorized_keys
ssh rac1 date
ssh rac2 date
ssh rac1-priv date
ssh rac2-priv date
9############################grid 双机互信可以跳过
sh-keygen -t rsa
ssh-keygen -t dsa
su - grid
ssh rac1 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh rac2 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh rac1 cat ~/.ssh/id_dsa.pub >> authorized_keys
ssh rac2 cat ~/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys rac2:~/.ssh/
chmod 600 authorized_keys
10##################挂载NFS服务器
showmount -e 192.168.1.222
mkdir -p /share
mount -t nfs 192.168.1.222:/share /share
df -h
echo “192.168.1.222:/share /share nfs defaults 0 0”>>/etc/fstab

##########################
11.########################### 仅需在一台rac服务器安装
unzip linux.x64_11gR2_grid.zip -d /home/grid/
unzip linux.x64_11gR2_database_1of2.zip -d /home/oracle/
unzip linux.x64_11gR2_database_2of2.zip -d /home/oracle/
chown -R grid:oinstall /home/grid
chown -R oracle:oinstall /home/oracle
###################install check
./runcluvfy.sh stage -pre crsinst -n rac1,rac2

12####################### install grid
su - grid
cd /home/grid/grid
export DISPLAY=192.168.1.14
xhost +
./runInstaller
13#########################可能需要配置resolve.conf
su - root
sh /u01/app/oraInventory/orainstRoot.sh
sh /u01/app/11.2.0/grid/root.sh
14#########################redhat7 需要
touch /usr/lib/systemd/system/ohas.service
chmod 777 /usr/lib/systemd/system/ohas.service
echo “[Unit]
Description=Oracle High Availability Services
After=syslog.target
[Service]
ExecStart=/etc/init.d/init.ohasd run >/dev/null 2>&1 Type=simple
Restart=always
[Install]
WantedBy=multi-user.target”>>/usr/lib/systemd/system/ohas.service
systemctl daemon-reload
systemctl enable ohas.service
systemctl start ohas.service
15####################### install oracle
su - oracle
cd /home/oracle /database
export DISPLAY=192.168.1.14
xhost +
./runInstaller
16#########################
Oracel Real Application Clusters database installation按钮（默认）
sh /u01/app/oracle/product/11.2.0/db_1/root.sh
su - oracle
dbca
crsctl check crs
crs_stat -t -v
17##################监听开机启动
vi oratab ，N改为Y
rpt:/u01/app/oracle/product/11.2.0.4/db_1:N
rpt:/u01/app/oracle/product/11.2.0.4/db_1:Y
vi rc.local 追加
su - oracle -c ‘lsnrctl start’
su - oracle -c ‘dbstart’
18########################
sqlplus / as sysdba
create user conan identified by conan;
grant create session,create tables,create view to conan;