OATC - "Oracle Applications and Technology Consulting": July 2017

whatsup121 -- whats up 12.1 -- What E-Business Suite 12.1 Services are UP/Running

Example: AppsTier 11i/12.1 Services are UP. DBTier Services are UP.

oratest.oatcinc.com Apps-11i/12.1 Survey

A p p l i c a t i o n D a t a b a s e

S e r v i c e s S e r v i c e s

-- Apache -- App App 11g 11g

Apps Frm Svr Svr Svr JRE DB Cnc DB Ora WF-Java WF-Java

SIDs Svr iAS PLS 920 Svr Lnr Mgr Lsr DB Server AgntLst

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

oatc Yes Yes Yes Yes Yes Yes Yes Yes Yes Running Running

Current Activity

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

Forms-Connections: 9

ConcReqs Running: 2

Daily Activity

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

Web-AppsLocalLogin Today: 20

Example: AppsTier 11i/12.1 Services are DOWN. DBTier Services are UP.

oratest.oatcinc.com Apps-11i/12.1 Survey

A p p l i c a t i o n D a t a b a s e

S e r v i c e s S e r v i c e s

-- Apache -- App App 11g 11g

Apps Frm Svr Svr Svr JRE DB Cnc DB Ora WF-Java WF-Java

SIDs Svr iAS PLS 920 Svr Lnr Mgr Lsr DB Server AgntLst

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

oatc No No No No No No No Yes Yes Running Running

#!/bin/ksh

# whatsup ()

#------------------------------------------------------------------------------#

# Module Name: whatsup #

# #

# Purpose: Report on the NCA Environment Oracle Applications 11i/12: #

# Database, Database-Listener Apps-Listener, ConcManager, #

# FormsWeb-Listener, Forms-Listener, Reports-Listener, #

# TCF-Listener, Metric-Data-Listener, Metric-Req-Listener, #

# and Other Information. #

# #

# Maintenance #

# Date Author Description #

# ----------- ------------ -------------------------------------------- #

# 10-Oct-2009 M.Barone Module design/creation #

#------------------------------------------------------------------------------#

{

DIRNAM=$(dirname $0)

ORASID=$(echo $CONTEXT_NAME | cut -f1 -d'_')

ORASRV=$(echo $CONTEXT_NAME | cut -f3 -d'_')

HNAME=$(uname -n)

clear

echo

echo " #--------------------------------------------------------#"

echo " # whatsup: Oracle Apps Services/Processes (Executing) #"

echo " #--------------------------------------------------------#"

echo

#------------------------------------------------------------------#

# Trap: Set CNTL-C CNTL-D CNTL-\ Before Password Protection #

#------------------------------------------------------------------#

trap "stty echo; return" 2

trap "stty echo; return" 3

stty -echo

read PASSWD?" Please Enter the Oracle APPS Passwd: "

stty echo

echo

#------------------------------------------------------------------#

# Trap: Reset CNTL-C CNTL-D CNTL-\ After Password Protection #

#------------------------------------------------------------------#

trap 2

trap 3

clear

ORANAM=${ORASID}

ORALST=${ORASID}

#-----------------------------------------------------------------------------#

#- Initializing -#

#-----------------------------------------------------------------------------#

echo

echo " $HNAME Apps-11i Survey "

echo

echo " A p p l i c a t i o n ConcManager D a t a b a s e"

echo " S e r v i c e s Services S e r v i c e s"

echo " -- Apache -- App App 11g 11g"

echo " Apps Frm Svr Svr Svr OPM App DB Cnc DB Ora WF-Java WF-Java"

echo " SIDs Svr iAS PLS 10g Svr Lnr Lnr Mgr Lsr DB Server AgntLst"

echo " -------- --- --- --- --- --- --- --- --- --- --- ------- -------"

#-------------------------------------------------------------------------#

#- LOOP -#

#-------------------------------------------------------------------------#

for ORASID in $(echo $ORALST)

#---------------------------------------------------------------------#

#- Initialize LOOP Variables -#

#---------------------------------------------------------------------#

typeset APPSID=$(echo "${ORASID}")

ORASIDLOWER=$(echo $ORASID | \

sed 'y/ABCDEFGHIJKLMNOPQRSTUVWXYZ/abcdefghijklmnopqrstuvwxyz/')

#----------------------------------------------------------------------#

# SHELL: Variables #

#----------------------------------------------------------------------#

#---------------------------------------------------------------------#

#- Running Processes for FORMWEB Server -#

#---------------------------------------------------------------------#

FRMIND=$(ps -efa | grep -v grep | grep $ORASIDLOWER | grep -c form)

if [[ $FRMIND -gt 0 ]]

then

typeset FRMSVR="Yes"

else

typeset FRMSVR="No "

#---------------------------------------------------------------------#

#- Running Processes for FORMWEB Server -#

#---------------------------------------------------------------------#

FRMIND=$(ps -efa | grep -v grep | grep $ORASIDLOWER | grep -c frmweb)

if [[ $FRMIND -gt 0 ]]

then

typeset -i FRMCNT=${FRMIND}

typeset -i FRMWEB=$FRMCNT

else

typeset -i FRMWEB=$FRMIND

#---------------------------------------------------------------------#

#- Running Processes for Apache iAS HTTP WebServer -#

#---------------------------------------------------------------------#

APAIND=$(ps -efa | grep -v grep | grep $ORASIDLOWER | grep Apache | \

grep -c http)

if [[ $APAIND -gt 0 ]]

then

typeset APAIAS="Yes"

else

typeset APAIAS="No "

#---------------------------------------------------------------------#

#- Running Processes for Apache iAS RotateLogs WebServer -#

#---------------------------------------------------------------------#

APAIND=$(ps -efa | grep -v grep | grep $ORASIDLOWER | grep Apache | \

grep -c rotatelogs)

if [[ $APAIND -gt 0 ]]

then

typeset APAPLS="Yes"

else

typeset APAPLS="No "

#---------------------------------------------------------------------#

#- Running Processes for Apache 10g WebServer -#

#---------------------------------------------------------------------#

APAIND=$(ps -efa | grep -v grep | grep $ORASIDLOWER | grep Apache | \

grep -c http)

if [[ $APAIND -gt 0 ]]

then

typeset APA10g="Yes"

else

typeset APA10g="No "

#---------------------------------------------------------------------#

#- Running Processes for (OPM) Java Runtime Executables -#

#---------------------------------------------------------------------#

OPMIND=$(ps -efa | grep opmn | grep -v grep | grep -ic $ORASID)

if [[ $OPMIND -gt 0 ]]

then

typeset OPMSVR="Yes"

else

typeset OPMSVR="No "

#---------------------------------------------------------------------#

#- Running Processes for Database LSNRCTL (Listener) -#

#---------------------------------------------------------------------#

LSNNAM=$(grep DB_LISTENER $CONTEXT_FILE | cut -f2 -d'>' | cut -f1 -d'<')

if [[ $LSNNAM != '' ]]

then

LSNIND=$(ps -efa | grep -i $LSNNAM | grep -v grep | grep -c $ORASIDLOWER)

if [[ $LSNIND -gt 0 ]]

then

typeset LSNDBA="Yes"

else

typeset LSNDBA="No "

else

typeset LSNDBA="No "

#---------------------------------------------------------------------#

#- Running Processes for Apps LSNRCTL (Listener) -#

#---------------------------------------------------------------------#

typeset LSNADB="No "

typeset LSNAPP="No "

LSNIND=$(ps -efa | grep -i "APPS_${ORASID}*" | grep -v grep \

| grep -c $ORASID)

if [[ $LSNIND -gt 0 ]]

then

typeset LSNADB="Yes"

typeset LSNAPP="Yes"

#---------------------------------------------------------------------#

#- Running Processes for Oracle Instance -#

#---------------------------------------------------------------------#

ORAIND=$(ps -efa | grep -v grep | grep -c ora_pmon_${ORASID})

if [[ $ORAIND -gt 0 ]]

then

typeset ORASVR="Yes"

else

typeset ORASVR="No "

#---------------------------------------------------------------------#

#- Running Processes: Concurrent Manager -#

#---------------------------------------------------------------------#

typeset APPMGR="No "

for FNDPIDS in $(ps -efa | grep FNDSM | grep -v grep | cut -c10-15)

APPIND=$(ps -efa |grep $FNDPIDS | grep -v grep | grep -i -c $ORASID)

if [[ $APPIND -gt 0 ]]

then

typeset APPMGR="Yes"

done

sqlplus -s apps/$PASSWD > /dev/null <<-ENDFILE

set heading off

set feedback off

set flush off

set pause off

set space 1

set termout off

set verify off

set linesize 80

set pagesize 0

spool /tmp/whatsup.cnt

SELECT count(*)

FROM fnd_concurrent_requests

WHERE phase_code = 'R';

EXIT;

ENDFILE

if [[ -f /tmp/whatsup.cnt ]]

then

CNCREQ=$(tail -2 /tmp/whatsup.cnt | head -1)

rm /tmp/whatsup.cnt

#---------------------------------------------------------------------#

#- Processes for Oracle WorkFlow Notification Mail Server/Listener -#

#---------------------------------------------------------------------#

WFMIND=$(ps -efa | grep -v grep | grep GSMSvcComponentContainer | \

grep -c ${ORASIDLOWER})

if [[ $WFMIND -gt 2 ]]

then

typeset ORAWFM="Running"

typeset ORAWFL="Running"

else

typeset ORAWFM="Stopped"

typeset ORAWFL="Stopped"

sqlplus -s apps/$PASSWD > /dev/null <<-ENDFILE

set heading off

set feedback off

set flush off

set pause off

set space 1

set termout off

set verify off

set linesize 80

set pagesize 0

spool /tmp/whatsup.wfm

SELECT INITCAP(component_status)

FROM fnd_svc_components

WHERE component_name = 'Workflow Notification Mailer';

EXIT;

ENDFILE

if [[ -f /tmp/whatsup.wfm ]]

then

ORAWFM=$(tail -2 /tmp/whatsup.wfm | head -1 | cut -c1-7)

rm /tmp/whatsup.wfm

sqlplus -s apps/$PASSWD > /dev/null <<-ENDFILE

set heading off

set feedback off

set flush off

set pause off

set space 1

set termout off

set verify off

set linesize 80

set pagesize 0

spool /tmp/whatsup.wfl

SELECT INITCAP(component_status)

FROM fnd_svc_components

WHERE component_name = 'Workflow Inbound Notifications Agent Listener';

EXIT;

ENDFILE

if [[ -f /tmp/whatsup.wfl ]]

then

ORAWFL=$(tail -2 /tmp/whatsup.wfl | head -1 | cut -c1-7)

rm /tmp/whatsup.wfl

#---------------------------------------------------------------------#

#- Processes for Apache Connections -#

#---------------------------------------------------------------------#

APADIR=$IAS_ORACLE_HOME/Apache/Apache/logs/access_log

if [[ -f ${APADIR}* ]]

then

APALOG=$(ls -t $APADIR.* | head -1)

APADTE=$(date '+%d/%b/%C%y')

APAWEB=$(grep '$APADTE' $APALOG | grep -c AppsLocalLogin.jsp)

#-------------------------------------------------------------------------#

#- Print Detail Line -#

#-------------------------------------------------------------------------#

echo \

" $APPSID $FRMSVR $APAIAS $APAPLS $APA10g $OPMSVR $LSNAPP $LSNADB $APPMGR $LSNDBA $ORASVR $ORAWFM $ORAWFL "

echo

echo " Current Activity"

echo " ------------------------------"

echo " Forms-Connections: $FRMWEB"

echo " ConcReqs Running: $CNCREQ"

echo

echo " Daily Activity"

echo " ------------------------------"

echo " Web-AppsLocalLogin Today: $APAWEB"

echo

done

#-------------------------------------------------------------------------#

#- Print Blank Line -#

#-------------------------------------------------------------------------#

echo

}

Monday, July 10, 2017