#!/bin/sh

cat <  /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=DB
EOF

hostname DB

cat <  /etc/hosts
127.0.0.1    localhost localhost.localdomain localhost4 localhost4.localdomain4
::1          localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.200 DB

EOF

cat < /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
NETMASK=255.255.255.0
IPADDR=192.168.1.200
TYPE=Ethernet
EOF

chkconfig cups off
chkconfig sendmail off
service cups stop
service sendmail stop
service network restart

cat < /etc/resolv.conf
nameserver 8.8.8.8
EOF

iptables -F
iptables -X
iptables -Z
service iptable save
service iptable restart
setenforce  0

mount -o loop /dev/cdrom  /mnt

rm -rf /etc/yum.repos.d/*

cat < /etc/yum.repos.d/base.repo
[Base]
name=base
baseurl=file:///mnt/Server
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
EOF

yum -y install  binutils-* \
compat-db-* \
control-center-* \
gcc-* \
gcc-c++-* \
glibc-* \
libXp-* \
libstdc++-* \
libstdc++-devel-* \
make-* \
openmotif-* \
termcap* \
readline* \
libtermcap-devel* \
readline-devel* \
sysstat* \
wget

cd /tmp

unzip oracle10g_database_linux32.zip

rm -rf oracle10g_database_linux32.zip

groupadd oinstall  

groupadd dba

useradd -g oinstall -G dba oracle

echo "oracle" | passwd --stdin oracle

 mkdir -p /oracle/app
 
 chmod 777 /oracle
 
 chown -R oracle.oinstall /oracle
 

echo "kernel.sem = 250 32000 100 128" >>/etc/sysctl.conf

echo "fs.file-max = 65536" >>/etc/sysctl.conf

echo "net.ipv4.ip_local_port_range = 1024 65000" >>/etc/sysctl.conf

echo "net.core.rmem_default = 262144" >>/etc/sysctl.conf

echo "net.core.rmem_max = 262144" >>/etc/sysctl.conf

echo "net.core.wmem_default = 262144" >>/etc/sysctl.conf

echo "net.core.wmem_max = 262144" >>/etc/sysctl.conf

echo "" >/etc/redhat-release

echo "Red Hat Enterprise Linux Server release 3 (Tikanga)" > /etc/redhat-release

/sbin/sysctl -p

echo "oracle          soft    nproc           2047" >>/etc/security/limits.conf

echo "oracle          hard    nproc           16384" >>/etc/security/limits.conf

echo "oracle          soft    nofile          1024" >>/etc/security/limits.conf

echo "oracle          hard    nofile          65536" >>/etc/security/limits.conf

echo "session    required     /lib/security/pam_limits.so" >>/etc/pam.d/login

echo "stty erase ^H" >>/home/oracle/.bash_profile

echo "ORACLE_BASE=/oracle/app" >>/home/oracle/.bash_profile

echo "ORACLE_HOME=\$ORACLE_BASE/oracle/product/10.2.0/db_1" >>/home/oracle/.bash_profile

echo "ORACLE_SID=ecom" >>/home/oracle/.bash_profile

echo "PATH=\$PATH:\$HOME/bin:\$ORACLE_HOME/bin" >>/home/oracle/.bash_profile

echo "LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/usr/lib" >>/home/oracle/.bash_profile

echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" >>/home/oracle/.bash_profile

echo "export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH NLS_LANG" >>/home/oracle/.bash_profile