Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Error in OEM 12C – Collection Status: [COLLECTIONS_HALTED ( UPLOAD SYSTEM Threshold (UploadMaxDiskUsedPct: 98) exceeded with 98.00302)]

Posted by Mir Sayeed Hassan on December 28th, 2019

Error in OEM 12C – Collection Status: [COLLECTIONS_HALTED (

UPLOAD SYSTEM Threshold (UploadMaxDiskUsedPct: 98) exceeded with 98.00302)]

Check the status of the Agent in Database

[oracle@devtest1 bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.5.0
OMS Version            : 12.1.0.5.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /u02/OEM/agent_inst
Agent Log Directory    : /u02/OEM/agent_inst/sysman/log
Agent Binaries         : /u02/OEM/core/12.1.0.5.0
Agent Process ID       : 26870
Parent Process ID      : 26807
Agent URL              : https://192.168.120.125:38722/emd/main/
Local Agent URL in NAT : https://192.168.120.125:38722/emd/main/
Repository URL         : https://oem12c.local.com:4903/empbs/upload
Started at             : 2019-12-25 18:17:21
Started by user        : oracle
Operating System       : Linux version 3.8.13-68.3.4.el6uek.x86_64 (amd64)
Last Reload            : (none)
Last successful upload                       : 2019-12-25 18:17:35
Last attempted upload                        : 2019-12-25 18:17:35
Total Megabytes of XML files uploaded so far : 0.02
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 2.00%
Collection Status                            : [COLLECTIONS_HALTED(
  UPLOAD SYSTEM Threshold (UploadMaxDiskUsedPct: 98) exceeded with 98.77593)]
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2019-12-28 15:02:04
Last successful heartbeat to OMS             : 2019-12-28 15:02:04
Next scheduled heartbeat to OMS              : 2019-12-28 15:03:05
--------------------------------------------------------------
Agent is Running and Ready

Stop the EM Agent

[oracle@devtest1 bin]$ ./emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.

Before performing any changes, Try to take a backup of the emc.properties file as shown below.

[oracle@devtest1 ~]$ cd /u02/OEM/agent_inst/sysman/config/
[oracle@devtest1 config]$ cp emd.properties emd.properties_bkp

Now change the parameter value under emd.properties

[oracle@devtest1 ~]$ cd /u02/OEM/agent_inst/sysman/config/
[oracle@devtest1 config]$ vi emd.properties

UploadMaxNumberXML=5000
To

UploadMaxNumberXML=7000

START THE EM AGENT

[oracle@devtest1 ~]$ cd /u02/OEM/agent_inst/bin
[oracle@devtest1 bin]$ ls
emctl  emtgtctl  forwarderProxy  nmosudo.props
[oracle@devtest1 bin]$ ./emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Starting agent ............. started.

Check the status of agent

[oracle@devtest1 bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.5.0
OMS Version            : 12.1.0.5.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /u02/OEM/agent_inst
Agent Log Directory    : /u02/OEM/agent_inst/sysman/log
Agent Binaries         : /u02/OEM/core/12.1.0.5.0
Agent Process ID       : 14229
Parent Process ID      : 14165
Agent URL              : https://192.168.120.125:38722/emd/main/
Local Agent URL in NAT : https://192.168.120.125:38722/emd/main/
Repository URL         : https://oem12c.local.com:4903/empbs/upload
Started at             : 2019-12-28 15:21:56
Started by user        : oracle
Operating System       : Linux version 3.8.13-68.3.4.el6uek.x86_64 (amd64)
Last Reload            : (none)
Last successful upload                       : 2019-12-28 15:23:03
Last attempted upload                        : 2019-12-28 15:23:03
Total Megabytes of XML files uploaded so far : 0.03
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 2.00%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2019-12-28 15:23:03
Last successful heartbeat to OMS             : 2019-12-28 15:23:03
Next scheduled heartbeat to OMS              : 2019-12-28 15:24:03

---------------------------------------------------------------
Agent is Running and Ready

=====Hence tested, verified, resolved in our test env=====