Installation of Oracle Enterprise/Standard/Standard-one Edition on CentOS release 6.2 (Final)

//Find memory information by issuing following command:

grep -i memtotal /proc/meminfo
[root@centos ~]# grep -i memtotal /proc/meminfo
MemTotal: 497680 kB
//Find swap memory information by issuing following command:
grep -i swaptotal /proc/meminfo
[root@centos ~]# grep -i swaptotal /proc/meminfo
SwapTotal: 524280 kB
//Find CPU information by issuing following command:
grep “model name” /proc/cpuinfo
[root@centos ~]# grep “model name” /proc/cpuinfo
model name : Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
//Find filesystem information by issuing following command:
df -k /dev/shm
[root@centos ~]# df -k /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
tmpfs 268296 0 268296 0% /dev/shm
df -k
[root@centos ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg_94762034-lv_root
29936416 775188 27656212 3% /
tmpfs 268296 0 268296 0% /dev/shm
/dev/xvda1 495844 31576 438668 7% /boot
df -k /tmp
[root@centos ~]# df -k /tmp
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg_94762034-lv_root
29936416 775188 27656212 3% /

//Find linux version information by issuing following command:
[root@centos ~]# cat /proc/version
Linux version 2.6.32-220.el6.x86_64 (mockbuild@c6b18n3.bsys.dev.centos.org) (gcc version 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) ) #1 SMP Tue Dec 6 19:48:22 GMT 2011

 

//Find linux release information by issuing following command:
cat /etc/redhat-release
[root@centos ~]# cat /etc/redhat-release
CentOS release 6.2 (Final)

 

//After meeting minimum requirement’s about hardware and linux version we can proceed with the packages installation:
yum install compat-libstdc++* binutils* elfutils-libelf* pdksh* elfutils-libelf-devel* glibc* glibc-common* glibc-devel* glibc-headers* gcc* gcc-c++* libaio-devel* libaio* libgcc* libstdc++* libstdc++* make* sysstat* unixODBC* unixODBC-devel* –skip-broken –y
yum install rpm* nano* -y

 

//Download and install following rpm:
wget ftp://ftp.muug.mb.ca/mirror/centos/5.9/os/i386/CentOS/pdksh-5.2.14-37.el5_8.1.i386.rpm
rpm -ivh pdksh-5.2.14-37.el5_8.1.i386.rpm

 

//Create oracle group and users by issuing following command:
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -g oinstall -G dba -s /bin/bash oracle
/usr/bin/passwd oracle
New password: oracle
Retype new password: oracle

 

//Setting shell limits by updating “/etc/security/limits.conf” file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

 

//Add the following values in the “/etc/sysctl.conf” file and restart the sysctl by using the command:   sysctl -p
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmni = 4096
#kernel.sem = 250 32000 100 128
kernel.sem = 256 32768 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
kernel.shmmax = 4294967295

 

//Append the following lines to “/etc/pam.d/login” file:
session required /lib64/security/pam_limits.so
session required pam_limits.so

 

//Append the following lines to the “/etc/profile” file:
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

 

//Create “database” directory as follow:
mkdir /opt/app/database

 

//Assign appropriate privileges & permissions to oracle user on above created directories:
chown -R oracle:oinstall /opt/app/database
chmod -R 775 /opt/app/database

 

//Download oracle Software from http://www.oracle.com

//Extract oracle software & copy it to CentOS server.

//Configure VNC-Server to get GUI prompt.

//Kindly refer my one of the blog to configure VNC-Server.

//Run oracle universal installer and follow the steps below:

Step 1 of 12:

Configure Security Updates:
click next.

Step 2 of 12:

Download Software updates:
skip this step and click on next.

Step 3 of 12:

Select Installation Option:
Select “Create and configure database” radio button and click next.

Step 4 of 12:

System Class:
Select “Server Class” radio button and click next.

Step 5 of 12:

Grid Installation Option:
Select “Single instance database installation” radio button and click next.

Step 6 of 12:

Select Install Type:
Select “Typical install” radio button and click next.

Step 7 of 12:

Typical Install Configuration:
Provide database edition information from drag down list.
Provide Administrative password.
& click next.

Step 8 of 12:

Create Inventory:
click next.

Step 9 of 12:

Perform Prerequisite Checks:
After meeting all minimum requirements click next.

Step 10 of 12:

Summary:
Verify all configuration and click Installation.

Step 11 of 12:

Install Product:
Execute provided configuration script by root user.

Step 12 of 12:

Finish.

 

//Set environment variable and start database by following command:

[root@94-76-203-4 ~]# su – oracle
[oracle@94-76-203-4 ~]$ export ORACLE_SID=orcl
[oracle@94-76-203-4 ~]$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1/
[oracle@94-76-203-4 ~]$ export PATH=/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin

 

//Access sql prompt by issuing following command & startup database:
[oracle@94-76-203-4 ~]$ sqlplus “/ as sysdba”
SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 6 11:29:57 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
SQL> select open_mode from v$database;
OPEN_MODE
————————————
READ WRITE
SQL>

//Database has been successfully installed and open.

// Set oracle environment variable in “/home/oracle/.bash_profile” file, so that no need to set environment variable every login.
************************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a nice time ahead.