Oracle Grid Control在同步代理的客户端和服务器的时候出现以下错误:
Internal Repository Error Message: SQL Exception occured while syncing pdp settings | Exception:
java.sql.SQLException: ORA-20206: Target does not exist: dmclo.cr.dev:host ORA-06512: at "SYSMAN.MGMT_TARGET", line
571 ORA-06512: at "SYSMAN.MGMT_CREDENTIALS_UI", line 298 ORA-06512: at line 1 "
查看targets.xml,发现里面什么都没有
-bash-3.00$ vi /opt/OracleHomes/agent10g/sysman/emd/targets.xml
"/opt/OracleHomes/agent10g/sysman/emd/targets.xml" 3 行,145 字符
<Targets AGENT_TOKEN="d296a1c5037c9d2c23472f2876d37a2382dc2ee7">
<Target TYPE="oracle_emd" NAME="sun:3872" DISPLAY_NAME="sun:3872"/>
</Targets>
运行下面命令生成targets.xml
-bash-3.00$ /opt/OracleHomes/agent10g/bin/agentca -f
Stopping the agent using /opt/OracleHomes/agent10g/bin/emctl stop agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Stopping agent ... stopped.
Running agentca using /opt/OracleHomes/agent10g/oui/bin/runConfig.sh ORACLE_HOME=/opt/OracleHomes/agent10g
ACTION=Configure MODE=Perform RESPONSE_FILE=/opt/OracleHomes/agent10g/response_file RERUN=TRUE
INV_PTR_LOC=/opt/OracleHomes/agent10g/oraInst.loc COMPONENT_XML={oracle.sysman.top.agent.10_2_0_1_0.xml}
Perform - 操作的模式正在启动: Configure
Perform - 操作的模式已完成: Configure
您可以查看日志文件: /opt/OracleHomes/agent10g/cfgtoollogs/oui/configActions2010-01-22_05-26-34-PM.log
再次查看targets.xml
-bash-3.00$ vi /opt/OracleHomes/agent10g/sysman/emd/targets.xml
"/opt/OracleHomes/agent10g/sysman/emd/targets.xml" 19 行,841 字符
<Targets AGENT_TOKEN="d296a1c5037c9d2c23472f2876d37a2382dc2ee7">
<Target TYPE="oracle_emd" NAME="sun:3872" DISPLAY_NAME="sun:3872"/>
<Target TYPE="host" NAME="sun"/>
<Target TYPE="oracle_database" NAME="sun">
<Property NAME="OracleHome" VALUE="/opt/oracle"/>
<Property NAME="UserName" VALUE="c32723b886bce269" ENCRYPTED="TRUE
"/>
<Property NAME="MachineName" VALUE="sun"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="SID" VALUE="sun"/>
<Property NAME="ServiceName" VALUE="sun"/>
</Target>
<Target TYPE="oracle_listener" NAME="LISTENER_sun">
<Property NAME="ListenerOraDir" VALUE="/opt/oracle/network/admin"/
>
<Property NAME="LsnrName" VALUE="LISTENER"/>
<Property NAME="Machine" VALUE="sun.com"/>
<Property NAME="OracleHome" VALUE="/opt/oracle"/>
<Property NAME="Port" VALUE="1521"/>
</Target>
</Targets>
最后再次同步成功
联系客服