Skip to main content

ORACLE DB INSTALLATION ON CENTOS

     
 For oracle database installation we want enough space on our disk and also needed a swap space in our linux system.First Download the Oracle software from oracle site

 Unzip the files.
 #unzip linux.x64_11gR2_database_1of2.zip

Set up the Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
 <IP-address>  <fully-qualified-machine-name>  <machine-name>         
#vi /etc/hosts  
192.168.0.215   ol7.localdomain  ol7
Set the correct hostname in the "/etc/hostname" file.
#vi /etc/hostname
ol7.localdomain

Add or amend the following lines in the "/etc/sysctl.conf" file.
#vi /etc/sysctl.conf


fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1807687680
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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


Run the following command to change the current kernel parameters.
#/sbin/sysctl -p


Add the following lines to the "/etc/security/limits.conf" file.
#vi /etc/security/limits.conf

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240


Add the following line to the "/etc/pam.d/login" file, if it does not already exist.
session    required     pam_limits.so



Install the following packages
yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install elfutils-libelf-devel -y
yum install compat-libcap1


 Create the new groups and users.

#groupadd -g 54321 oinstall
#groupadd -g 54322 dba
#groupadd -g 54323 oper
#useradd -g oinstall -G dba,oper oracle


Set the password for the "oracle" user.
#passwd oracle


Create the directories in which the Oracle software will be installed.
#mkdir -p /u01/app/oracle/product/11.2.0.4/db_1
#chown -R oracle:oinstall /u01
#chmod -R 775 /u01


Add the following lines at the end of the "/home/oracle/.bash_profile" file.


#vi /home/oracle/.bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=ol7.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
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/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH


Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

#DISPLAY=<machine-name>:0.0; export DISPLAY


Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
#./runInstaller












During the link phase you will encounter an error invoking the "ins_emagent.mk" file. To fix this, edit the "$ORACLE_HOME/sysman/lib/ins_emagent.mk", doing a search and replace for the line shown below.
FROM:
$(MK_EMAGENT_NMECTL)
TO  :
$(MK_EMAGENT_NMECTL) -lnnz11
Click the "Retry" button.


Post Installation
Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
DB11G:/u01/app/oracle/product/11.2.0.4/db_1:Y