Oracle Database Experts

date
export ORACLE_SID=infra
export ORAENV_ASK=NO
. oraenv
echo “startup;” |sqlplus / as sysdba

lsnrctl start

cd $ORACLE_HOME/opmn/bin
./opmnctl startall

# — Switch home to apps and startup the apps
export ORACLE_SID=apps
export ORAENV_ASK=NO
. oraenv

sudo /sbin/service sendmail stop
cd $ORACLE_HOME/opmn/bin
./opmnctl startall

cd $ORACLE_HOME/ocas/bin
./ocasctl -status
./ocasctl -start
./ocasctl -start -t ochecklet
./ocasctl -status

date

#—————————————————————–#
#- Simple script to bounce the application tier of OCS
#- This script accepts one parameter: start or stop
#—————————————————————–#

date
export MODE=$1
# — Switch home to apps and startup the apps
export ORACLE_SID=apps
export ORAENV_ASK=NO
. oraenv

if [ "$MODE" = "start" ]; then
sudo /sbin/service sendmail stop
cd $ORACLE_HOME/opmn/bin
./opmnctl startall

cd $ORACLE_HOME/ocas/bin
./ocasctl -status
./ocasctl -start
./ocasctl -start -t ochecklet
./ocasctl -status

elif [ "$MODE" = "stop" ]; then
cd $ORACLE_HOME/opmn/bin
./opmnctl stopall
cd $ORACLE_HOME/ocas/bin
./ocasctl -stopall

fi

date

#—————————————————————–#

Posted by: Charles Kim @ DBAExpert.com

Kernel Parameters in /etc/sysctl.conf< /STRONG >

kernel.shmall = 3279547
kernel.shmmax = 2147483648
kernel.shmmni = 4096
#semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 1024 65000
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

To reload the kernel:
sysctl -p

RPM Requirements

glibc-2.3.4-2.9
make-3.79
binutils-2.15.92.0.2-13
gcc-3.4.3-22.1
libaio-0.3.96
glibgc-common-2.3.4-2.9
setarch-1.6-1
pdksh-5.2.14-30
openmotif21-2.1.30-11
sysstat-5.0.5-1
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++devel-3.4.3-22.1
compat-libstdc++-296-2.96-
compat-db-4.1.25-9
control-center-2.8.0-12
xscreensaver-4.18-5.rhel4.2

Posted by Charles Kim @ DBAExpert.com