ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > oracle单实例、RAC集群——安装前期环境配置脚本

oracle单实例、RAC集群——安装前期环境配置脚本

原创 Oracle 作者：彩伦 时间：2016-05-10 17:20:21 0 删除 编辑

1.oracle_sigle 单实例前期环境配置

#!/bin/bash

#1.关闭防火墙

service iptables stop

service ip6tables stop

chkconfig iptables off

chkconfig ip6tables off

 

#2.创建oracle用户组

groupadd -g 1000 oinstall

groupadd -g 1001 dba

groupadd -g 1002 oper

useradd -u 1000 -g oinstall -G dba,oper oracle

 

#3.设置oracle密码

echo "111111" |passwd --stdin oracle

 

#4.创建oracle安装目录

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 

#6.设置node1 oracle环境变量

echo "

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1

export TNS_ADMIN=\$ORACLE_HOME/network/admin

export ORACLE_HOSTNAME=node1.test.com

export ORACLE_UNQNAME=orcl

export PATH=\$PATH:\$ORACLE_HOME/bin

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

export EDITOR=vi

export LANG=C

umask 022

" >> ~oracle/.bash_profile

 

echo "

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

" >> ~oracle/.bashrc

 

#7.配置limits资源限制

echo "

oracle                soft                     nofile                  1024

oracle                hard          nofile                  65536

oracle                soft                     nproc                 2047

oracle                hard          nproc                 16384

oracle                soft                     stack                  10240

oracle                hard          stack                  32768

" >> /etc/security/limits.conf

 

#8.配置内核参数

echo "

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 1052045312

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 = 1048576

" >> /etc/sysctl.conf

 

sysctl -p

 

#9.添加hosts文件

echo "

#node1

192.168.0.1               node1.test.com                 node1      

" >> /etc/hosts

 

#10.yum安装包

yum -y install binutils compat-libcap1 compat-libstdc++-33.i686 compat-libstdc++-33 gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel libaio.i686 libaio libaio-devel.i686 libaio-devel make sysstat elfutils-libelf-devel bind

 

#11.关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

 

#12.修改tmpfs

sed -i '/tmpfs/d' /etc/fstab

echo "tmpfs                     /dev/shm                tmpfs   defaults,size=2G        0  0" >>/etc/fstab

mount -o remount /dev/shm

 

#13.配置IP地址 node1

#echo "DEVICE=eth0

#ONBOOT=yes

#BOOTPROTO=static

#IPADDR=192.168.0.1

#NETMASK=255.255.255.0

#GATEWAY=192.168.0.254

#DNS1=192.168.0.1

#DNS2=192.168.0.2

#" > /etc/sysconfig/network-scripts/ifcfg-eth0

 

#14.重启网络

#service network restart

 

2.oracle_RAC1 集群环境配置

#!/bin/bash

#1.关闭防火墙

service iptables stop

service ip6tables stop

chkconfig iptables off

chkconfig ip6tables off

#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 1000 -g oinstall -G asmadmin,asmdba,asmoper grid

useradd -u 1001 -g oinstall -G dba,oper,asmdba oracle

#3.设置用户密码

echo "111111" |passwd --stdin grid

echo "111111" |passwd --stdin oracle

#4.创建所需目录

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2.0/grid

mkdir -p /u01/app/oracle

chown -R grid:oinstall /u01

chown oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

#5.配置node1 grid环境变量

echo "

export ORACLE_SID=+ASM1                      #node2上改为+ASM2

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2.0/grid

export TNS_ADMIN=\$ORACLE_HOME/network/admin

export PATH=\$PATH:\$ORACLE_HOME/bin

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

export EDITOR=vi

export LANG=C

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

umask 022

" >> ~grid/.bash_profile

 

echo "

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

" >> ~grid/.bashrc

 

#6.配置node1 oracle环境变量

echo "

export ORACLE_SID=orcl1    #node1  node2

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1

export TNS_ADMIN=\$ORACLE_HOME/network/admin

export ORACLE_HOSTNAME=node1.test.com                 #node1       node2

export ORACLE_UNQNAME=orcl

export PATH=\$PATH:\$ORACLE_HOME/bin

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

export EDITOR=vi

export LANG=C

umask 022

" >> ~oracle/.bash_profile

 

echo "

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

" >> ~oracle/.bashrc

 

#7.配置limits资源限制

echo "

grid           soft           nofile                  1024

grid           hard          nofile                  65536

grid           soft           nproc                 2047

grid           hard          nproc                 16384

grid           soft           stack                  10240

grid           hard    stack                  32768

 

oracle                soft           nofile                  1024

oracle                hard          nofile                  65536

oracle                soft           nproc                 2047

oracle                hard          nproc                 16384

oracle                soft           stack                  10240

oracle                hard          stack                  32768

" >> /etc/security/limits.conf

 

#8.配置内核参数

echo "

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 1052045312

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 = 1048576

" >> /etc/sysctl.conf

 

sysctl -p

 

#9.添加hosts文件

echo "

#node1

192.168.0.1               node1.test.com                 node1                #public ip

192.168.1.1               node1-priv.test.com         node1-priv        #private ip

192.168.0.11            node1-vip.test.com          node1-vip          #node1 vip

#node2

192.168.0.2               node2.test.com                 node2                #public ip

192.168.1.2               node2-priv.test.com         node2-priv        #private ip

192.168.0.12            node2-vip.test.com          node2-vip          #node2 vip

" >> /etc/hosts

 

#10.yum安装包

yum -y install binutils compat-libcap1 compat-libstdc++-33.i686 compat-libstdc++-33 gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel libaio.i686 libaio libaio-devel.i686 libaio-devel make sysstat elfutils-libelf-devel bind

 

#11.关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

 

#12.修改tmpfs

sed -i '/tmpfs/d' /etc/fstab

echo "tmpfs                     /dev/shm                tmpfs   defaults,size=2G        0  0" >>/etc/fstab

mount -o remount /dev/shm

 

#13.配置IP地址 node1

#echo "DEVICE=eth0

#ONBOOT=yes

#BOOTPROTO=static

#IPADDR=192.168.0.1

#NETMASK=255.255.255.0

#GATEWAY=192.168.0.254

#DNS1=192.168.0.1

#DNS2=192.168.0.2

#" > /etc/sysconfig/network-scripts/ifcfg-eth0

#echo "DEVICE=eth1

#ONBOOT=yes

#BOOTPROTO=static

#IPADDR=192.168.1.1

#NETMASK=255.255.255.0

#" > /etc/sysconfig/network-scripts/ifcfg-eth1

 

#14.配置bind

sed -i 's/127.0.0.1/any/' /etc/named.conf

sed -i 's/::1/any/' /etc/named.conf

sed -i 's/localhost;/any;/' /etc/named.conf

sed -i 's/dnssec-enable yes/dnssec-enable no/' /etc/named.conf

sed -i 's/dnssec-validation yes/dnssec-validation no/' /etc/named.conf

 

echo "

zone \"test.com\" IN {

        type master;

        file \"test.com.hosts\";

};

zone \"0.168.192.in-addr.arpa\" IN {

        type master;

        file \"192.168.0.rev\";

};

" >> /etc/named.rfc1912.zones

 

echo "\$TTL 1D

@               IN      SOA node1.test.com. root.node1.test.com.(

                          2015111001

                          3h

                          1h

                          1w

                          1h )

                IN      NS      node1.test.com.

node1           IN      A       192.168.0.1

node2           IN      A       192.168.0.2

scan            IN      A       192.168.0.101

scan            IN      A       192.168.0.102

scan            IN      A       192.168.0.103

" > /var/named/test.com.hosts

 

echo "\$TTL 1D

@               IN      SOA node1.test.com. root.node1.test.com.(

                          1

                          3h

                          1h

                          1w

                          1h )

                IN      NS      node1.test.com.

1               IN      PTR     node1.test.com.

2               IN      PTR     node2.test.com.

101             IN      PTR     scan.test.com.

102             IN      PTR     scan.test.com.

103             IN      PTR     scan.test.com.

" > /var/named/192.168.0.rev

 

service network restart

service named restart

chkconfig --level 35 named on

 

service ntpd stop

chkconfig ntpd off

mv /etc/ntp.conf /etc/ntp.conf.bak

 

3.oracle_RAC1 集群环境配置

#!/bin/bash

 

#1.关闭防火墙

service iptables stop

service ip6tables stop

chkconfig iptables off

chkconfig ip6tables off

#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 1000 -g oinstall -G asmadmin,asmdba,asmoper grid

useradd -u 1001 -g oinstall -G dba,oper,asmdba oracle

#3.设置用户密码

echo "111111" |passwd --stdin grid

echo "111111" |passwd --stdin oracle

#4.创建所需目录

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2.0/grid

mkdir -p /u01/app/oracle

chown -R grid:oinstall /u01

chown oracle:oinstall /u01/app/oracle

chmod -R 775 /u01

#5.配置node2 grid环境变量

echo "

export ORACLE_SID=+ASM2                      #node1上改为+ASM1

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2.0/grid

export TNS_ADMIN=\$ORACLE_HOME/network/admin

export PATH=\$PATH:\$ORACLE_HOME/bin

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

export EDITOR=vi

export LANG=C

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

umask 022

" >> ~grid/.bash_profile

 

echo "

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

" >> ~grid/.bashrc

 

#6.配置node2 oracle环境变量

echo "

export ORACLE_SID=orcl2    #node1  node2

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1

export TNS_ADMIN=\$ORACLE_HOME/network/admin

export ORACLE_HOSTNAME=node2.test.com                 #node1       node2

export ORACLE_UNQNAME=orcl

export PATH=\$PATH:\$ORACLE_HOME/bin

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

export NLS_LANG=american_america.AL32UTF8

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

export EDITOR=vi

export LANG=C

umask 022

" >> ~oracle/.bash_profile

 

echo "

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

" >> ~oracle/.bashrc

 

#7.配置limits资源限制

echo "

grid           soft           nofile                  1024

grid           hard          nofile                  65536

grid           soft           nproc                 2047

grid           hard          nproc                 16384

grid           soft           stack                  10240

grid           hard    stack                  32768

 

oracle                soft           nofile                  1024

oracle                hard          nofile                  65536

oracle                soft           nproc                 2047

oracle                hard          nproc                 16384

oracle                soft           stack                  10240

oracle                hard          stack                  32768

" >> /etc/security/limits.conf

 

#8.配置内核参数

echo "

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 1052045312

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 = 1048576

" >> /etc/sysctl.conf

 

sysctl -p

 

#9.添加hosts文件

echo "

#node1

192.168.0.1               node1.test.com                 node1                #public ip

192.168.1.1               node1-priv.test.com         node1-priv        #private ip

192.168.0.11            node1-vip.test.com          node1-vip          #node1 vip

#node2

192.168.0.2               node2.test.com                 node2                #public ip

192.168.1.2               node2-priv.test.com         node2-priv        #private ip

192.168.0.12            node2-vip.test.com          node2-vip          #node2 vip

" >> /etc/hosts

 

#10.yum安装包

yum -y install binutils compat-libcap1 compat-libstdc++-33.i686 compat-libstdc++-33 gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel libaio.i686 libaio libaio-devel.i686 libaio-devel make sysstat elfutils-libelf-devel bind

 

#11.关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

 

#12.修改tmpfs

sed -i '/tmpfs/d' /etc/fstab

echo "tmpfs                     /dev/shm                tmpfs   defaults,size=2G        0  0" >>/etc/fstab

mount -o remount /dev/shm

 

#13.配置IP地址 node2

#echo "DEVICE=eth0

#ONBOOT=yes

#BOOTPROTO=static

#IPADDR=192.168.0.2

#NETMASK=255.255.255.0

#GATEWAY=192.168.0.254

#DNS1=192.168.0.1

#DNS2=192.168.0.2

#" > /etc/sysconfig/network-scripts/ifcfg-eth0

#echo "DEVICE=eth1

#ONBOOT=yes

#BOOTPROTO=static

#IPADDR=192.168.1.2

#NETMASK=255.255.255.0

#" > /etc/sysconfig/network-scripts/ifcfg-eth1

 

#14.配置bind

sed -i 's/127.0.0.1/any/' /etc/named.conf

sed -i 's/::1/any/' /etc/named.conf

sed -i 's/localhost;/any;/' /etc/named.conf

sed -i 's/dnssec-enable yes/dnssec-enable no/' /etc/named.conf

sed -i 's/dnssec-validation yes/dnssec-validation no/' /etc/named.conf

 

echo "

zone \"test.com\" IN {

        type slave;

        file \"slaves/test.com.hosts\";

         masters {192.168.0.1;};

};

 

zone \"0.168.192.in-addr.arpa\" IN {

        type slave;

        file \"slaves/192.168.0.rev\";

         masters {192.168.0.1;};

};

" >> /etc/named.rfc1912.zones

 

service network restart

service named restart

chkconfig --level 35 named on

 

service ntpd stop

chkconfig ntpd off

mv /etc/ntp.conf /etc/ntp.conf.bak

 

 

 

 

 

 

 

 

 

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30130773/viewspace-2097277/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： linux 查找文件及统计文件信息
下一篇： EXP/IMP批量用户导入导出
请登录后发表评论 登录
全部评论
彩伦

注册时间：2015-02-06

  • 博文量
    138
  • 访问量
    892103

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593