DanBrother的部落格

#############################################
# Oracle10gR2 RHEL4.8 x86-64 Installation Guide
# Written by Dan Brother
#############################################

#############
# Add Groups:
#############
>>
groupadd dba
groupadd oinstall

#############
# Add User:
#############
>>
useradd oracle -g dba -G oinstall

#########################
# Change Oracle Password:
#########################
passwd oracle

################################
# Check Required RPM Packages:
################################
>>
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}  (%{ARCH})\n' \
binutils compat-db control-center gcc gcc-c++ glibc glibc-common glibc-devel \
gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio libgcc
--------------------------------------------------
binutils-2.15.92.0.2-25  (x86_64)
compat-db-4.1.25-9  (x86_64)
control-center-2.8.0-12.rhel4.5  (x86_64)
gcc-3.4.6-11  (x86_64)
gcc-c++-3.4.6-11  (x86_64)
glibc-2.3.4-2.43  (i686)
glibc-2.3.4-2.43  (x86_64)
glibc-common-2.3.4-2.43  (x86_64)
glibc-devel-2.3.4-2.43  (x86_64)
glibc-devel-2.3.4-2.43  (i386)
gnome-libs-1.4.1.2.90-44.1  (x86_64)
libstdc++-3.4.6-11  (x86_64)
libstdc++-devel-3.4.6-11  (x86_64)
make-3.80-7.EL4  (x86_64)
pdksh-5.2.14-30.6  (x86_64)
sysstat-5.0.5-25.el4  (x86_64)
xscreensaver-4.18-5.rhel4.14  (x86_64)
libaio-0.3.105-2  (i386)
libaio-0.3.105-2  (x86_64)
libgcc-3.4.6-11  (i386)
libgcc-3.4.6-11  (x86_64)
--------------------------------------------------

##########################
# Check Kernel Parameters:
##########################
>>
vi /etc/sysctl.conf

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 1

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 8192

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 8796093022208

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 1073741824
fs.file-max = 327679
kernel.msgmni = 2878
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
net.core.rmem_default = 262144
# For 11g recommended value for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# For 10g uncomment the following line, comment other entries for this parameter and re-run sysctl -p
# net.core.rmem_max=2097152
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 1024 65000
vm.swappiness = 20

###############################
# Load Settings
###############################
/sbin/sysctl -p

##############################
# Create Oracle Directories:
##############################
mkdir -p /u01/oracle/product/10.2.0/db_1
chown -R oracle:dba /u01/oracle

##############################################
# configuration file for the pam_limits module
##############################################
vi /etc/security/limits.conf
  oracle  soft    nofile  131072
  oracle  hard    nofile  131072
  oracle  soft    nproc   131072
  oracle  hard    nproc   131072
  oracle  soft    core    unlimited
  oracle  hard    core    unlimited
  oracle  soft    memlock 3500000
  oracle  hard    memlock 3500000

#####################
# Disable SELINUX
#####################
vi /etc/selinux/config
SELINUX=disabled

################
# IP Mappings
################
vi /etc/hosts
127.0.0.1              localhost.localdomain localhost
192.168.1.10           rdbms

#######################
# X-windows Settings
#######################
export DISPLAY="10.2.0.1:0"
xterm

#########################
# Install Oracle Software
#########################
su - oracle
cd /source/database
./runInstaller

#########################
# Install 10.2.0.4 Patch
#########################
su - oracle
cd /source/Disk1
./runInstaller

export PATH=/source/OPatch:$PATH
cd 9119284
opatch apply

###########################
# Post-Installation Steps:
###########################
su - oracle
vi /etc/oratab
rdbms:/u01/oracle/product/10.2.0/db_1

vi .bash_profile
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/u01/oracle
export ORACLE_SID=rdbms
export ORAENV_ASK=NO
. oraenv