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

 

Tuesday, July 12, 2011

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

I have Red Hat Enterprise Linux 5  installed which is guest OS on a Vista host.

1) During new virtual machine, select NAT on Network type














2) In Redhat, type the command:  [root@localhost ~]# service network restart


Creating of  Oracle VM Virtual Box version 6.18

Click on machine---->New------> Type Name eg Window Server 2019-->choose the version  then click next
Memory Size [e.g. 2048]
Hard Disk: Create a hard Disk now...>Virtual box disk 

Installation of Bootable Windows


No bootable Medium found ! system halted
For ISO
solution: setting:bootable optical in 1st order