Shell Programming and Scripting

#!/bin/ksh
set ORACLE_HOME=/oracle/product/10.2/bin
export ORACLE_HOME
LOGON=`cat apps/int/ctrl/orcl_schema.txt`
HOSTNAME=`hostname -s`
# check for hostname entry in INFA_PROCESS table
`sqlplus -s $LOGON << EOF
SET SERVEROUT ON
SET FEEDBACK OFF
SET HEADING OFF
SET TIMING OFF
SET TERMOUT OFF
SET LINES 160
DECLARE
 v_host_name    VARCHAR2(30);
BEGIN
    SELECT host_name
    INTO   v_host_name
    FROM INFA_PROCESS
    WHERE host_name = '${HOSTNAME}';
END;
/
SET SERVEROUT OFF
exit
EOF`
echo $RC
RC=$?
if [ $RC -eq 0 ] ; then
        echo "Successfully selected the entry for ${HOSTNAME}in INFA_PROCESS table."
  else
        exit 1
 fi

 # Query INFA_PROCESS table for previous values of PMSERVER_PRC_ID and DOMAIN_PRC_ID in INFA_PROCESS table.
 eval `sqlplus -s $LOGON << !
 SET FEEDBACK OFF
 SET HEADING OFF
 SET TIMING OFF
 SET TERMOUT OFF
 SET LINES 160
 SELECT 'export prev_PMSERVER_PRC_ID="' || PMSERVER_PRC_ID || '";' FROM INFA_PROCESS WHERE HOST_NAME = '${HOSTNAME}'
 UNION
 SELECT 'export prev_DOMAIN_PRC_ID="' || NVL(DOMAIN_PRC_ID,0) || '";' FROM INFA_PROCESS WHERE HOST_NAME = '${HOSTNAME}';
 !`

     #RC=$?
     #       if [ $RC -ne 0 ] ; then
     #           echo "$0: ERROR! while retrieving the previous PMSERVER_PRC_ID and DOMAIN_PRC_ID for ${HOSTNAME}."
     #          exit 1
     #       fi
 echo "Previous PMSERV PRC ID="$prev_PMSERVER_PRC_ID
 if [$prev_PMSERVER_PRC_ID -eq 0 -o $prev_DOMAIN_PRC_ID -eq 0]; then

 PMSERVER_PRC_ID=`ps -fu inform | grep 'pmserver' |sed -n '1p'|awk '{print $2}'`
 DOMAIN_PRC_ID=`ps -fu inform | grep 'domain' |sed -n '1p'|awk '{print $2}'`
 echo " PMSERVER_PRC_ID= "$PMSERVER_PRC_ID
 eval `sqlplus -s $LOGON << !
  SET FEEDBACK OFF
  SET HEADING OFF
  SET FEEDBACK OFF
  SET HEADING OFF
  SET TIMING OFF
  SET TERMOUT OFF
  SET LINES 160
  UPDATE INFA_PROCESS SET PMSERVER_PRC_ID = '${PMSERVER_PRC_ID}', DOMAIN_PRC_ID = '${DOMAIN_PRC_ID}' WHERE HOST_NAME = '${HOSTNAME}';
  SET SERVEROUT OFF
  exit
  EOF`
  echo $RC
  RC=$?
  if [ $RC -eq 0 ] ; then
          echo "Successfully updated PMSERVER_PRC_ID and DOMAIN_PRC_ID for ${HOSTNAME} in INFA_PROCESS table."
    else
          exit 1
  fi
 else
    if [ $prev_PMSERVER_PRC_ID -ne $PMSERVER_PRC_ID -o $prev_DOMAIN_PRC_ID -ne $DOMAIN_PRC_ID -a ! -e /apps/int/scripts/file_watch.txt]
          touch /apps/int/scripts/file_watch.txt
          uuencode server_mon.log server_mon.log | mailx -s "FAILURE" "xxxx@domain.com"
    fi
  fi

if [ $prev_PMSERVER_PRC_ID -ne $PMSERVER_PRC_ID -o $prev_DOMAIN_PRC_ID -ne $DOMAIN_PRC_ID -a ! -e /apps/informatica/scripts/file_watch.txt];then
          touch /apps/informatica/scripts/file_watch.txt

  if [ $x -eq 0 ]