====== Oracle ======
<note important>This article need editing and rewriting!</note>

===== 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 (http://docs.google.com/View?docid=dfxjbxcc_155dbzfvtg8)

++++++++++++++++++++++++++

Oracle 10g/11g  Automated Startup and Shutdown on RedHat 
Create file /etc/init.d/oracle with following code and change file to be executable
 
#!/bin/sh
# chkconfig: 345 99 01
# description: Oracle
#
#
ORACLE=oracle
case $1 in
'start')
        cat <<-"EOF"|su - ${ORACLE}
        # Start Oracle Net
        if [ -f ${ORACLE_HOME}/bin/tnslsnr ] ;
        then
                echo "starting Oracle Net Listener"
                ${ORACLE_HOME}/bin/lsnrctl start
        fi
        echo "Starting Oracle databases"
        ${ORACLE_HOME}/bin/dbstart
        ${ORACLE_HOME}/bin/emctl start dbconsole
EOF
        ;;
'stop')
        cat <<-"EOF"|su - ${ORACLE}
        echo "shutting down dbconsole"
        ${ORACLE_HOME}/bin/emctl stop dbconsole
        # Stop Oracle Net
        if [ -f ${ORACLE_HOME}/bin/tnslsnr ] ;
        then
                echo "stopping Oracle Net Listener"
                ${ORACLE_HOME}/bin/lsnrctl stop
        fi
        echo "stopping Oracle databases"
        ${ORACLE_HOME}/bin/dbshut
EOF
        ;;
*)
        echo "usage: $0 {start|stop}"
        exit
        ;;
esac
#
exit
 
Run:
chkconfig oracle on
 
Update the oracle user .bash_profile as follows:
export ORACLE=oracle
export ORACLE_SID=`cat /etc/oratab |sed -e 's/:.*' -e 's/#.*' -e '/^$/d'|head -1`
export PATH=$PATH:/usr/local/bin
export ORAENV_ASK="NO"
. /usr/local/bin/oraenv
 
Update /etc/oratab with your instances
orcl:/u01/oracle/product/11.1.0/db_1:Y
orcltest:/u01/oracle/product/11.1.0/db_1:Y

Alternatively if you want to use your own start scripts you could do the following (BUT WHY?):
 
Create an /etc/init.d/oracle script with:
#!/bin/sh
#
#oracle agent init script
#chkconfig: 2345 97 05
#description: oracle
# Source function library.
if [ -f /etc/init.d/functions ] ; then
        . /etc/init.d/functions
elif [ -f /etc/rc.d/init.d/functions ] ; then
        . /etc/rc.d/init.d/functions
else
        exit 0
fi
prog=oracle
ORAHOME=/oracle/home/scripts
AGENT_USER=oracle
email=pvalentino@sysxperts.com
start () {
        echo -n $"Starting $prog: "
        # start daemon
        if [ -e "/tmp/orastat" ]
        then
        su - ${AGENT_USER} -c "cd ${ORAHOME}; ./orastart"
        rm -rf /tmp/orastat
        else
        mail -s "`hostname` orastart failed" $email < /tmp/stat
        fi
        RETVAL=$?
        echo
        [ $RETVAL = 0 ] && touch /var/lock/subsys/oracle
        return $RETVAL
}
stop () {
        # stop daemon
        echo -n $"Stopping $prog: "
        su - ${AGENT_USER} -c "cd ${ORAHOME};./orastop"
        RETVAL=$?
        if  "$RETVAL" = 0  ;then touch /tmp/orastat;else mail -s "`hostname` orastop failed" $email < /tmp/stat;fi
        echo
        [ $RETVAL = 0 ] && touch /var/lock/subsys/oracle
        return $RETVAL
}
restart() {
        stop
        start
}
case $1 in
        start)
                start
        ;;
        stop)
                stop
        ;;
        restart|reload)
                restart
        ;;
        condrestart)
                [ -f /var/lock/subsys/ora ] && restart || :
        ;;
        *)
        echo $"Usage: $prog {start|stop|restart|condrestart|reload }"
        exit 1
esac
exit $RETVAL

And your orastart and orastop scripts would have all of the startup procedures you would like to run in a custom fashion i.e.
 
orastart:
. /home/oracle/scripts/orastart_TEST
lsnrctl start
#
mail -s "**** TEST databases started ***" _DBA@sysxperts.com < /home/oracle/scripts/orastart
 
 
orastart_TEST:
. /home/oracle/ora10.env
############# This will start Oracle in TEST ######################
export ORACLE_SID=TEST
sqlplus '/ as sysdba' <<EOF
startup
EOF
#