tauseefdbablogs: February 2018

Oracle 12c comes with a lot of changes, its not only cloud word changed, but come with truely different concept of container and portable databases, it helps the enterprises with save the hardware resources and utilizes the resources in best possible way.

Installation step are as below:

Virtual Machine preparation for 12c Database:

Linux Installation version 6.4 on VB:

Skip the test!

Defining the hostname:

Geographic location selection:

Create custom layout for partioning of local drives:

SWAP should be double of RAM of VM:

Setting up Network for FTP and SSH:

Setting environment for Oracle software and Databases (RPMS)

Installing RPMS and setting IPs:

Making host file entry, specifying ip in host file:

vi /etc/hosts

127.0.0.1 localhost localhost.localdomain
192.168.1.12 12cTESTDB 12cTESTDB

Add the following lines to the "/etc/sysctl.conf" file, or in a file called

"/etc/sysctl.d/98-oracle.conf".

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000

than in order to be activate/to take effects now run below command

/sbin/systcl -p

Add the following lines to a file called "/etc/security/limits.d/oracle-database-server-

oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728

Installing the RPM available at Package directory of ISO image:

cd /media/rhel5/package

rpm -Uvh --force --nodeps gcc-4.4.7-3.el6.x86_64.rpm
rpm -Uvh --force --nodeps gcc-c++-4.4.7-3.el6.x86_64.rpm
rpm -Uvh --force --nodeps binutils*
rpm -Uvh --force --nodeps compat-libcap1*
rpm -Uvh --force --nodeps compat-libstdc++-33*
rpm -Uvh --force --nodeps compat-libstdc++-33.i686*
rpm -Uvh --force --nodeps glibc*
rpm -Uvh --force --nodeps glibc.i686*
rpm -Uvh --force --nodeps glibc-devel*
rpm -Uvh --force --nodeps glibc-devel.i686*
rpm -Uvh --force --nodeps ksh*
rpm -Uvh --force --nodeps libaio*
rpm -Uvh --force --nodeps libaio.i686*
rpm -Uvh --force --nodeps libaio-devel*
rpm -Uvh --force --nodeps libaio-devel.i686*
rpm -Uvh --force --nodeps libX11*
rpm -Uvh --force --nodeps libX11.i686*
rpm -Uvh --force --nodeps libXau*
rpm -Uvh --force --nodeps libXau.i686*
rpm -Uvh --force --nodeps libXi*
rpm -Uvh --force --nodeps libXi.i686*
rpm -Uvh --force --nodeps libXtst*
rpm -Uvh --force --nodeps libXtst.i686*
rpm -Uvh --force --nodeps libgcc*
rpm -Uvh --force --nodeps libgcc.i686*
rpm -Uvh --force --nodeps libstdc++*
rpm -Uvh --force --nodeps libstdc++.i686*
rpm -Uvh --force --nodeps libstdc++-devel*
rpm -Uvh --force --nodeps libstdc++-devel.i686*
rpm -Uvh --force --nodeps libxcb*
rpm -Uvh --force --nodeps libxcb.i686*
rpm -Uvh --force --nodeps make*
rpm -Uvh --force --nodeps nfs-utils*
rpm -Uvh --force --nodeps net-tools*
rpm -Uvh --force --nodeps smartmontools*
rpm -Uvh --force --nodeps sysstat*
rpm -Uvh --force --nodeps unixODBC*
rpm -Uvh --force --nodeps unixODBC-devel*

Creating the groups:

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper

Creating the Oracle User and setting password for it:
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle

Changing password for user oracle.

New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.

Setting up directory structure:

mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Setting environment variable for CDB:

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=12cTESTDB; export ORACLE_HOSTNAME
ORACLE_UNQNAME=cdb1; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1; export ORACLE_HOME
ORACLE_SID=cdb1; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH