一般来说安装完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:
-
Click the Targets tab in the Grid Control
Console.
-
Click the Database subtab to list the database
targets you are monitoring.
-
Select the database and click Configure.
Enterprise Manager displays the Configure Database: Properties page.
-
Enter the new password for the DBSNMP account in the Monitor
Password field.
-
Click Test Connection to confirm that the monitoring
credentials are correct.
-
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博客 ” ,链接:https://blog.itpub.net/9466564/viewspace-609899/
,如需转载,请注明出处,否则将追究法律责任。