0 积分	0 好友	18 主题

发消息

[SQL调优] 关于 grid control 的错误定位

1^#

发表于 2013-6-27 22:27:31 | 查看: 4134| 回复: 2

本帖最后由霍俊路于 2013-6-27 22:30 编辑

刘大，您好：
刚读了您的博客-Grid Control OMS Agent代理工作原理图
http://www.askmaclean.com/archives/grid-control-oms-agent%e4%bb%a3%e7%90%86%e5%b7%a5%e4%bd%9c%e5%8e%9f%e7%90%86%e5%9b%be.html
感觉收获很大。关于 grid control的认识，有了一个深刻的认识，在此非常感谢。
我在使用grid control进行监控时，遇到了一个问题，需要咨询一下您。
我在用户自定义度量下写了一个语句，在测试的时候也通过了。可是这条语句一直没有执行。
select count(*) from t1 where t1.a2>to_date('2013-06-27 1:1:1', 'yyyy-mm-dd hh24:mi:ss');

我按照您的说明，找到了collection文件。打开之后，发现里面记录的确实有问题。

<CollectionItem NAME="second">
            <Schedule START_DATE="2013-06-27" START_TIME="18:39:00">
                     <IntervalSchedule INTERVAL="5"/>
            </Schedule>
            <MetricColl NAME="SQLUDM">
                     <Condition COLUMN_NAME="NumValue" CRITICAL="0" WARNING="1" OPERATOR="EQ" MESSAGE="UDM alert: key = %Key%, value = %value%">
                              <KeyColumn COLUMN_NAME="ID">second</KeyColumn>
                     </Condition>
                     <ItemProperty NAME="ID">second</ItemProperty>
                     <ItemProperty NAME="sqlstmt">select count(*) from t1 where t1.a2>to_date('2013-06-27 1:1:1', 'yyyy-mm-dd hh24:mi:ss');</ItemProperty>
                     <ItemProperty NAME="UserName" ENCRYPTED="TRUE">073c39203fe8847b</ItemProperty>
                     <ItemProperty NAME="password" ENCRYPTED="TRUE">073c39203fe8847b</ItemProperty>
                     <ItemProperty NAME="valuetype">NUMBER</ItemProperty>
            </MetricColl>
      </CollectionItem>

这条语句在里面被记录中，含有特殊字符。我想请教一下，这个问题我该怎么解决啊？

忘了说明一下 grid control 版本：10205

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-6-28 16:54:28

描述或者截图说明你是这么定义这个自定义度量的

回复只看该作者道具举报

霍俊路

3^#

发表于 2013-7-1 13:26:45

Maclean Liu(刘相兵发表于 2013-6-28 16:54
描述或者截图说明你是这么定义这个自定义度量的

2013-06-15 08:42:09,617 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 08:42:09,617 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 08:42:09,617 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 09:42:13,829 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 09:42:13,833 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 09:42:13,833 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 10:42:18,002 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 10:42:18,002 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 10:42:18,003 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 11:42:22,265 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 11:42:22,265 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 11:42:22,266 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 12:42:27,008 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 12:42:27,012 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 12:42:27,013 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 13:42:31,290 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 13:42:31,290 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 13:42:31,291 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 14:42:36,263 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 14:42:36,263 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 14:42:36,264 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 15:42:40,525 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 15:42:40,528 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 15:42:40,528 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 16:15:54,241 Thread-33911 WARN  ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2013-06-15 16:15:54,241 Thread-33911 WARN  ssl.io: fd=24: nmehlssl_read, nzos_Read error = 28862 readTimed Out = 1
2013-06-15 16:15:54,241 Thread-33911 WARN  http: <nmehl.c>:<nmehl_readline>: nmehlssl_read() timed out
2013-06-15 16:15:54,241 Thread-33911 ERROR pingManager: nmepm_pingReposURL: Error in request response. code = 400. text =
2013-06-15 16:15:57,500 Thread-33916 ERROR upload: Failed to upload file D0001400.xml: HTTP error.
2013-06-15 16:15:57,825 Thread-33911 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:15:58,701 Thread-33916 ERROR upload: Failed to upload file D0001400.xml: HTTP error.
2013-06-15 16:15:59,904 Thread-33916 ERROR upload: Failed to upload file D0001400.xml: HTTP error.
2013-06-15 16:15:59,904 Thread-33916 ERROR upload: 3 Failure(s) in a row or XML error for D0001400.xml, retcode = -2, we give up
2013-06-15 16:16:28,560 Thread-33925 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:16:30,091 Thread-33925 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:16:53,389 Thread-33933 ERROR upload: Failed to upload file D0001400.xml: HTTP error.
2013-06-15 16:16:53,389 Thread-33933 ERROR upload: 1 Failure(s) in a row or XML error for D0001400.xml, retcode = -2, we give up
2013-06-15 16:17:01,591 Thread-33935 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:17:03,013 Thread-33935 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:17:30,249 Thread-33944 ERROR upload: Failed to upload file C0000879.xml: HTTP error.
2013-06-15 16:17:30,249 Thread-33944 ERROR upload: 1 Failure(s) in a row or XML error for C0000879.xml, retcode = -2, we give up
2013-06-15 16:17:34,514 Thread-33946 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:17:36,058 Thread-33946 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:18:00,765 Thread-33953 ERROR upload: Failed to upload file B0000177.xml: HTTP error.
2013-06-15 16:18:00,765 Thread-33953 ERROR upload: 1 Failure(s) in a row or XML error for B0000177.xml, retcode = -2, we give up
2013-06-15 16:18:08,165 Thread-33955 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:18:09,624 Thread-33955 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:18:40,040 Thread-33966 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:18:40,468 Thread-33966 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:19:10,985 Thread-33975 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:19:11,312 Thread-33975 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:19:41,719 Thread-33988 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:19:42,156 Thread-33988 ERROR pingManager: nmepm_pingReposURL: Did not receive a response header from repository
2013-06-15 16:42:45,089 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 16:42:45,094 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 16:42:45,109 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 17:42:49,469 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 17:42:49,472 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 17:42:49,472 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 18:42:54,051 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 18:42:54,051 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 18:42:54,051 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 19:42:57,783 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 19:42:57,783 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 19:42:57,798 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 20:43:02,526 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 20:43:02,528 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 20:43:02,529 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 21:43:06,638 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 21:43:06,638 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 21:43:06,639 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 22:43:11,618 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 22:43:11,630 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 22:43:11,631 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
2013-06-15 23:43:15,879 Thread-103 ERROR recvlets.aq: invalid alert condition (NULL metric name)
2013-06-15 23:43:15,885 Thread-103 ERROR recvlets.aq: unable to create new server alert threshold
2013-06-15 23:43:15,886 Thread-103 WARN  recvlets.aq: Duplicate threshold key instance_throughput.logons_ps.  for [oracle_database rac_o3_inst1]
我在查看emagent的 trace文件时，发现了一个更严重的问题。其中某一天的错误日志如下。我把某一天的日志截取了一下。请指导分析一下。我发现了从某一天之后一直再报错，手动创建的度量一直没有成功运行过。

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册