Oracle Install Tips

Oracle Install Tips - 10g on RHEL5

 

Install requisite packages

yum -y install setarch-2*

yum -y install make-3*
yum -y install glibc-2*
yum -y install libaio-0*
yum -y install compat-libstdc++-33-3*
yum -y install compat-gcc-34-3*
yum -y install compat-gcc-34-c++-3*
yum -y install gcc-4*
yum -y install libXp-1*
yum -y install openmotif-2*
yum -y install compat-db-4*

Update /etc/hosts with correct servername

        10.1.4.200     oracle.sysxperts.com oracle

 

Update /etc/security/limits.conf

oracle soft nproc 15360

oracle hard  nproc  16384
oracle soft  nofile 64512
oracle hard  nofile 65536

Create users and groups

groupadd dba
useradd -g dba oracle; echo "mypass" |passwd --stdin oracle

Create directories and chown for oracle

 mkdir -p /u01/app/oracle/product/10.2.0/db_1

 chown -R oracle.dba /u01

Make sure SELINUX is disabled in /etc/selinux/config and reboot if it was enabled:

            SELINUX=disabled

 

Update /etc/sysctl.conf with:

# Controls the maximum shared segment size, in bytes  - see kernel and hugepages info

kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 4294967296

kernel.sem = 250 32000 100 128

fs.file-max = 104032

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 1048576

net.core.rmem_max = 1048576

net.core.wmem_default = 262144

net.core.wmem_max = 262144

 

run sysctl -p  #activates new kernel parameters  

To mount an NFS share for backups:

nas.sysxperts.com:/Archive    /archive_fs     nfs     hard,nolock,vers=3,proto=tcp,bg,rsize=32768,wsize=32768,timeo=600,intr 0 0

nas.sysxperts.com:/Brchive    /backup_fs     nfs     hard,nolock,vers=3,proto=tcp,bg,rsize=32768,wsize=32768,timeo=600,intr 0 0

 

 

Edit the oracle users ~/.bash_profile 

# 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=TEST; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
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 

 

Start vncserver with (install with yum -y install vnc-server if necessary):

    vncserver

    vncpasswd

 

Establish vnc session and run xhost + as root

 

Extract cpio with:

cpio -idmv < 10201_database_linux_x86_64.cpio

 

cd to directory where cpio command was run

 

./database/runInstaller

 

download latest patch and unzip

./Disk1/runInstaller

 

To uninstall run the deinstaller from the latest patch Disk1/runInstaller

 

Edit /etc/oratab and set restart flag for TEST instance

    TEST:/u01/app/oracle/product/10.2.0/db_1:Y

sar and dstat is useful for stats on server - yum -y install sysstat dstat

ls -lattr /var/log/sa  and choose the filename with the date you want to see stats for then

    sar -A /var/log/sa/saXX

man sar and dstat are your friends

 

See oracle automated startup for init setup