[checkmk-commits] 5550 FIX mk_oracle.ps1: Fixed exceptions because of useless backslashes

Module: check_mk Branch: master Commit: 95924dc8ec02f1ae3cebe9d0c3fa30025a06c504 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=95924dc8ec02f1… Author: Marcel Arentz <ma(a)mathias-kettner.de> Date: Thu Nov 23 12:10:21 2017 +0100 5550 FIX mk_oracle.ps1: Fixed exceptions because of useless backslashes There has been a bug introduced as part of an feature enhancement which caused an exception of the plugin and prevented the execution. This Bug has been introduced in June 16th and is solved now. Change-Id: I77e7bc779b5596b6fb47c23b3afa84ff766c54b7 --- .werks/5550 | 12 ++++++++++++ agents/windows/plugins/mk_oracle.ps1 | 10 +++++----- 2 files changed, 17 insertions(+), 5 deletions(-) diff --git a/.werks/5550 b/.werks/5550 new file mode 100644 index 0000000..fd15a0b --- /dev/null +++ b/.werks/5550 @@ -0,0 +1,12 @@ +Title: mk_oracle.ps1: Fixed exceptions because of useless backslashes +Level: 1 +Component: checks +Compatible: compat +Edition: cre +Version: 1.5.0i2 +Date: 1511435209 +Class: fix + +There has been a bug introduced as part of a feature enhancement which +caused an exception of the plugin and prevented the execution. This bug has +been introduced in June 16th and is solved now. diff --git a/agents/windows/plugins/mk_oracle.ps1 b/agents/windows/plugins/mk_oracle.ps1 index 078e643..f0558ae 100644 --- a/agents/windows/plugins/mk_oracle.ps1 +++ b/agents/windows/plugins/mk_oracle.ps1 @@ -1108,7 +1108,7 @@ select upper(i.instance_name) || '|' || logswitches from v$instance i , (select count(1) logswitches - from v\$loghist h , v\$instance i + from v$loghist h , v$instance i where h.first_time > sysdate - 1/24 and h.thread# = i.instance_number) ; @@ -1145,15 +1145,15 @@ Function sql_locks { || '|' || bs.process || '|' || bs.osuser || '|' || bs.username - from v\$session b - join v\$instance i on 1=1 - join gv\$session bs on bs.inst_id = b.BLOCKING_INSTANCE + from v$session b + join v$instance i on 1=1 + join gv$session bs on bs.inst_id = b.BLOCKING_INSTANCE and bs.sid = b.BLOCKING_SESSION where b.BLOCKING_SESSION is not null ; select upper(i.instance_name) || '|||||||||||||||||' - from v\$instance i + from v$instance i ; '@ echo $query_locks