Oracle Grid Control代理同步错误

AlPacido 2012-04-28

展开全文

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>