Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
<IP-address> <fully-qualified-machine-name> <machine-name>
For example.
127.0.0.1 localhost localhost.localdomain
192.168.1.21 testdb.com testdb
Set the correct hostname in the "/etc/hostname" file.
Manual Setup
If you have not used the "oracle-database-server-12cR2-preinstall" package to perform all
prerequisites, you will need to manually perform the following setup tasks.
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-
12cR2-preinstall.conf" file.
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
Install RPMS from /media/ENterpise/Server
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*
Define different groups
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
#groupadd -g 54324 backupdba
#groupadd -g 54325 dgdba
#groupadd -g 54326 kmdba
#groupadd -g 54327 asmdba
#groupadd -g 54328 asmoper
#groupadd -g 54329 asmadmin
#groupadd -g 54330 racdba
Creating Oracle User
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle
Creating Directories structure
mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome
chown -R oracle:oinstall /u01
chmod -R 775 /u01
Setting Environment Variable
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=testdb.com; 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
The "/etc/hosts" file must contain a fully qualified name for the server.
<IP-address> <fully-qualified-machine-name> <machine-name>
For example.
127.0.0.1 localhost localhost.localdomain
192.168.1.21 testdb.com testdb
Set the correct hostname in the "/etc/hostname" file.
Manual Setup
If you have not used the "oracle-database-server-12cR2-preinstall" package to perform all
prerequisites, you will need to manually perform the following setup tasks.
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-
12cR2-preinstall.conf" file.
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
Install RPMS from /media/ENterpise/Server
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*
Define different groups
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
#groupadd -g 54324 backupdba
#groupadd -g 54325 dgdba
#groupadd -g 54326 kmdba
#groupadd -g 54327 asmdba
#groupadd -g 54328 asmoper
#groupadd -g 54329 asmadmin
#groupadd -g 54330 racdba
Creating Oracle User
useradd -u 54321 -g oinstall -G dba,oper oracle
passwd oracle
Creating Directories structure
mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome
chown -R oracle:oinstall /u01
chmod -R 775 /u01
Setting Environment Variable
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=testdb.com; 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