- 论坛徽章:
- 0
|
下面这段shell是目的是: 想如果有输出的话,就发mail,可以明明有输出,就是不发mail出来 ??也没有报错
查了半天还是没查出原因,高手帮忙看看,thanks in advance !!
[oracle@test monitor]$ more ck_invalid_object.sh
#####################################################################
## ck_invalid_object.sh ##
#####################################################################
#!/bin/ksh . /etc/oracle.profile
DBALIST=xxx@163.com,xxx@yahoo.com; export DBALIST
source /home/oracle/.bash_profile
sqlplus -s "/as sysdba" <<EOF
set feed off
set linesize 120
--set heading off
col object_name format a30
col owner format a15
spool invalid_object.alert
SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS
FROM DBA_OBJECTS WHERE STATUS='INVALID' ORDER BY OWNER,OBJECT_TYPE,OBJECT_NAME;
spool off
exit;
EOF
#!
if [ `cat invalid_object.alert|wc -l` -gt 0 ]
then
mailx -s "INVALID OBJECTS for $ORACLE_SID" $DBALIST < invalid_object.alert
fi
[oracle@test monitor]$ sh ck_invalid_object.sh
OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- ------------------------------ ------------------- -------
SCOTT VW1 VIEW INVALID
SCOTT VW2 VIEW INVALID
[oracle@test monitor]$ |
|