菜鸟－监控数据表空间脚本的疑惑～～～，请高手赐教！

nodream2008

我分析是在进入sqlplus之后脚本把spool命令当成了系统命令所以找不到这个命令，是不是和环境变量有关呢？

一梦如是

没写here文档的起始标记

awk就是awp加ak

try

#!/bin/sh
export ORACLE_HOME=`grep "^*" /etc/oratab |cut -f2 -d:`
export PATH=$ORACLE_HOME/binPATH
export LD_LIBRARY_PATH=$ORACLE_HOME/libORACLE_HOME/rdbms/libLD_LIBRARY_PATH

v_LoginInfo=scott/tiger@orcl

#Run sqlplus
sqlplus ${v_LoginInfo} <<SQL_BLOCK > /dev/null

spool test.dat
select * from emp;

quit
SQL_BLOCK

nodream2008

非常感谢各位的帮助，现在问题已经解决了，我将代码贴出来一起分享。还请高手帮看一下还存在什么错误。谢谢～～～～～

1. 
   
2. #####################################################################
   
3. ## ck_tbsp.sh ##
   
4. #####################################################################
   
5. #!/bin/ksh
   
6. 
   
7. v_LoginInfo=oracle/oracle@db1
   
8. v_AlertFilePath=/templv/chusb/tablespace.alert
   
9. 
   
10. #Run sqlplus
    
11. 
    
12. sqlplus -s ${v_LoginInfo} > /dev/null   << END
    
13. 
    
14. set feed off
    
15. set termout off
    
16. set feedback off
    
17. set linesize 100
    
18. set pagesize 200
    
19. spool $v_AlertFilePath
    
20. SELECT F.TABLESPACE_NAME,
    
21. TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USED(MB)",
    
22. TO_CHAR (F.FREE_SPACE, '999,999') "FREE(MB)",
    
23. TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTAL(MB)",
    
24. TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' FREE
    
25. FROM (
    
26. SELECT TABLESPACE_NAME,
    
27. ROUND (SUM (BLOCKS*(SELECT VALUE/1024
    
28. FROM V\$PARAMETER
    
29. WHERE NAME = 'db_block_size')/1024)
    
30. ) FREE_SPACE
    
31. FROM DBA_FREE_SPACE
    
32. GROUP BY TABLESPACE_NAME
    
33. ) F,
    
34. (
    
35. SELECT TABLESPACE_NAME,
    
36. ROUND (SUM (BYTES/1048576)) TOTAL_SPACE
    
37. FROM DBA_DATA_FILES
    
38. GROUP BY TABLESPACE_NAME
    
39. ) T
    
40. WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
    
41. AND (ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)) < 90;
    
42. spool off
    
43. 
    
44. exit
    
45. !
    
46. END
    
47. 
    
48. 
    
49. if [ `cat tablespace.alert|wc -l` -gt 0 ]
    
50. then
    
51. cat tablespace.alert -l tablespace.alert > tablespace.tmp
    
52. mailx -s "TABLESPACE ALERT for ${2}" $DBALIST < tablespace.tmp
    
53. fi
    
54. 
    
55. 
    

复制代码