Thursday, November 24, 2016

Install Oracle 11g release 2 software only

6:52 PM Posted by Dilli Raj Maharjan No comments

Environment

Hostname: oel1.localdomain
Arch: x86_64
OS: OEL 6.3
Oracle: 11.2.0.3
RAM: 4G
HDD: 500G


Required Linux Package:

binutils-2*x86_64*
glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
glibc-2*i686* nss-softokn-freebl-3*i686*
compat-libstdc++-33*x86_64*
glibc-common-2*x86_64*
glibc-devel-2*x86_64*
glibc-devel-2*i686*
glibc-headers-2*x86_64*
elfutils-libelf-0*x86_64*
elfutils-libelf-devel-0*x86_64*
gcc-4*x86_64*
gcc-c++-4*x86_64*
ksh-*x86_64*
libaio-0*x86_64*
libaio-devel-0*x86_64*
libaio-0*i686*
libaio-devel-0*i686*
libgcc-4*x86_64*
libgcc-4*i686*
libstdc++-4*x86_64*
libstdc++-4*i686*
libstdc++-devel-4*x86_64*
make-3.81*x86_64*
numactl-devel-2*x86_64*
sysstat-9*x86_64*
compat-libstdc++-33*i686*
unixODBC-*x86_84
unixODBC-devel-*x86_84

Execute following command to verify the package installation.

rpm -q binutils glibc nss-softokn-freebl compat-libstdc++-33 glibc-common glibc-devel \
glibc-headers elfutils-libelf elfutils-libelf-devel gcc gcc-c++ ksh libaio libaio-devel \
libgcc libstdc++ libstdc++-devel make numactl-devel sysstat unixODBC unixODBC-devel

Add following kernel parameters. Add following lines on the /etc/sysctl.conf

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

Execute following command to reflect the above kernel parameters

/sbin/sysctl -p

Add following lines to /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 following line /etc/pam.d/login

session    required     pam_limits.so

Disable selinux. Modify /etc/selinux/config

SELINUX=disable

Stop iptables on Linux and disable iptables on startup

/etc/init.d/iptables stop
chkconfig iptables off


Execute following command to create OS groups and users.

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper

useradd -u 502 -g oinstall -G dba,oper oracle
passwd oracle

Create required directories for oracle installation.

mkdir -p /u01/app/oracle/product/11.2.0.4/db_1
chown -R oracle:oinstall /u01/app/oracle

Add following environment variables on .bash_profile

ORACLE_HOSTNAME=OEL1.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
DB_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export DB_HOME
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_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



Verify Oracle Home is properly set.

source .bash_profile
echo $ORACLE_HOME
cd $ORACLE_HOME
pwd











On terminal window change directory to source and execute ./runInstaller
































Once you execute the runInstaller executable above screen will be appeared. Check out "I wish to receive security updates via My Oracle Support"






























Click on Next after checkout the security updates option.













Warning message window will be prompt. Click on Yes to continue.






























Click on Skip software updates and Click on Next to continue.
































Click on Install database software only and Click on Next to continue. 






























Click on Single instance database installation and Click on Next to continue.































Select required languages and Click on Next to continue.






























Select Database Edition. In my case I have selected Enterprise Edition. Click on Next to continue.






























Select appropriate Oracle_Base and Software Location. Click on Next to continue.






























Select OSOPER and OSDBA group. I just left default and clicked on Next.






























Since we have less swap space then recommended the pre-requisite failed. Select Ignore All and Click on Next.






























Warning message will be poped up Simply Click on Yes to continue.


























































Click on Save Response File and Give appropriate name to save response file.






























Click on Install to begin installation.































Installation on progress ##########.



















Once execute configuration script window will be displayed. Execute the listed script as user root and Click on OK to continue.






























Database installation was successful.  Click on Close to end installation.


  1. Install Oracle 11g Grid Infrastructure With Oracle Virtualbox
  2. ASM Disk Creation with asmca
  3. Install Oracle 11g R2 Software
  4. Create Oracle database with ASM Disk Group

0 comments:

Post a Comment