【SHELL】Linux系统 Oracle实例监控、重启 简易Shell脚本

  • 海星星hktk

    2014-07-24 23:37:34
  • Oracle
  • 原创
Linux系统 Oracle实例监控、重启 简易Shell脚本



实验环境
Red Hat Linux Enterprise 5
Oracle Database 11g Enterprise  11.2.0.3.0 - 64bit

在Linux系统中，通过一个简单的shell脚本，监控Oracle实例。
添加到crontab计划任务，定时执行，可以再数据库实例异常关闭后及时启动实例。






点击(此处)折叠或打开

  1. #!/bin/bash

  3. echo \"################################################################\"
  4. echo \"##        Oracle Instance Monitor/Restart Shell               ##\"
  5. echo \"##                                                            ##\"
  6. echo \"## Created by: Lv Xinghao                                     ##\"
  7. echo \"## Email : lvxinghao@163.com                                  ##\"
  8. echo \"## Blog : http://blog.itpub.net/29475508/                     ##\"
  9. echo \"################################################################\"

  11. let i_num=\"`cat /etc/oratab | egrep \":Y|:N\" | awk -F \":\" \'{ print $1 }\' | wc -l`\"

  13. if [ $i_num -gt 0 ];then
  14. echo \"----------------------------------------------\"
  15. echo $i_num oracle instance installed in this system.
  16. echo \"----------------------------------------------\"
  17. cat /etc/oratab | egrep \":Y|:N\" | awk -F \":\" \'{ print $1 }\'
  18. cat /etc/oratab | egrep \":Y|:N\" | awk -F \":\" \'{ print $1 }\' > instance_name

  20. for i in `cat instance_name`
  21. do

  23. export ORACLE_SID=$i

  25. let smon_num=\"`ps -ef | grep $i | grep smon | grep -v grep |wc -l`\"

  27. if [ $smon_num -eq 1 ]; then

  29. echo \"------------------------------------------------\"
  30. echo Oracle instance $i is running
  31. echo \"------------------------------------------------\"
  32. sqlplus \'/as sysdba\' <<EOF
  33. select instance_name,status from v\\$instance;
  34. quit;
  35. EOF

  37. else
  38. echo \"------------------------------------------------\"
  39. echo start oracle instance $i :
  40. echo \"------------------------------------------------\"
  41. sqlplus \'/as sysdba\' <<EOF
  42. startup;
  43. select instance_name,status from v\\$instance;
  44. quit;
  45. EOF

  47. fi

  49. done

  51. else
  52. echo No oracle instance in this system or oracle instance not in /etc/
  53. fi
当Oracle实例未启动时 执行脚本

点击(此处)折叠或打开

  1. [oracle@beijing ~]$ sh /u03/shell/startinstance.sh
  2. ################################################################
  3. ## Oracle Instance Monitor/Restart Shell                      ##
  4. ##                                                            ##
  5. ## Created by: Lv Xinghao                                     ##
  6. ## Email : lvxinghao@163.com                                  ##
  7. ## Blog : http://blog.itpub.net/29475508/                     ##
  8. ################################################################
  9. ----------------------------------------------
  10. 2 oracle instance installed in this system.
  11. ----------------------------------------------
  12. BJ
  13. GZ
  14. ------------------------------------------------
  15. start oracle instance BJ :
  16. ------------------------------------------------

  18. SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 24 11:47:50 2014

  20. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  22. Connected to an idle instance.

  24. idle>ORACLE instance started.

  26. Total System Global Area 626327552 bytes
  27. Fixed Size 2230952 bytes
  28. Variable Size 373294424 bytes
  29. Database Buffers 247463936 bytes
  30. Redo Buffers 3338240 bytes
  31. Database mounted.
  32. Database opened.
  33. idle>
  34. INSTANCE_NAME    STATUS
  35. ---------------- ------------
  36. BJ               OPEN

  38. idle>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  39. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  40. Oracle Database Vault and Real Application Testing options
  41. ------------------------------------------------
  42. start oracle instance GZ :
  43. ------------------------------------------------

  45. SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 24 11:47:57 2014

  47. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  49. Connected to an idle instance.

  51. idle>ORACLE instance started.

  53. Total System Global Area 521936896 bytes
  54. Fixed Size 2229944 bytes
  55. Variable Size 322963784 bytes
  56. Database Buffers 192937984 bytes
  57. Redo Buffers 3805184 bytes
  58. Database mounted.
  59. Database opened.
  60. idle>
  61. INSTANCE_NAME STATUS
  62. ---------------- ------------
  63. GZ OPEN

  65. idle>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  66. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  67. Oracle Database Vault and Real Application Testing options
  68. [oracle@beijing ~]$





当Oracle实例已启动时 执行脚本

点击(此处)折叠或打开

  1. [oracle@beijing ~]$ sh /u03/shell/startinstance.sh
  2. ################################################################
  3. ## Oracle Instance Monitor/Restart Shell                      ##
  4. ##                                                            ##
  5. ## Created by: Lv Xinghao                                     ##
  6. ## Email : lvxinghao@163.com                                  ##
  7. ## Blog : http://blog.itpub.net/29475508/                     ##
  8. ################################################################
  9. ----------------------------------------------
  10. 2 oracle instance installed in this system.
  11. ----------------------------------------------
  12. BJ
  13. GZ
  14. ------------------------------------------------
  15. Oracle instance BJ is running
  16. ------------------------------------------------

  18. SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 24 11:40:36 2014

  20. Copyright (c) 1982, 2011, Oracle. All rights reserved.


  23. Connected to:
  24. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  25. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  26. Oracle Database Vault and Real Application Testing options

  28. sys@DGDB>
  29. INSTANCE_NAME    STATUS
  30. ---------------- ------------
  31. BJ               OPEN

  33. sys@DGDB>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  34. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  35. Oracle Database Vault and Real Application Testing options
  36. ------------------------------------------------
  37. Oracle instance GZ is running
  38. ------------------------------------------------

  40. SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 24 11:40:36 2014

  42. Copyright (c) 1982, 2011, Oracle. All rights reserved.


  45. Connected to:
  46. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  47. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  48. Oracle Database Vault and Real Application Testing options

  50. sys@TESTDB>
  51. INSTANCE_NAME    STATUS
  52. ---------------- ------------
  53. GZ               OPEN

  55. sys@TESTDB>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  56. With the Partitioning, Oracle Label Security, OLAP, Data Mining,
  57. Oracle Database Vault and Real Application Testing options
  58. [oracle@beijing ~]$



请使用浏览器的分享功能分享到微信等