Oracle Apps DBA Health Checkup and performance scripts Part 1 OMPN process check in R12

The following scripts is a useful script to check the opmn status of oracle apps R12 server at once. This is a handy script to check the status in one shot. Here I am checking the opmn status of $ADMIN_SCRIPTS_HOME. Alternatively

you can check the form or web opmn separately.

Save the following code in a shell script named as “opmnStatus.sh”


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

##################################################################################
# Script Name : opmn_status.sh #
# Purpose : Script to check the OPMN status. A handy script to check the #
# status in one shot. #
# Author : Oracle.is.here # #
##################################################################################

cd <output log dir>;
sh <ADMIN_SCRIPTS_HOME>/adopmnctl.sh status > <output log dir>/adopmnctl.txt
echo ""
cat adopmnctl.txt|tail +7|head -1|sed 's/+/|/g'|nawk -F "|" '{printf ("%-25s %-8s \n", $2, $4)}'|\
awk '{print FNR "\t\t\t" $0}'
cat adopmnctl.txt|tail +8|head -1|sed 's/+/|/g'|nawk -F "|" '{printf ("%-25s %-8s \n", $2, $4)}'|\
awk '{print FNR "\t\t\t" $0}'
cat adopmnctl.txt|tail +9|head -1|sed 's/+/|/g'|nawk -F "|" '{printf ("%-25s %-8s \n", $2, $4)}'|\
awk '{print FNR "\t\t\t" $0}'
cat adopmnctl.txt|tail +10|head -6|sed 's/+/|/g'|nawk -F "|" '{printf ("%-25s %-8s \n", $2, $4)}'|\
awk '{print FNR "\t\t\t" $0}'
cat adopmnctl.txt|tail +7|head -1|sed 's/+/|/g'|nawk -F "|" '{printf ("%-25s %-8s \n", $2, $4)}'|\
awk '{print FNR "\t\t\t" $0}'
echo ""
echo "Please see the 'Status' column and take necessary actions accordingly."
rm <output log dir>/adopmnctl.txt



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


The output of the above script will be as follows ->

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


-------------------- ---------
process-type status
-------------------- ---------
OC4J:oafm Alive
OC4J:forms Alive
OC4J:oacore Alive
HTTP_Server Alive


-------------------- ---------

Please see the 'Status' column and take necessary actions accordingly.

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






No comments :