Tuesday 1 March 2016

EMD upload error: Failed to upload file A0000001.xml: Fatal Error. Response received: 500|ORA-20206: Target does not exist:

Oracle Agent Connectivity Issue between Oracle Database Server and OMS Server
----------------------------------------------------------------------------------------------------------

Background: - Agent is installed on a database server trying to upload XML on OMS server.


ERROR:-
oracle@dbserver1$ ./emctl start agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Starting agent ...... started.

oracle@dbserver1$ ./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 10.2.0.5.0
Protocol Version  : 10.2.0.5.0
Agent Home        : /u01/app/oracle/agent11g
Agent binaries    : /u01/app/oracle/agent11g
Agent Process ID  : 24825
Parent Process ID : 24820
Agent URL         : http://dbserver1:3872/emd/main/
Repository URL    : http://omsrv01:4889/em/upload/
Started at        : 2016-03-01 15:17:52
Started by user   : oracle
Last Reload       : 2016-03-01 15:17:52
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :       54
Size of XML files pending upload(MB)         :    12.55
Available disk space on upload filesystem    :    59.24%
Last successful heartbeat to OMS             : 2016-03-01 15:17:55
---------------------------------------------------------------
Agent is Running and Ready


oracle@dbserver1$ ./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload error: Failed to upload file A0000001.xml: Fatal Error.
Response received: 500|ORA-20206: Target does not exist:  Agent does not exist for http://dbserver1:3872/emd/main/ ORA-06512: at "SYSMAN.EMD_LOADER", line 1596 ORA-06512: at line 1

Resolution:-
1.      Forced remove of targets from OEM repository
====================================

SQL> execute sysman.mgmt_admin.delete_target_internal ('dbserver1:3872','oracle_emd');
BEGIN sysman.mgmt_admin.delete_target_internal ('dbserver1:3872','oracle_emd'); END;

*
ERROR at line 1:
ORA-20206:  The target does not exist or may have already been deleted:  Target
name = dbserver1:3872 and Target type = oracle_emd
ORA-06512: at "SYSMAN.MGMT_ADMIN", line 646
ORA-06512: at line 1

2.      As it is already deleted from OMS host, still if you getting error , Try this.
rm -r $AGENT_HOME/sysman/emd/state/* 
rm -r $AGENT_HOME/sysman/emd/collection/* 
find $AGENT_HOME/sysman/emd/upload/ -type f -name "*.xml" -exec rm {} \;
rm $AGENT_HOME/sysman/emd/lastupld.xml 
rm $AGENT_HOME/sysman/emd/agntstmp.txt 
rm $AGENT_HOME/sysman/emd/blackouts.xml

3.      Again try to start agent and Upload.
oracle@dbserver1$ ./emctl start agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Starting agent ......... started.


oracle@dbserver1$ ./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully

oracle@dbserver1$ ./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 10.2.0.5.0
Protocol Version  : 10.2.0.5.0
Agent Home        : /u01/app/oracle/agent11g
Agent binaries    : /u01/app/oracle/agent11g
Agent Process ID  : 25771
Parent Process ID : 25766
Agent URL         : http://dbserver1:3872/emd/main/
Repository URL    : http://omsrv01:4889/em/upload/
Started at        : 2016-03-01 15:23:40
Started by user   : oracle
Last Reload       : 2016-03-01 15:28:17
Last successful upload                       : 2016-03-01 15:38:40
Total Megabytes of XML files uploaded so far :    10.22
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    59.30%
Last successful heartbeat to OMS             : 2016-03-01 15:38:48
---------------------------------------------------------------
Agent is Running and Ready

No comments:

Post a Comment