Skip to main content

UPLOAD_SYSTEM Threshold (UploadMaxNumberXML: 5000) exceeded with 5698 files) EM 12c Agent

I was facing  Issues on Oracle Enterprise Manager cloud control agent with Error "UPLOAD_SYSTEM Threshold (UploadMaxNumberXML: 5000) exceeded with 5698 files)" for command "emctl status agent"

I tried to stop/start agent but failed to communicate with OMS Server.

This Issue occurred because of incorrect configuration of open files. You need to properly configure the value for open files. I encountered this Issue on Oracle Solaris 10 OS. This Issue can also be encountered on other unix/linux flavour .

Output for command "emctl status agent":

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./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       : (unknown)
Protocol Version  : 12.1.0.1.0
Agent Home        : /oem/OEMAGENT/agent/agent_inst
Agent Binaries    : /oem/OEMAGENT/agent/core/12.1.0.2.0
Agent Process ID  : 23697
Parent Process ID : 23413
Agent URL         : https://oradb01:3872/emd/main/
Repository URL    : https://oemserver1.orasol.com:4901/empbs/upload
Started at        : 2021-10-12 08:49:40
Started by user   : oemagent
Last Reload       : (none)
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far : 0
Number of XML files pending upload           : 5,719
Size of XML files pending upload(MB)         : 5.48
Available disk space on upload filesystem    : 50.79%
Collection Status                            : [COLLECTIONS_HALTED(
  UPLOAD_SYSTEM Threshold (UploadMaxNumberXML: 5000) exceeded with 5698 files)]
Heartbeat Status                             : Agent is blocked
Last attempted heartbeat to OMS              : 2021-10-12 09:40:33
Last successful heartbeat to OMS             : (none)
Next scheduled heartbeat to OMS              : 2021-10-12 09:43:33

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



Solution:

1) Stop agent
2) Increase ulimit value
3) unblock agent
4) start agent
5) upload to OMS
6) check agent status


1) Stop agent

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping agent .......... stopped.


2) Increase ulimit value

- Current Value of open files:

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ulimit -a
core file size        (blocks, -c) unlimited
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
open files                    (-n) 256
pipe size          (512 bytes, -p) 10
stack size            (kbytes, -s) 8192
cpu time             (seconds, -t) unlimited
max user processes            (-u) 29995
virtual memory        (kbytes, -v) unlimited 

- Increase Value of open files:


[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ulimit -n 65536
[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ulimit -a
core file size        (blocks, -c) unlimited
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
open files                    (-n) 65536
pipe size          (512 bytes, -p) 10
stack size            (kbytes, -s) 8192
cpu time             (seconds, -t) unlimited
max user processes            (-u) 29995
virtual memory        (kbytes, -v) unlimited
[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]#

3) unblock agent

Navigate to Setup >> Manage clound control >> agent >> 

- Select block agent and unblock target




4) start agent

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./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.


5) upload to OMS

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./emctl upload

6) check agent status 

[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]# ./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        : /oem/OEMAGENT/agent/agent_inst
Agent Binaries    : /oem/OEMAGENT/agent/core/12.1.0.2.0
Agent Process ID  : 12790
Parent Process ID : 12532
Agent URL         : https://oradb01:3872/emd/main/
Repository URL    : https://oemserver1.orasol.com:4901/empbs/upload
Started at        : 2021-10-12 11:24:50
Started by user   : oemagent
Last Reload       : (none)
Last successful upload                       : 2021-10-12 11:35:14
Last attempted upload                        : 2021-10-12 11:35:14
Total Megabytes of XML files uploaded so far : 0.03
Number of XML files pending upload           : 146
Size of XML files pending upload(MB)         : 0.17
Available disk space on upload filesystem    : 50.83%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2021-10-12 11:35:06
Last successful heartbeat to OMS             : 2021-10-12 11:35:06
Next scheduled heartbeat to OMS              : 2021-10-12 11:36:06

---------------------------------------------------------------
Agent is Running and Ready
[oemagent@oradb01][/oem/OEMAGENT/agent/agent_inst/bin]#

Now the agent is successfully able to communicate with OMS and upload XML.

Thanks for reading.

regards,
Zaheer

Comments

Blogger said…
If you're looking to burn fat then you absolutely have to start using this brand new personalized keto diet.

To create this keto diet, certified nutritionists, fitness couches, and professional chefs have joined together to develop keto meal plans that are useful, convenient, cost-efficient, and delightful.

From their first launch in early 2019, hundreds of clients have already transformed their figure and health with the benefits a proper keto diet can offer.

Speaking of benefits; in this link, you'll discover 8 scientifically-tested ones given by the keto diet.

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment...

Oracle Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Insta...