Apps DBA Workshop

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 B...

I was trying to add Oracle Solaris 11.2 Host in Oracle EM 12cR4. The OMS Server is Installed on Linux-64bit. There was no agent available to deploy it on the Solaris host. In this article will demonstrate how to install download and install the unavailable agent software on EM12c OMS Server in an offline mode. Login to EM12c console and navigate: Setup >> selfupdate >> Agent Software It will list down all available agent software's.  If the agent software is available then you need to download the required patch and apply it in a offline mode. Here for Solaris 11 agent software is available but not applied. - To apply this patch on OMS download the patch "18797137" from MOS and update it in the OMS software library using emcli command in offline mode. - Upload the patch to Server accessible to OMS user. - Login to "sysman" user using emcli command [oracle@oem12c sw_home]$ /u01/em12c_home/oms/bin/emcli login -username=sysman E...