Oracle 12c Study之-- Oracle 12.2安装

￡神魔★判官ぃ 2022-09-27 14:28 126阅读 0赞

**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 ~\]\# 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软件安装**

**![Center][]**

**Oracle 12c软件安装和Oracle 11g安装基本区别不大**

**六、创建数据库**

**![Center 1][]**

**![Center 2][]**

**对于Oracle 12c增加了多租户数据库的创建！**

[Center]: /images/20220708/852cea5894964856be63ea410db44839.png
[Center 1]: /images/20220708/befe96aa380e4fd382b949e8b2c5914d.png
[Center 2]: /images/20220708/5a9a9fdcc11247e0af5f9b14878378eb.png