Oracle 12c OEM issue

Problem  – OEM12C agent had been down for a few days on a non-production server and more than the maximum number of files had been created ready to be uploaded.

emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

---------------------------------------------------------------

Agent is Not Running

emctl start agent

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

Starting agent ........................................................................................................................... started but not ready.

emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

---------------------------------------------------------------

Agent Version     : 12.1.0.2.0

OMS Version       : 12.1.0.2.0

Protocol Version  : 12.1.0.1.0

Agent Home        : /app/oracle/product/gc12.1/agent12c

Agent Binaries    : /app/oracle/product/gc12.1/core/12.1.0.2.0

Agent Process ID  : 2930

Parent Process ID : 2806

Agent URL         ::1830/emd/main/

Repository URL   ::4900/empbs/upload

Started at        : 2014-03-11 12:45:03

Started by user   : oracle

Last Reload       : (none)

Last successful upload                       : 2014-03-11 12:48:27

Last attempted upload                        : 2014-03-11 12:48:27

Total Megabytes of XML files uploaded so far : 1.07

Number of XML files pending upload           : 3,118

Size of XML files pending upload(MB)         : 8.51

Available disk space on upload filesystem    : 26.60%

Collection Status                            : [COLLECTIONS_HALTED(

  UPLOAD_SYSTEM Threshold (UploadMaxNumberXML: 5000) exceeded with 5001 files)]

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2014-03-11 12:48:11

Last successful heartbeat to OMS             : 2014-03-11 12:48:11

Next scheduled heartbeat to OMS              : 2014-03-11 12:49:11

Edit $ORACLE_HOME/sysman/config/emd.properties and change the entry to 6000 from 5000 for the line

UploadMaxNumberXML=5000

Then instead of the time-consuming process of stopping and starting the agent

Emctl reload agent

That works very quickly and the files were processed few in a few minutes and then I just re-edited the properties file back again and performed a reload