cat <<-'EOF' > get_em_status.sh
#!/bin/bash
HOSTMEI=$1
BEAF=$2
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job start" | tee -a /tmp/get_em_status_$(date '+%Y%m').log
ssh ${HOSTMEI} "sudo su - oracle -c '/u01/app/oracle/product/18.0.0/dbhome_1/bin/sqlplus -S sys/system@${HOSTMEI}:1521/empdbrepos as sysdba <<-'\"'EOF'\"'
set tab off
set lines 1000
set pages 0
set markup csv on quote on
SELECT TARGET_NAME, TARGET_TYPE, AVAILABILITY_STATUS_CODE , AVAILABILITY_STATUS
FROM sysman.MGMT\$AVAILABILITY_CURRENT
order by TARGET_NAME, TARGET_TYPE, AVAILABILITY_STATUS_CODE , AVAILABILITY_STATUS
;
EOF'" > /tmp/get_em_status_${BEAF}.tmp
RET=$?
if [ ${RET} -ne 0 ] ; then
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job error( ${RET} )" | tee -a /tmp/get_em_status_$(date '+%Y%m').log
exit 100
fi
echo "[$(date '+%Y/%m/%d %H:%M:%S')] job end" | tee -a /tmp/get_em_status_$(date '+%Y%m').log
exit 0
EOF
cat get_em_status.sh
chmod +x get_em_status.sh
./get_em_status.sh mmm114 before
./get_em_status.sh mmm114 after
cat /tmp/get_em_status_$(date '+%Y%m').log
cat /tmp/get_em_status_before.tmp
cat /tmp/get_em_status_after.tmp
