CentOS 6 部署 Oracle 11.2

安装准备

关闭 SELinux

1
setenforce 0
2

3
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
4
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux

关闭防火墙

1
chkconfig iptables off
2
service iptables stop
3

4
chkconfig ip6tables off
5
service ip6tables stop

配置主机名

1
cat > /etc/sysconfig/network <<EOF
2
NETWORKING=yes
3
HOSTNAME=oracle
4
EOF

配置 hosts

1
cat > /etc/hosts <<EOF
2
127.0.0.1     localhost
3
192.168.86.6  oracle
4
EOF

安装依赖软件包

1
yum -y install binutils.x86_64 \
2
                compat-libcap1.x86_64 \
3
                compat-libstdc++-33.x86_64 \
4
                compat-libstdc++-33.i686 \
5
                gcc.x86_64 \
6
                gcc-c++.x86_64 \
7
                glibc.x86_64 \
8
                glibc.i686 \
9
                glibc-devel.x86_64 \
10
                glibc-devel.i686 \
11
                ksh.x86_64 \
12
                libgcc.x86_64 \
13
                libgcc.i686 \
14
                libstdc++.x86_64 \
15
                libstdc++.i686 \
16
                libstdc++-devel.x86_64 \
17
                libstdc++-devel.i686 \
18
                libaio.x86_64 \
19
                libaio.i686 \
20
                libaio-devel.x86_64 \
21
                libaio-devel.i686 \
22
                make.x86_64 \
23
                sysstat.x86_64

创建 oracle 组和账号

1
groupadd oinstall
2
groupadd dba
3
useradd -g oinstall -G dba oracle
4
echo "oracle" | passwd oracle --stdin

配置系统参数

1
cat >> /etc/sysctl.conf <<EOF
2
fs.aio-max-nr = 1048576
3
fs.file-max = 6815744
4
# kernel.shmall = Total RAM in bytes / PAGE_SIZE
5
kernel.shmall = 2097152
6
# kernel.shmmax = Half of total RAM in bytes
7
kernel.shmmax = 536870912
8
kernel.shmmni = 4096
9
kernel.sem = 250 32000 100 128
10
net.ipv4.ip_local_port_range = 9000 65500
11
net.core.rmem_default = 262144
12
net.core.rmem_max = 4194304
13
net.core.wmem_default = 262144
14
net.core.wmem_max = 1048576
15
vm.swappiness = 0
16
vm.dirty_background_ratio = 3
17
vm.dirty_ratio = 80
18
vm.dirty_expire_centisecs = 500
19
vm.dirty_writeback_centisecs = 100
20
EOF
21

22
sysctl -p

1
cat >> /etc/pam.d/login <<EOF
2
session required pam_limits.so
3
EOF

1
cat >> /etc/security/limits.conf <<EOF
2
oracle soft nofile 1024
3
oracle hard nofile 65536
4
oracle soft nproc 2047
5
oracle hard nproc 16384
6
oracle soft stack 10240
7
oracle hard stack 32768
8
EOF

配置环境变量

1
cat > /home/oracle/.bash_profile <<EOF
2
ORACLE_BASE=/home/oracle/app/oracle
3
export ORACLE_BASE
4
ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/dbhome_1
5
export ORACLE_HOME
6
ORACLE_SID=ORCL
7
export ORACLE_SID
8
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
9
export NLS_LANG
10
LD_LIBRARY_PATH=\$ORACLE_HOME/lib
11
export LD_LIBRARY_PATH
12
PATH=\$ORACLE_HOME/bin:\$PATH
13
export PATH
14
EOF

执行安装

1
sh ./runInstaller