shell script to check if the Workflow mailer is down in APPS R12

Introduction: We can use the following shell script and can schedule it with crontab. It is very handy, it will check the workflow mailer and if it is down it will send email to APPS DBA. Cookbook: Following is the script. #!/bin/sh ## ORACLE_HOME=`cat /etc/var/opt/oratab | grep ^TESTDB: | cut -f2 -d':'` ORACLE_HOME=/erptest/TST/db/tech_st/11.1.0 export ORACLE_HOME ORACLE_SID=ERPTEST export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin:. export PATH SCRIPT_DIR=/erptestdb/home/scripts export SCRIPT_DIR # check_ts.log $ORACLE_HOME/bin/sqlplus -s test_user/test_user <