自动生成ASH报告脚本

点击(此处)折叠或打开

1. ###################################################################
   
2. ## Script:genash.sh      ##
   
3. ## Date:2016-08-22 ##
   
4. ## Description:del gen ash report and sendport ##
   
5. ###################################################################
   
6. #!/bin/bash
   
7. source /home/oracle/.bash_profile
   
8. #if [ $# != 6 ]
   
9. #then
   
10. #!echo Syntax genash.sh dbid '01/30/11 11:00' duration credentials inst sid
    
11. #exit 1
    
12. #fi
    
13. 
    
14. REMOTE_HOST=10.1.1.1
    
15. REMOTE_DIR=/scripts/dbstatus/
    
16. REMOTE_USER=access_user
    
17. REMOTE_COMMAND="/scripts/sendash.py"
    
18. l_dbid=1418194933
    
19. l_start_time=`date -d '-3 hours' '+%m/%d/%y %H:%M'`
    
20. #l_starttime_log=`echo $l_start_time|sed 'sg' | sed 's/ //'|sed 's/://'`
    
21. l_duration=180
    
22. l_credentials="dba_monitor/passwd"
    
23. l_inst=1
    
24. l_sid=$6
    
25. l_logdir='/u01/script/awr'
    
26. l_ash_log_file=${l_logdir}/ashrpt.html
    
27.  
    
28. sqlplus -s $l_credentials <<EOC > /tmp/ash.log
    
29.  
    
30. set head off
    
31. set pages 0
    
32. set lines 132
    
33. set echo off
    
34. set feedback off
    
35. set termout off
    
36.  
    
37. define inst_num=${l_inst};
    
38. define dbid=${l_dbid};
    
39. define report_type='html';
    
40. define report_name=${l_ash_log_file};
    
41. define begin_time="${l_start_time}";
    
42. define duration=${l_duration};
    
43. --define target_session_id = ${l_sid};
    
44. define target_session_id = '';
    
45.  
    
46. define slot_width = '';
    
47. define target_sql_id     = '';
    
48. define target_wait_class = '';
    
49. define target_service_hash = '';
    
50. define target_module_name = '';
    
51. define target_action_name = '';
    
52. define target_client_id    = '';
    
53. define target_plsql_entry = '';
    
54.  
    
55. @$ORACLE_HOME/rdbms/admin/ashrpti
    
56. EOC
    
57. 
    
58. #send email to user
    
59. scp ${l_logdir}/ashrpt.html "$REMOTE_USER"@"$REMOTE_HOST":$REMOTE_DIR
    
60. ssh $REMOTE_USER@$REMOTE_HOST $REMOTE_COMMAND

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24486203/viewspace-2123809/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24486203/viewspace-2123809/