Oracle AppsDBAs World: Installing 11g(11.1.0) database on Redhat Linux 4

Operating System:
==============
Red Hat Enterprise Linux 4

Database Version:
==============
Oracle 11g Release 1

You can download the oracle 11g r1 software in the below link

Download link:
===========
http://www.oracle.com/technology/software/products/database/index.html

Pre-Installation Tasks:
=================
Creating OS User account and group:
------------------------------------------
$groupadd dba -creating OS group
$useradd -g dba oracle -creating OS user and assigning to group
$passwd oracle -- set password for that OS user.

Checking physical RAM size:
--------------------------------
$ grep MemTotal /proc/meminfo
Make it sure that physical memory size should be 1GB. And it shouldn't less than 900M.

Checking SWAP size:
-------------------------
$ grep SwapTotal /proc/meminfo
Note:swap should be double of memory

Checking space in “/tmp”
-----------------------------
$ df -k /tmp

Checking available free space on the system:
-------------------------------------------------
$ df –k

Checking the Software Requirements:
===========================
Checking linux version:
---------------------------
$ uname –a

Checking required packages:
---------------------------------
binutils-2.15.92.0.2-18
compat-libstdc++-33.2.3-47.3
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.97-5
glibc-2.3.9.4-2.19
glibc-common-2.3.9.4-2.19
glibc-devel-2.3.9.4-2.19
gcc-3.4.5-2
gcc-c++-3.4.5-2
libaio-devel-0.3.105-2
libaio-0.3.105-2
libgcc-3.4.5
libstdc++-3.4.5-2
libstdc++-devel-3.4.5-2
make-3.80-5
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-devel-2.2.11

OS command to check RPMS are installed or not:
------------------------------------------------------
Execute as root user
# rpm –q libaio-devel-0.3.105-2
# rpm –q unixODBC-devel-2.2.11
Like this check all rpms.

Like this check for all the above RPMS.

If any rpms are missing download it from
http://rpm.pbone.net/

Installing/Upgrading RPMS:
----------------------------------
Login as the ROOT user
# rpm –ivh unixODBC-devel-2.2.11.3-1.i386.rpm --to install
Or
# rpm –Uvh unixODBC-devel-2.2.11.3-1.i386.rpm --to upgrade

Creating Directories for installation:
-----------------------------------------
Base Directory and Oracle Home
Do it as oracle user,
#mkdir /u01 -- Base directory
# mkdir /u01/app/oracle/product/11.0.1 -- ORACLE_HOME
# mkdir –p /u02/oradata -- DATA_TOP

If you create these directories as a oracle user, the owner of that directory
is oracle only. If you do it as root user you need to change the ownership and
permissons to oracle user for that directory.

# chown –R oracle:dba /u01/app/oracle/product/11.0.1
# chown –R oracle:dba /u02/oradata

Changing permissions:
----------------------------
# chmod –R 755 /u01/app/oracle/product/11.0.1
# chmod –R 755 /u02/oradata

Configuring Kernel Parameters:
------------------------------------
Check the current parameters and values in /etc/sysctl.conf

fs.file-max = 76800
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

if any of these entries are missing just add it. Before that take a ackup of that file
#cp /etc/sysctl.conf /etc/sysctl.confbkp

Changing current values of the kernel parameters:
-------------------------------------------------------
# /sbin/sysctl -p

Ckeck the following lines in the /etc/security/limits.conf file.
-----------------------------------------------------------------
Before editig take a backup of that file.

# cp –p /etc/security/limits.conf /etc/security/limits.confbkp

And add this lines in /etc/security/limits.conf if its not existing,

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Add or edit the following line in the /etc/pam.d/login file,
--------------------------------------------------------------
if this lines are not exist:
-----------------------------
Before editing that file take a backup.
# cp –p /etc/pam.d/login /etc/pam.d/loginbkp

session required /lib/security/pam_limits.so
session required pam_limits.so

Check Oracle User’s Environment:
---------------------------------------
$ vi .bash_profile

Remove the oracle environments. If you set already.
(if u created a new user no need to check this .bash_profile)

Set DISPLAY variable, if its not set
----------------------------------------
$ echo $DISPLAY - to check display has set or not
$ DISPLAY=:0.0 - if its returning this we need to set Display using
the below command,
$ set DISPLAY=(ipaddress of your server):0.0
$ export DISPLAY

Then type, as root user and check xlcock also
# xhost +
# xclock (should display the clock window)

Starting installation:
-------------------------
Login as oracle user
Su – oracle
Go the directory where Oracle software is copied
or if its cd or dvd, mount the device and run runinstaller

$ cd /u01/software
Unzip the dump,
$ unzip linux_11gR1_database.zip

Go to Disk1, Then run runinstaller

./.runInstaller

For sample screen shots just check this link
http://www.oracle.com/technology/obe/11gr1_db/install/dbinst/dbinst.htm

posted by Senthil Kumaran @ 4:32 AM

0 Comments: