Oracle Database 12c New Features

Install Oracle 12c on Linux 7

Install required packages

yum install xterm libXaw libXpm binutils glibc-kernheaders gcc gcc-c++ glibc glibc-common libstdc++ libstdc++-devel make sysstat compat-libstdc++-33 glibc-headers libaio libaio-devel libgcc glibc-devel expat zlib xorg-x11-utils xorg-x11-xauth wget unzip traceroute smartmontools libXxf86misc libXxf86dga libdmx ksh compat-libcap1 bind-utils bind-libs bc elfutils-libelf-devel sysfsutils lsscsi libXi libXtst

[root@nextcurve ~]# yum install xterm libXaw libXpm binutils glibc-kernheaders gcc gcc-c++ glibc glibc-common libstdc++ libstdc++-devel make sysstat compat-libstdc++-33 glibc-headers libaio libaio-devel libgcc glibc-devel expat zlib xorg-x11-utils xorg-x11-xauth wget unzip traceroute smartmontools libXxf86misc libXxf86dga libdmx ksh compat-libcap1 bind-utils bind-libs bc elfutils-libelf-devel sysfsutils lsscsi libXi libXtst
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.ipserverone.com
 * extras: mirror.vodien.com
 * updates: centos.ipserverone.com
Package xterm-295-3.el7.x86_64 already installed and latest version
Package libXaw-1.0.12-5.el7.x86_64 already installed and latest version
Package libXpm-3.5.11-3.el7.x86_64 already installed and latest version
Package binutils-2.23.52.0.1-55.el7.x86_64 already installed and latest version
Package kernel-headers-3.10.0-327.18.2.el7.x86_64 already installed and latest version
Package gcc-4.8.5-4.el7.x86_64 already installed and latest version
Package gcc-c++-4.8.5-4.el7.x86_64 already installed and latest version
Package glibc-2.17-106.el7_2.6.x86_64 already installed and latest version
Package glibc-common-2.17-106.el7_2.6.x86_64 already installed and latest version
Package libstdc++-4.8.5-4.el7.x86_64 already installed and latest version
Package libstdc++-devel-4.8.5-4.el7.x86_64 already installed and latest version
Package 1:make-3.82-21.el7.x86_64 already installed and latest version
Package sysstat-10.1.5-7.el7.x86_64 already installed and latest version
Package compat-libstdc++-33-3.2.3-72.el7.x86_64 already installed and latest version
Package glibc-headers-2.17-106.el7_2.6.x86_64 already installed and latest version
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version
Package libgcc-4.8.5-4.el7.x86_64 already installed and latest version
Package glibc-devel-2.17-106.el7_2.6.x86_64 already installed and latest version
Package expat-2.1.0-8.el7.x86_64 already installed and latest version
Package zlib-1.2.7-15.el7.x86_64 already installed and latest version
Package xorg-x11-utils-7.5-13.1.el7.x86_64 already installed and latest version
Package 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 already installed and latest version
Package wget-1.14-10.el7_0.1.x86_64 already installed and latest version
Package unzip-6.0-15.el7.x86_64 already installed and latest version
Package 3:traceroute-2.0.19-5.el7.x86_64 already installed and latest version
Package 1:smartmontools-6.2-4.el7.x86_64 already installed and latest version
Package libXxf86misc-1.0.3-7.1.el7.x86_64 already installed and latest version
Package libXxf86dga-1.1.4-2.1.el7.x86_64 already installed and latest version
Package libdmx-1.1.3-3.el7.x86_64 already installed and latest version
Package ksh-20120801-22.el7_1.3.x86_64 already installed and latest version
Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version
Package 32:bind-utils-9.9.4-29.el7_2.3.x86_64 already installed and latest version
Package 32:bind-libs-9.9.4-29.el7_2.3.x86_64 already installed and latest version
Package bc-1.06.95-13.el7.x86_64 already installed and latest version
Package elfutils-libelf-devel-0.163-3.el7.x86_64 already installed and latest version
Package sysfsutils-2.1.0-16.el7.x86_64 already installed and latest version
Package lsscsi-0.27-3.el7.x86_64 already installed and latest version
Package libXi-1.7.4-2.el7.x86_64 already installed and latest version
Package libXtst-1.2.2-2.1.el7.x86_64 already installed and latest version
Nothing to do

Create user and group

[root@nextcurve ~]# groupadd oinstall
[root@nextcurve ~]# groupadd dba
[root@nextcurve ~]# 
[root@nextcurve ~]# useradd -g oinstall -G dba oracle -d /home/oracle
[root@nextcurve ~]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password is shorter than 8 characters
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@nextcurve ~]# 


Unzip Oracle software

[oracle@nextcurve oracle-12.1.0.2]$ pwd
/home/oracle/oracle-12.1.0.2
[oracle@nextcurve ~]$
[oracle@nextcurve ~]$
[oracle@nextcurve oracle-12.1.0.2]$ ls -ltr
total 2625932
-rw-r--r--. 1 oracle oinstall 1015358809 May  4 05:25 linuxamd64_12102_database_se2_2of2.zip
-rw-r--r--. 1 oracle oinstall 1673591558 May  4 05:25 linuxamd64_12102_database_se2_1of2.zip
[oracle@nextcurve oracle-12.1.0.2]$ unzip linuxamd64_12102_database_se2_1of2.zip 
Archive:  linuxamd64_12102_database_se2_1of2.zip
   creating: database/
   creating: database/rpm/
  inflating: database/rpm/cvuqdisk-1.0.9-1.rpm  

[oracle@nextcurve oracle-12.1.0.2]$ 
[oracle@nextcurve oracle-12.1.0.2]$ 
[oracle@nextcurve oracle-12.1.0.2]$ unzip linuxamd64_12102_database_se2_2of2.zip 
Archive:  linuxamd64_12102_database_se2_2of2.zip
   creating: database/stage/Components/oracle.ctx/
   creating: database/stage/Components/oracle.ctx/12.1.0.2.0/
   creating: database/stage/Components/oracle.ctx/12.1.0.2.0/1/
   creating: database/stage/Components/oracle.ctx/12.1.0.2.0/1/DataFiles/


Create oracle home

mkdir -p /opt/oracle/rdbms/12.1.0
mkdir -p /opt/oracle/oraInventory
chown -R oracle:oinstall /opt/oracle
chown -R oracle:oinstall /opt/oracle/oraInventory

[root@nextcurve oracle]# mkdir -p /opt/oracle/rdbms/12.1.0
[root@nextcurve oracle]# mkdir -p /opt/oracle/oraInventory
[root@nextcurve oracle]# chown -R oracle:oinstall /opt/oracle
[root@nextcurve oracle]# chown -R oracle:oinstall /opt/oracle/oraInventory
[root@nextcurve oracle]# 
[root@nextcurve oracle]# 

Modify system parameter to minimum

[root@nextcurve 12.1.0]# cat /etc/sysctl.conf 
# System default settings live in /usr/lib/sysctl.d/00-system.conf.
# To override those settings, enter new settings here, or in an /etc/sysctl.d/<name>.conf file
#
# For more information, see sysctl.conf(5) and sysctl.d(5).


fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 3975677952
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



[root@nextcurve fixup]# cat /etc/security/limits.conf
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file


oracle soft nproc 2047 
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536 


reboot system

[root@nextcurve 12.1.0]# reboot

runInstaller

[oracle@nextcurve oracle-12.1.0.2]$ cd database/
[oracle@nextcurve database]$ ls
install  response  rpm  runInstaller  sshsetup  stage  welcome.html
[oracle@nextcurve database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 46276 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3967 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-05-14_03-21-02PM. Please wait ...[oracle@nextcurve database]$ You can find the log of this install session at:
 /opt/oracle/oraInventory/logs/installActions2016-05-14_03-21-02PM.log