Monday, June 27, 2016

Install Oracle 11g release 2 on CEntOS 6.3

7:43 AM Posted by Dilli Raj Maharjan , No comments

Environment


  • Hostname: oel1.localdomain
  • Arch: x86_64
  • OS: CentOS 6.3
  • Oracle: 11.2.0.4
  • 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


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

oracle@OEL1 database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 25021 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3122 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-06-26_09-56-43PM. Please wait ...


































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 Create and configure a database option and Click on Next to continue. 


Select Server Class if you have sufficient hardware resource as RAM, CPU and click on Next to continue.



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


Click on Typical install and Click on Next to continue.


Select Oracle base, Software location, Storage Type (File System if you do not have ASM), Database Edition, Global database name and Administrative Password. Click on next to continue.


Prerequisite checks will be performed and if there is any package or configuration error it will prompt for fix. 


Once prerequisite checks is completed it will display the Summary window. Click on Save Response file to save the Summary file for future use.


Select the location to save the response file.


Click on Install to start installation.


Installation in progress #####


Installation in progress ##########



Database installation in progress #####



Once database installation is completed Summary and Password Management window will be displayed. Click on OK to continue.


On terminal window execute the mentioned script as user root.



Finally database installation completion window will be displayed. Click on Close window to complete installation.







0 comments:

Post a Comment