【SHELL】Linux系統 Oracle例項監控、重啟 簡易Shell指令碼

海星星hktk發表於2014-07-24
LinuxOracle指令碼
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 ~]$



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29475508/viewspace-1226511/，如需轉載，請註明出處，否則將追究法律責任。

相關文章