OEM agent is not collecting metrics

This post is also available at: Português

Oracle Enterprise Manager home screen
Oracle Enterprise Manager home screen

Today I found one of the OEM agents running normally, but it wasn’t sending the metrics to Enterprise Manager.
Fortunately, the solution is quite simple.

[oracle@oracleserver bin]$ ./emctl stop agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.
Bash
[oracle@oracleserver bin]$ ./emctl start agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Starting agent ............. started.
Bash

I first did a stop/start to clear my conscience, and it correctly lists the targets that are being monitored.

[oracle@oracleserver bin]$ ./emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
[agent13c1_3_oracleserver_5209, oracle_home]
[oracleserver/server_os, oracle_si_server_os]
[oracleserver, host]
[oracleserver:3872, oracle_emd]
[cdbgi01_oracleserver, oracle_database]
[LISTENER_oracleserver, oracle_listener]
[+ASM_oracleserver, osm_instance]
[OraDB19Home1_2_oracleserver_6741, oracle_home]
[OraGI19Home1_1_oracleserver_9873, oracle_home]
[cdbgi01_oracleserver_CDBROOT, oracle_pdb]
[cdbgi01_oracleserver_PDBGI, oracle_pdb]
[has_oracleserver, has]
Bash

I tried to run the collection in Oracle Home, which wasn’t bringing up the metrics, and the error appeared.

[oracle@oracleserver bin]$ ./emctl control agent runCollection OraDB19Home1_2_oracleserver_6741:oracle_home oracle_home_config
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection error:connection to the agent has been lost
SQL

Solution

[oracle@oracleserver bin]$ ./emctl clearstate agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
EMD clearstate completed successfully
Bash
[oracle@oracleserver bin]$ ./emctl upload
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
Bash
[oracle@oracleserver bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 13.4.0.0.0
OMS Version            : 13.4.0.0.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /oem_agent/agent_inst
Agent Log Directory    : /oem_agent/agent_inst/sysman/log
Agent Binaries         : /oem_agent/agent_13.4.0.0.0
Core JAR Location      : /oem_agent/agent_13.4.0.0.0/jlib
Agent Process ID       : 770754
Parent Process ID      : 768965
Agent URL              : https://oracleserver:3872/emd/main/
Local Agent URL in NAT : https://oracleserver:3872/emd/main/
Repository URL         : https://oemserver:4903/empbs/upload
Started at             : 2023-12-03 00:26:05
Started by user        : oracle
Operating System       : Linux version 4.18.0-477.21.1.el8_8.x86_64 (amd64)
Number of Targets      : 12
Last Reload            : (none)
Last successful upload                       : 2023-12-03 00:27:57
Last attempted upload                        : 2023-12-03 00:28:02
Total Megabytes of XML files uploaded so far : 0.05
Number of XML files pending upload           : 3
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 82.35%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2023-12-03 00:27:09
Last successful heartbeat to OMS             : 2023-12-03 00:27:09
Next scheduled heartbeat to OMS              : 2023-12-03 00:28:09

---------------------------------------------------------------
Agent is Running and Ready
Bash
[oracle@oracleserver bin]$ ./emctl control agent runCollection OraDB19Home1_2_oracleserver_6741:oracle_home oracle_home_config
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully
Bash

After executing the above commands, the collection that had shown an error started working correctly again.

References:

GrepORA

Previous Article

Error PRCD-1229 after manual upgrade

Next Article

ORA-12547: TNS:lost contact

Write a Comment

Leave a Comment

Your email address will not be published. Required fields are marked *