santoshspoudel: July 2011

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

santoshspoudel

Monday, July 18, 2011

Step by Step Installation of Oracle 10g in CentOS 5.6

Tuesday, July 12, 2011

Connect to Internet from Vmware Workstation ACE Edition (Ver. 6)