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.

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

Other Health Check Scripts for DBA and Apps DBA

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

Oracle Apps DBA Health Checkup and performance scripts Part 2 Details Oracle Apps Auditing and performance check

Oracle Apps DBA Health Checkup and performance scripts Part 3 Apache, Form and Report log file deletion scripts in R12

Oracle DBA Health Checkup and performance scripts Part 1 Tablespace and datafile monitoring scripts

Oracle DBA Health Checkup and performance scripts Part 2 Checking the database Alert Log in automatic manner for new alert or error