Resolving the Upload Errors in OEM
Some time back when we were working with Oracle Grid, we had some issues with uploading the data collected by the agent in one of the servers’ being monitored to the OMS. Following is the sequence of issues and the steps to resolve them.
Actual Error:
Oracle Management Agent, version 10.2.0.3.0, fails to upload to Oracle Management Server with:
EMD UPLOAD ERROR: UPLOADXMLFILES SKIPPED :: OMS VERSION NOT CHECKED YET..
emctl status agent shows a backlog of files waiting to be uploaded and no data in the OMS Version field.
To Reproduce the Problem
$emctl upload agent
EMD UPLOAD ERROR: UPLOADXMLFILES SKIPPED :: OMS VERSION NOT CHECKED YET..
To secure the agent on the target server, run the following command:
$AGENT_HOME/sysman/bin/ emctl secure agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
Enter Agent Registration password :
Stopping agent…
Requesting an HTTPS Upload URL from the OMS…caught IOException 1 java.net.ConnectException: Connection refused
Failed.
The OMS is not set up for Enterprise Manager Security.
Resolution:
Stop the agent
$<AGENT_HOME>/bin/emctl stop agent
Edit the emd properties file as given below
$cd agent_home/sysman/config
$vi emd.properties
Check the Repository URL is mentioned correctly
Change the property REPOSITORY_URL to have the correct hostname and port
for the OMS
REPOSITORY_URL = https://<hostname>:4889/em/upload/
Change the agent URL
EMD_URL=https://<hostname>:3872/emd/main
Change the property agentTZRegion to a timezone that reflects your timezone
that exists in the file <AGENT_HOME>/sysman/admin/nsuppertedtzs.lst, for
example:
agentTZRegion=Europe/Paris
Clean start the agent:
Delete any pending upload files from the agent home
rm -r <AGENT_HOME>/sysman/emd/state/*
rm -r <AGENT_HOME>/sysman/emd/collection/*
rm -r <AGENT_HOME>/sysman/emd/upload/*
rm <AGENT_HOME>/sysman/emd/lastupld.xml
rm <AGENT_HOME>/sysman/emd/agntstmp.txt
rm <AGENT_HOME>/sysman/emd/blackouts.xml
rm <AGENT_HOME>/sysman/emd/protocol.ini
Start the agent
$<AGENT_HOME>/bin/emctl start agent
Issue an agent clearstate from the agent home
$<AGENT_HOME>/bin/emctl clearstate agent
Secure the Agent
$ <AGENT_HOME>/emctl secure agent
Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enter Agent Registration password :
Agent is already stopped… Done.
Securing agent… Started.
Requesting an HTTPS Upload URL from the OMS… Done.
Requesting an Oracle Wallet and Agent Key from the OMS… Done.
Check if HTTPS Upload URL is accessible from the agent… Done.
Configuring Agent for HTTPS in CENTRAL_AGENT mode… Done.
EMD_URL set in /d01/oracle/product/oem10g_agent/agent10gR3/agent10g/sysman/config/emd.properties
Securing agent… Successful.
Verify that the command executed successfully and that $ORACLE_HOME/sysman/log/secure.log now exists
Force an upload to the OMS
$<AGENT_HOME>/bin/emctl upload agent
Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload completed successfully
Login to OEM and check if the metric data is uploaded.