ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Configure database monitoring on Grid Control

Configure database monitoring on Grid Control

原创 Linux操作系统 作者:jiuniang012 时间:2009-07-22 12:26:04 0 删除 编辑
一般来说安装完GC, AGENG后登入GC控制台会自动发现主机上的所有targets,但你会发现有很多显示的是‘NOT CONFIGURE'状态,这就意味着你还没有配置数据库自动监视功能,而且在log里会发现很多’Compute dynamic property takes too long‘错误。对于’Compute dynamic property takes too long‘错误一般有两个种原因,一是还没有配置监视功能,另一个是配置了监视功能但收集或上传信息timeout了,可以通过配置/sysman/config/emd.properites配置文件里的如下几行:
#dynamicPropsComputeTimeout=30    -------[取消注释并适当添加时间(秒),如120, 180,然后重启AGENT]
----[以下是针对RAC环境的配置]
#Requested by RAC team in bug 4423072
dynamicPropsComputeTimeout_rac_database=120

#bug 4595094
dynamicPropsComputeTimeout_oracle_database=120

下面说下如何配置监视功能:
有两种方法:通过控制台和通过emctl命令行

方法一通过控制台:

To modify the password for the DBSNMP account in the Oracle Enterprise Manager 10g Grid Control Console:

  1. Click the Targets tab in the Grid Control Console.

  2. Click the Database subtab to list the database targets you are monitoring.

  3. Select the database and click Configure.

    Enterprise Manager displays the Configure Database: Properties page.

  4. Enter the new password for the DBSNMP account in the Monitor Password field.

  5. Click Test Connection to confirm that the monitoring credentials are correct.

  6. If the connection is successful, continue to the end of the Database Configuration wizard and click Submit.

方法二:通过emctl命令行
首先要列出被管理主机上的目标targets
进入AGENT_HOME/bin目录执行$PROMPT>./emctl config agent listtargets [AGENT_HOME]
如:$ emctl config agent listtargets  /u01/app/oracle/product/10.2.0/agent10g
Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
[liang.com:3872, oracle_emd]
[liang.com, host]
[LISTENER_liang.com, oracle_listener]
[EnterpriseManager0.liang.com_home, oc4j]
[EnterpriseManager0.liang.com_HTTP Server, oracle_apache]
[EnterpriseManager0.liang.com_Web Cache, oracle_webcache]
[EnterpriseManager0.liang.com, oracle_ias]
[EnterpriseManager0.liang.com_OC4J_EMPROV, oc4j]
[EnterpriseManager0.liang.com_OC4J_EM, oc4j]
[liang.com_oms_csa_collector, oracle_csa_collector]
[Management Services and Repository, oracle_emrep]
[ORCL, oracle_database]

然后更改或配置监视用户或密码:
进入AGENT_HOME/bin执行$PROMPT>./emctl config agent credentials [Target_name[:Target_Type]]
如:$ emctl config agent credentials ORCL:oracle_database
Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
Name = ORCL, Type = oracle_database
Want to change for "UserName" (y/n):n
Want to change for "password" (y/n):y
Enter the new value for "password" :*********
Re-enter the new value for "password" :*********
EMD reload completed successfully

在我的环境中,用GC10.2.0.4控制台配置目标数据库11.1.0.6,报错:
oracle.sysman.emSDK.emd.CommException
只能通过emctl命令行配置

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9466564/viewspace-609899/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-07-02

  • 博文量
    126
  • 访问量
    211240