Linux/unix Shell Monitoring Oracle Instance (monitor instance)

Using shell scripts to monitor and manage Oracle databases will greatly simplify the workload of DBAs, such as common monitoring of instances, monitoring of monitors, monitoring of alarm logs, backup of databases, automatic mailing of AWR report, etc. This article gives an example of using shell scripts to monitor Oracle instances under Linux.

Reference for Linux Shell:
Linux/unix calling Sql,rman script in shell script
Linux/unix passing variables between shell SQL
Linux/unix Shell calls PL/SQL

1. Monitoring Oracle Instance shell scripts

[Python]View PlainCopyprint?

2. [Email protected]:~/dba_scripts/custom/bin> more ck_inst.sh
4. # +-------------------------------------------------------+
6. # + CHECK INSTANCE STATUS and SEND MAIL |
8. # + Author:robinson |
10. # + blog:http://blog.csdn.net/robinson_0612 |
12. # + DESC: |
14. # + variable x_db use to exclude some instance |
16. # +-------------------------------------------------------+
20. #!/bin/bash
24. # --------------------------------------------
26. # Set Environment vairable and define variable
28. # --------------------------------------------
32. If [-f ~/.bash_profile]; Then
34. . ~/.bash_profile
36. Fi
40. Oratab=/etc/oratab
42. timestamp= ' Date +%y%m%d%h%m '
44. Mailpath=/users/robin/dba_scripts/sendemail-v1. About
46. Log_dir=/users/robin/dba_scripts/custom/log
48. Log_file=${log_dir}/ck_inst_$timestamp.log
50. dbalist="[Email protected];[ Email protected] "
52. x_db=' sybo2sz| cnqdii| Cnfo '
54. retention=1
58. # ----------------------
60. # Check Instance Status
62. # ----------------------
66. If [-Z ' $X _db]; Then
68. x_db=' DUMMY '
70. Fi
72. {
74. echo "' Date '"
76. echo "Oracle Database (s) Status on ' hostname '"
78. echo "-----------------------------------------"
80. db= ' Egrep-i ": y|:n" $ORATAB | cut-d":"-F1 | Grep-v " \#" | grep-v "\*"
82. Pslist= ' Ps-ef | grep Pmon | Grep-v grep '
84. Dblist= ' fori in $db, do echo $i, done | GREP-VP $X _db '
86. For i in $dblist;
88. echo "$pslist" | grep "[oa]*_pmon_$i" >/dev/null 2>&1
90. if ($?)); Then
92. echo "Oracle instance-$i: Down"
94. Else
96. echo "Oracle instance-$i: Up"
98. Fi
100. Done
102. }|tee-a ${log_file} 2>&1
106. # ------------------------
108. # Send Email
110. # ------------------------
114. Cnt= ' Cat $LOG _file | grep down | Wc-l '
116. If [ "$cnt"-gt 0]; Then
118. $MAILPATH/sendemail-f [email protected]2gotrade.com-t $DBALIST-u "Instance status on ' hostname '"-O message-fil e= $LOG _file
120. Fi
124. # ------------------------------------------------
126. # Removing files older than $RETENTION parameter
128. # ------------------------------------------------
132. Find ${log_dir}-name "ck_inst*.*"-mtime + $RETENTION-exec rm {} \;
136. Exit
140. [Email protected]:~/dba_scripts/custom/bin>./ck_inst.sh
142. Fri Feb 1 :CST
144. Oracle Database (s) Status on szdb
146. -----------------------------------------
148. Oracle Instance-cnbo1:up
150. Oracle Instance-cnbotst:down
152. Oracle Instance-cnmmbo:up
154. Oracle Instance-mmbotst:up
156. Oracle Instance-cnmmbobk:down
158. Oracle Instance-ci8960u:up
160. Oracle Instance-cnbo2:up
162. Feb : szdb sendemail[16024]: Email was sent successfully!

2. Supplement
A, the above script is monitored according to the instance listed in/etc/oratab, can monitor multiple instances.
b, the variable x_db is used to exclude instances that do not need to be monitored, such as 3 instances are discharged from a script. You can also leave the variable blank.
C, if the value of x_db is empty, we give dummy to ensure that your DB instance name is not used dummy, otherwise filtering will not be removed.
D, monitoring scripts in the monitoring process as long as one instance is down, the entire monitoring report is sent.
D. Use the SendEmail Mail Sender program to send mail. See: The Indispensable SendEmail
E, tail clear the log that precedes the retention date that is generated during the monitoring process.

Ext.: http://blog.csdn.net/leshami/article/details/8563115

Linux/unix Shell Monitoring Oracle Instance (monitor instance)