About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

Friday, September 27, 2013

How to install Oracle Database in RedHat Linux 5 step by step

PFB steps to install Oracle Database on RHEL 5 :-

1. Download Software from Oracle Metalink.


2. Unzip file in same directory one by one. PFB how to unzip .cpio extension file :-

[oracle@localhost database]$ gunzip 10201_database_linux_x86_64.cpio.gz
[oracle@localhost database]$ cpio -ivmd < 10201_database_linux_x86_64.cpio

3. You need minimum 3.5 GB space for this installation excluding software.

4. Prerequisites for Oracle Installation in RHEL5 :-

a. Check Memory :- Minimum 1GB required, But 2GB recommended.

[root@localhost ~]# grep MemTotal /proc/meminfo
MemTotal:      2058824 kB

b. Check that System architecture can run software :-

[root@localhost ~]# uname -m

As system is 64 bit , Oracle which has to be installed has to be 64 bit.

c. Check Swap Space :-

1GB -2GB RAM    ----------  SWAP space 1.5 times
2GB - 16GB RAM ---------   SWAP space equal to RAM
> 16GB RAM        ---------   SWAP space equals 16GB

[root@localhost ~]# grep SwapTotal /proc/meminfo
SwapTotal:     4095992 kB

d. Check /tmp directory :-

[root@localhost ~]# df -h /tmp
Filesystem            Size  Used Avail Use% Mounted on
                       2G   436m  1.5G  21% /tmp

/tmp directory must have 1GB free space.

e. Check Kernal Version :-

[root@localhost ~]# uname -r

f. Check Package requirements :-

go to location : - /media/RHEL_5.7 x86_64 DVD/Server and run below commands 

rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
rpm -Uvh libaio-0*
rpm -Uvh gcc-3*
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*
rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm

Run above packages , if they are already installed then it will give message as 'INSTALLED' and those are not installed it will install those.

If you need to check which package is there or not then use :-

rpm -q package_name

g. Create required groups, User and Directories :-

[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# mkdir -p /oracle_home/app
[root@localhost /]# chown -R oracle:oinstall /oracle_home/app
[root@localhost /]# chmod -R 750 /oracle_home/app
[root@localhost /]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

h. Configuring Kernal Parameters :-

Enter the below mentioned entries in /etc/sysctl.conf file :-

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

If values for above already present commnt those. Run below mentioned command to change current kernal values :-

[root@localhost ~]# /sbin/sysctl -p
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

i. Configure the Resource limits for Oracle User :-

Enter the below mentioned entries in /etc/security/limits.conf file :-

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

j. Edit /etc/pam.d/login file

session    required     pam_limits.so

k. Set the Display setting for graphical Oracle Installation :-

[root@localhost /]# su - oracle
[oracle@localhost ~]$ export DISPLAY=localhost:0.0
[oracle@localhost ~]$ echo $DISPLAY

Prerequisites have been completed . Now we can start Oracle Installation.

5. Installation of Oracle

a. Run the ./runInstaller in database folder which has been created after Unzipping the software :-

1. select advanced installation
2. Enter Oracle_HOME location as we have created directory
3. Enter password for sys,system admin users 
4. Select to install database also including software.
5. select location of datafiles.
6. select FRA location.
7. Enable Automated backups, for this enter os user details. In our case "oracle".
8. First it will install Network utility then Oracle Database and one optional Isqlplus.
9. Run root.sh script 

Installation completed successfully for 10GR2.

I hope this article helped you.

Amit Rath

No comments:

Post a Comment