Monday, July 18, 2011

Step by Step Installation of Oracle 10g in CentOS 5.6

Minimum Hardware Requirements.

OS:- CentOS 5.6
Memory:- 1 GB
Harddisk:- 20 GB


Installing rpm packages which are required for Oracle installation
Application:- Graphical Internet
Development:-Development Libraries, Development Tools, GNOME Software Development
Java Development, Legacy Software Development, X Software Development
From X Software Development----go to option and check on---libXp-devel and openmotif
Servers:-Server Configuration Tools,Web Server, Windows File Server
Base System:-Administration Tools,Base, Java,  Legacy Software Support, System Tools,X Window system
From Legacy Software Support---select compat
From System Tools--select sysstat
During the Installation: Disable the firewall and SELinux.


For ORACLE:

1.Verify that following packages are installed. 
binutils.i386
compat-gcc-7.3-2.96.128.i386
compat-gcc-c++-7.3-2.96.128.i386
compat-libstdc++-7.3-2.96.128.i386
compat-libstdc++-devel-7.3-2.96.128.i386
cpp.i386
gcc.i386
gcc-c++.i386
glibc.i386
glibc-common.i386
glibc-devel.i386
glibc-headers.i386
libstdc++.i386
libstdc++-devel.i386
libaio
libaio-devel.i386
libXp.i386
pdksh.i386
setarch.i386
sysstat.i386


rpm -q binutils compat-gcc-7.3-2.96.128 compat-gcc-c++-7.3-2.96.128 
compat-libstdc++-7.3-2.96.128 compat-libstdc++-devel-7.3-2.96.128 
cpp gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libstdc++ 
libstdc++-devel libaio libaio-devel libXp pdksh setarch sysstat 
installing the rpm:- libaio-devel-0.3.106-3.2.i386.rpm
 
2.Edit  /etc/hosts file
Add hostname and ip address eg. 192.168.11.30   oracletest.com.np
 
3. Edit /etc/sysctl.conf
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.sem = 250 32000 100 128
net.ipv4.tcp_rmem = 4096 262144 524288
net.ipv4.tcp_wmem = 4096 262144 524288
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.tcp_syn_retries = 2
net.ipv4.tcp_retries2 = 3
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_intvl = 60
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_local_port_range = 1024 65000
 
4. Run the following command to change the kernel parameters
/sbin/sysctl -p

5. Add the following security parameter in /etc/security/limits.con
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536


6. Edit /etc/pam.d/login and add following line
session required pam_limits.so
 
7. SElinux and firewall should be turned off modify /etc/selinux/config 
SELINUX=disabled
 
8.Creating following users and Groups
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
 
9.Create directory to house oracle and change ownership
#mkdir -p /u01/app/oracle/product/10.2.0/db_1
#chown -R oracle.oinstall /u01

10.edit /etc/redhat-release

OR

runinstaller ignoresysprereqs
 
11.Edit the /home/oracle/.bash_profile
add the following lines

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=testdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$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

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi
 
12.Log into the oracle user. Execute command xterm to verify DISPLAY environmental variable set properly else

 

No comments:

Post a Comment