Linux/unix Shell Monitoring Oracle Listener (monitor Listener)

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 the use of shell scripts to monitor Oracle listeners 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
Linux/unix Shell Monitoring Oracle Instance (monitor instance)

1. Monitoring Oracle Monitor Shell script

[Python]View PlainCopyprint?

2. [Email protected]:~/dba_scripts/custom/bin> more ck_lsnr.sh
4. # +-------------------------------------------------------+
6. # + CHECK LISTENER STATUS and RESTART IT when FAILED |
8. # + Author:robinson |
10. # + blog:http://blog.csdn.net/robinson_0612 |
12. # + Parameter:no |
14. # +-------------------------------------------------------+
18. #!/bin/bash
20. # --------------------
22. # Define Variable
24. # --------------------
28. If [-f ~/.bash_profile]; Then
30. . ~/.bash_profile
32. Fi
36. timestamp= ' Date +%y%m%d%h%m '; Export TIMESTAMP
38. dbalist="[email protected]"; Export dbalist
40. Mailpath=/users/robin/dba_scripts/sendemail-v1. About
42. Log_dir=/users/robin/dba_scripts/custom/log
44. Log_file=${log_dir}/lsnr_status_$timestamp.log
46. retention=2
50. # -----------------------------------------
52. # Define How many listeners need to monitor
54. # -----------------------------------------
58. db_count=6
60. db[1]=cnbo1
62. db[2]=cnbotst
64. db[3]=cnmmbo
66. db[4]=mmbotst
68. db[5]=sybo2sz
70. db[6]=cnbo2
74. # -------------------------
76. # Begin to check Listener
78. # -------------------------
82. Touch $LOG _file
84. echo "' Date '" >> $LOG _file
86. Echo "The following listeners is down on ' hostname '" >> $LOG _file
88. echo "-----------------------------------------------" >> $LOG _file
92. count=1
94. While [$COUNT-le $DB _count];
96. Do
98. For DB in ${db[$COUNT]};
100. Do
102. Lsnr_flag= ' Ps-ef | Grep-i listener_${db[$COUNT]} | Grep-v grep '
104. if [-Z ' $lsnr _flag]; Then
106. echo "The Listener for the database ${db[$COUNT]} are down." >> $LOG _file
108. echo "=======> Restart Listener for the database ${db[$COUNT]}" >> $LOG _file
110. Lsnrctl start listener_${db[$COUNT]} >> $LOG _file
112. Echo-e "------------------------------------------------------------------\ n" >> $LOG _file
114. Fi
116. Done
118. Count= ' expr $COUNT + 1 '
120. Done
124. # --------------------------
126. # Send Email
128. # --------------------------
132. Cnt= ' grep ' restart Listener "$LOG _file |wc-l '
134. If [ "$cnt"-gt 0];then
136. $MAILPATH/sendemail-f [email protected]2gotrade.com-t $DBALIST-u "Listener crashed on ' hostname '"-O Message-fi le= $LOG _file
138. Else
140. RM-RF $LOG _file
142. Fi
146. # ------------------------------------------------
148. # Removing files older than $RETENTION parameter
150. # ------------------------------------------------
154. Find ${log_dir}-name "*lsnr_status*"-mtime + $RETENTION-exec rm {} \;
158. Exit
162. [Email protected]:/users/robin/dba_scripts/custom/bin>./ck_lsnr.sh
164. Feb : szdb sendemail[18611]: Email was sent successfully!
166. Fri Feb 1 : #下面是测试脚本邮件发送包含的内容
168. The following listeners is down on szdb
170. -----------------------------------------------
172. The listener for the database CNBO1 are down .
174. =======> Restart Listener for the database CNBO1
178. Lsnrctl for linux:version 10.2. 0.3.0-production on 01-feb- : £º
182. Copyright (c) 1991, 2006, Oracle.  All rights reserved.
186. Starting/users/oracle/orahome10g/bin/tnslsnr:please wait ...
190. Tnslsnr for linux:version 10.2. 0.3.0-production System parameter file is
192. /users/oracle/orahome10g/network/admin/listener.ora
194. Log messages Written To/users/oracle/orahome10g/network/log/listener_cnbo1.log
196. Listening on: (Description= (Address= (protocol=tcp) (host=192.101. 7.2) (port=1901 )))
200. Connecting to (Description= (address= (protocol=tcp) (host=192.101. 7.2) (port=1901 )))
202. STATUS of the LISTENER
204. ------------------------
206. Alias Listener_cnbo1
208. Version Tnslsnr for linux:version 10.2. 0.3.0-production
210. Start Date 01-feb- : £º
212. Uptime 0 days 0 hr. 0 min. 0 sec
214. Trace level off
216. Security on:local OS Authentication
218. SNMP OFF
220. Listener Parameter File/users/oracle/orahome10g/network/admin/listener.ora
222. Listener Log File/users/oracle/orahome10g/network/log/listener_cnbo1.log
224. Listening Endpoints Summary ...
226. (Description= (address= (protocol=tcp) (host=192.101. 7.2) (port=1901 )))
228. Services Summary ...
230. Service "CNBO1" has 1 instance (s).
232. Instance "CNBO1", status UNKNOWN, have 1 handler (s) for the This service ...
234. The command completed successfully
236. ------------------------------------------------------------------

2. Supplement
A, the above monitoring monitor script can monitor multiple listeners.
b, the name of the listener is defined in the format listener_$oracle_sid, the default listener is not considered, such as using the default listener to make the corresponding changes.
C, using an array of methods to define the instance name, each corresponding to a listener, to ensure that the Db_count value and the number of listeners to monitor the match.
D, each element of the array uses ORACLE_SID, and if it is a RAC, it can be changed to a host name.
E, if a listener outage is detected, the listener is automatically restarted and the message is sent.
F, use the SendEmail Mail Sender program to send mail. See: The Indispensable SendEmail
G. Deploy the script through crontab. In addition, Oracle 10g testing is available and Oracle 11g is being tested.

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

Linux/unix Shell Monitoring Oracle Listener (monitor listener)