yum install binutils compat-db control-center gcc gcc-c++ \
glibc glibc-common gnome-libs libstdc++ libstdc++-devel \
make pdksh sysstat xscreensaver libaio libaio-devel libXp \
compat-gcc-34-c++ compat-gcc-34 glibc-devel compat-libstdc++-33 \
compat-glibc compat-glibc-headers \
compat-gcc-34-c++ compat-gcc-34
/etc/hosts
# Do not remove the following line, or various programs
# # that require network functionality will fail.
172.16.5.235 eng-oradb-01.ibsinterprit.com eng-oradb-01
127.0.0.1 localhost.localdomain localhost
172.16.5.234 eng-oradb-01a.ibsinterprit.com eng-oradb-01a
172.16.5.236 eng-oradb-02a.ibsinterprit.com eng-oradb-02a
172.16.5.237 eng-oradb-02.ibsinterprit.com eng-oradb-02
10.10.10.1 i-eng-oradb-01.ibsinterprit.com i-eng-oradb-01
10.10.10.2 i-eng-oradb-02.ibsinterprit.com i-eng-oradb-02
/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
/etc/pam.d/login
session required pam_limits.so
/etc/sysctl.conf
# Oracle recommended
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
/etc/profile
# Oracle
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
groupadd -g 500 dba
groupadd -g 501 oracle
# Make sure that the default group for oracle is the group that is specified
during installation, or you will experience tons of fun.G
useradd -c "Oracle" -d /home/oracle -g 500 -G 501 -m -s /bin/bash -u 500 oracle
passwd oracle
mkdir -p /mnt/eng-oradb-01a
mkdir -p /mnt/eng-oradb-02a
mkdir -p /mnt/b
mkdir -p /mnt/a
/etc/fstab
/dev/md2 / ext3 defaults 1 1
/dev/md0 /boot ext3 defaults 1 2
devpts /dev/pts devpts gid=5,mode=620 0 0
tmpfs /dev/shm tmpfs defaults 0 0
proc /proc proc defaults 0 0
sysfs /sys sysfs defaults 0 0
/dev/md1 swap swap defaults 0 0
/dev/sdd1 /mnt/eng-oradb-01a ext3 defaults 0 0
/dev/sde1 /mnt/a ext3 defaults 0 0
#/dev/sdc1 /mnt/eng-oradb-02a ext3 defaults 0 0
#/dev/sdf1 /mnt/b ext3 defaults 0 0
fdisk /dev/sdc
fdisk /dev/sdd
fdisk /dev/sdf
fdisk /dev/sde
mkfs -t ext3 /dev/sdd1
mkfs -t ext3 /dev/sde1
mkfs -t ext3 /dev/sdf1
mkfs -t ext3 /dev/sdc1
mount -a
Error Recovery
If a file system in /etc/fstab is bad and the server fails to boot
When you give your root-passwd and type the next command:
# mount -t ext3 -o remount,rw /
# # init 5
#
OFA
mkdir -p /mnt/eng-oradb-01a/oracle
chown oracle:dba /mnt/eng-oradb-01a/oracle
chmod 2775 /mnt/eng-oradb-01a/oracle
mkdir -p /mnt/eng-oradb-02a/oracle
chown oracle:dba /mnt/eng-oradb-02a/oracle
chmod 2775 /mnt/eng-oradb-02a/oracle
Install Oracle
~oracle/install/database/runInstaller -ignoreSysPrereqs &
Patch Oracle
~oracle/patch/Disk1/runInstaller -ignoreSysPrereqs &
iSQL*Plus URL:
http://eng-oradb-01.ibsinterprit.com:5560/isqlplus
iSQL*Plus DBA URL:
http://eng-oradb-01.ibsinterprit.com:5560/isqlplus/dba
http://eng-oradb-01.ibsinterprit.com:1158/em
Redhat Cluster Service Admin
https://eng-oradb-01.ibsinterprit.com:8084
Failover: Each server Failover
[root@eng-oradb-01 failover]# pwd
/etc/failover
[root@eng-oradb-01 failover]# ls -l eng-oradb-01a/
total 56
-rwxr-xr-x 1 root root 923 May 17 15:09 fs
-rwxr-xr-x 1 root root 975 May 15 18:22 ip
-rwxr-xr-x 1 root root 1265 May 17 19:24 node
-rw-r--r-- 1 root root 554 May 17 19:28 node.conf
-rwxr-xr-x 1 root root 1330 May 17 19:22 oracle
-rwxr-xr-x 1 root root 1301 May 17 19:21 oracleem
-rwxr-xr-x 1 root root 1297 May 17 19:30 oraclelsnr
To start:
cd /etc/failover/eng-oradb-01a
/node start
You can also start services individually:
cd /etc/failover/eng-oradb-01a
/fs start
/ip start
/oracle start
/oraclelsnr start
/oracleem start
NOTE: if you cannot umount the file system run the following
fuser -u -m /mnt/eng-oradb-01a
This lists user processes that are using files in the file system that you are
attempting to umount. Run this to kill the user processes, but be careful. Be
sure to shutdown oracle gracefully first!
fuser -k -m /mnt/eng-oradb-01a
