Oracle 12c Study之-- Oracle 12.2安装
系统环境:
操作系统: RedHat EL6(64)
Oracle: Oracle 12C(2)
一、安装环境准备
1、配置内核参数
[root@rh64 ~]# vi /etc/sysctl.conf
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
[root@rh64 ~]# vi /etc/sysctl.conf
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
内核参数生效:
[root@rh64 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
配置用户资源限制 :
[root@rh64 ~]# vi /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
二、安装相应软件包
[root@rh64 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
配置用户资源限制 :
[root@rh64 ~]# vi /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
二、安装相应软件包
1、配置yum文件
[root@rh64 ~]# cd /etc/yum.repos.d/
[root@rh64 yum.repos.d]# cat yum.repo
[base]
name=Red Hat Enterprise Linux
baseurl=file:///media/Server
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
2、软件包安装:
[root@rh64 yum.repos.d]# rpm -qa compat-libstdc++-33 elfutils-libelf-devel glibc-devel-2.5 gcc
gcc-4.4.7-3.el6.x86_64
elfutils-libelf-devel-0.152-1.el6.x86_64
[root@rh64 yum.repos.d]# yum install -y compat*
[root@rh64 yum.repos.d]# yum install -y glibc*
[root@rh64 yum.repos.d]# rpm -qa libaio-devel libstdcc++-devel unixODBC unixODBC-devel sysstat binutils
sysstat-9.0.4-20.el6.x86_64
binutils-2.20.51.0.2-5.36.el6.x86_64
[root@rh64 yum.repos.d]# yum install -y libaio*
[root@rh64 yum.repos.d]# yum install -y libst*
[root@rh64 yum.repos.d]# yum install -y unix*
[root@rh64 yum.repos.d]# rpm -q elfutils-libelf glibc-common libaio libgcc libstdc++ make
三、配置用户环境
[oracle@rh64 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
#oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export LC_ALL=en_US.UTF-8
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export CLASSPATH=$ORACLE_HOME/JREORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
四、建立相关目录
[root@rh64 yum.repos.d]# mkdir -p /u01/app/oracle
[root@rh64 yum.repos.d]# id oracle
uid=200(oracle) gid=200(oinstall) groups=200(oinstall),201(dba)
[root@rh64 yum.repos.d]# chown -R oracle:oinstall /u01
五、Oracle软件安装
[root@rh64 ~]# cd /etc/yum.repos.d/
[root@rh64 yum.repos.d]# cat yum.repo
[base]
name=Red Hat Enterprise Linux
baseurl=file:///media/Server
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
2、软件包安装:
[root@rh64 yum.repos.d]# rpm -qa compat-libstdc++-33 elfutils-libelf-devel glibc-devel-2.5 gcc
gcc-4.4.7-3.el6.x86_64
elfutils-libelf-devel-0.152-1.el6.x86_64
[root@rh64 yum.repos.d]# yum install -y compat*
[root@rh64 yum.repos.d]# yum install -y glibc*
[root@rh64 yum.repos.d]# rpm -qa libaio-devel libstdcc++-devel unixODBC unixODBC-devel sysstat binutils
sysstat-9.0.4-20.el6.x86_64
binutils-2.20.51.0.2-5.36.el6.x86_64
[root@rh64 yum.repos.d]# yum install -y libaio*
[root@rh64 yum.repos.d]# yum install -y libst*
[root@rh64 yum.repos.d]# yum install -y unix*
[root@rh64 yum.repos.d]# rpm -q elfutils-libelf glibc-common libaio libgcc libstdc++ make
三、配置用户环境
[oracle@rh64 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
#oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export LC_ALL=en_US.UTF-8
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export CLASSPATH=$ORACLE_HOME/JREORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
四、建立相关目录
[root@rh64 yum.repos.d]# mkdir -p /u01/app/oracle
[root@rh64 yum.repos.d]# id oracle
uid=200(oracle) gid=200(oinstall) groups=200(oinstall),201(dba)
[root@rh64 yum.repos.d]# chown -R oracle:oinstall /u01
五、Oracle软件安装
Oracle 12c软件安装和Oracle 11g安装基本区别不大
六、创建数据库
对于Oracle 12c增加了多租户数据库的创建!