oracle安装

环境准备：图形化界面。

1、下载安装包

p13390677_112040_Linux-x86-64_2of7.zip

p13390677_112040_Linux-x86-64_1of7.zip

2、下载之后解压

unzip p13390677_112040_Linux-x86-64_2of7.zip 

unzip p13390677_112040_Linux-x86-64_1of7.zip

3、移动到家目录，解压之后生成database目录

mv database/ /root/

4、安装

安装前的准备，写成一个脚本，直接运行脚本即可。

脚本如下：

#!/bin/bash
PKG="
unixODBC
unixODBC-devel
binutils
compat-libstdc++-33
elfutils-libelf
elfutils-libelf-devel
elfutils-libelf-devel-static
gcc
gcc-c++
glibc
glibc-common
glibc-devel
glibc-headers
kernel-headers
ksh
libaio
libaio-devel
libgcc
libgomp
libstdc++
libstdc++-devel
make
numactl-devel
sysstat
"
PACKINSTALL=


for PACKAGE in $PKG ;do
    rpm -q $PACKAGE || PACKINSTALL="$PACKINSTALL $PACKAGE"
done
echo
if [ -z "$PACKINSTALL" ];then
   true
  else
   echo "The followling packages will be install: $PACKINSTALL "

read -p "Continue? (y/N): " answer
   case $answer in
        ([yY]|[Yy][Ee][Ss])
             echo 1
             yum -y install $PACKINSTALL ;;
        (*);;
   esac
fi


cat /etc/group |grep oinstall &> /dev/null || /usr/sbin/groupadd oinstall
cat /etc/group |grep dba &> /dev/null || /usr/sbin/groupadd dba


id oracle &> /dev/null
        if [ $? = 0 ];then
         groups oracle | grep dba &> /dev/null || /usr/sbin/usermod -g oinstall -G dba oracle
        else
         /usr/sbin/useradd -g oinstall -G dba oracle
         echo oracle |passwd --stdin oracle
        fi


KELNUM=$(cat /etc/sysctl.conf |grep -v ^# |grep -v ^$ |grep -E "fs.aio-max-nr|fs.file-max|kernel.shmall|kernel.shmmax|
kernel.shmmni|kernel.sem|net.ipv4.ip_local_port_range|net.core.rmem_default|net.core.rmem_max|net.core.wmem_default|ne
t.core.wmem_max" |awk '{print $1}' |sort -u |wc -l )


if [ $KELNUM -lt 11 ];then
cat >> /etc/sysctl.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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
EOF
/sbin/sysctl -p
fi

grep oracle /etc/security/limits.conf &> /dev/null
  if [ $? != 0 ];then
cat >> /etc/security/limits.conf << EOF
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   1024
EOF
 fi

grep pam_limits.so /etc/pam.d/login &> /dev/null
  if [ $? != 0 ];then
cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF
  fi


[ -d /u01/app ] || ( mkdir -p /u01/app/ ; chown -R oracle:oinstall /u01/app/ ; chmod -R 775 /u01/app )


grep -i oracle ~oracle/.bash_profile &> /dev/null
  if [ $? != 0 ];then
cat >> ~oracle/.bash_profile <<EOF
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=\$PATH:\$ORACLE_HOME/bin
EOF
  fi

xhost +
[ -d ~oracle/database ] || mv /root/database ~oracle
cd ~oracle;su - oracle -c 'database/runInstaller'

5、运行完脚本之后，切换oracle用户

[root@centos6 Desktop]# su - oracle

[oracle@centos6 ~]$ cd database/

[oracle@centos6 database]$ ./runInstaller 

现在正式安装，会弹出一个界面，直接按照红色区域点击即可。

修改好之后，再执行一遍check again

安装包有问题，需要卸载一个安装包

su - root

rpm -e ksh

rpm -ivh  pdksh-5.2.14-30.x86_64.rpm

再回到上面图中重新执行一次check again,没有问题就执行下一步

执行一下下面这个脚本：

执行第一个脚本：

执行第二个脚本：

运行之后继续安装

至此，oracle安装完成。

6、创建数据库

xhost +

su - oracle

dbca

7、运行oracle

[root@centos6Desktop]# su - oracle

[oracle@centos6 ~]$dbca

[oracle@centos6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 9 11:56:12 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl>

登录成功，至此安装成功。