Friday, April 13, 2007

#Script to monitor the status of Oracle Application Server 10g Components.

#------------------------------------------------------------------
#---------------For Infra declaration------------------------------
#------------------------------------------------------------------
export STAGE_PATH=/software/stage
export INFRA_INSTANCE=orainfra.linuxhost.domain.com
export BIF_INSTANCE=orabif.linuxhost.domain.com
export ORACLE_BASE=/software/oracle
export ORACLE_HOME=/software/oracle/orainfra
export ORACLE_SID=iasdb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export DISPLAY=linuxhost.domain.com:3.0
xhost +
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin
export PATH
clear
echo "========================"
echo "LINUXHOST.DOMAIN.COM"
echo "========================"
echo ""
echo ""
echo ""
echo ""
read
echo "========================="
echo "LISTENER STATUS"
echo "========================="
cd $ORACLE_HOME/bin
lsnrctl status
echo ""
echo ""
read
echo ""
echo ""
echo ""
echo "==============="
echo "DATABASE STATUS"
echo "==============="
var1=`sqlplus -silent "/as sysdba"<<"EOF1"
column "DATABASE NAME" format a15
column "DATABASE STATE" format a15
select name "DATABASE NAME", open_mode "DATABASE STATE",to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "STARTUP_TIME" from v\$database , v\$instance;
exit;
"EOF1"`
IFS="/n"
echo $var1
echo ""
echo ""
read
echo ""
echo ""
echo "=========================================================="
echo "Enterprise Manager ----" $INFRA_INSTANCE
echo "=========================================================="
emctl status iasconsole
echo ""
echo ""
read
cd $ORACLE_HOME/opmn/bin
echo ""
echo ""
echo "=========================================================="
echo "Infra Components ----" $INFRA_INSTANCE
echo "=========================================================="
opmnctl status
echo ""
echo ""
read
#------------------------------------------------------------------
#---------------For BIF declaration------------------------------
#------------------------------------------------------------------

export ORACLE_BASE=/software/oracle
export ORACLE_HOME=/software/oracle/orabif
export ORACLE_SID=iasdb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export DISPLAY=linuxhost.domain.com:3.0

PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin
export PATH
cd $ORACLE_HOME/bin
echo ""
echo ""
echo "=========================================================="
echo "Enterprise Manager ----" $BIF_INSTANCE
echo "=========================================================="
emctl status iasconsole
echo ""
echo ""
read
cd $ORACLE_HOME/opmn/bin
echo ""
echo ""
echo "=========================================================="
echo "BIF Components ----" $BIF_INSTANCE
echo "=========================================================="
opmnctl status
echo ""
echo ""
read
echo ""
echo ""
echo "=========================================================="
echo "DISK SPACE INFORMATION"
echo "=========================================================="
df -kh
echo ""
echo ""
read
echo "*******************************************************************"
echo " END OF MONITORING "
echo "*******************************************************************"

Labels:

0 Comments:

Post a Comment

<< Home