PING OMS
From RDS database
SQL> SELECT
rdsadmin.rdsadmin_oem_agent_tasks.ping_oms_oem_agent() as TASK_ID from DUAL;
TASK_ID
--------------------------------------------------------------------------------
16968905670056-4470
View the status output
SQL> SELECT text FROM
table(rdsadmin.rds_file_util.read_text_file('BDUMP','dbtask-16968905670056-4470.log'));
TEXT
--------------------------------------------------------------------------------
2023-10-09 22:29:32.557 UTC [INFO ] Oracle Enterprise
Manager Cloud Control 13c
Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD pingOMS completed successfully
2023-10-09 22:29:32.558 UTC [INFO ] The task finished
successfully.
6 rows selected.
Check Agent
Status
SQL> SELECT
rdsadmin.rdsadmin_oem_agent_tasks.get_status_oem_agent() as TASK_ID from DUAL;
TASK_ID
--------------------------------------------------------------------------------
1696890801000-4470
SQL> SELECT text FROM table(rdsadmin.rds_file_util.read_text_file('BDUMP','dbtask-1696890801000-4470.log'));
TEXT
--------------------------------------------------------------------------------
2023-10-09 22:33:23.486 UTC [INFO ] 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.5.0.0.0
Protocol Version
: 12.1.0.1.0
Agent Home
: /home/rdsdb/agent/app/agent_inst
Agent Log Directory
: /home/rdsdb/agent/app/agent_inst/sysman/log
Agent Binaries
: /home/rdsdb/agent/app/agent_13.4.0.0.0
Core JAR Location
: /home/rdsdb/agent/app/agent_13.4.0.0.0/jlib
Agent Process ID
: 1076
Parent Process ID
: 1032
Agent URL
: https://mydb.ckpij9egh4g.us-west-2.rds.amazonaws.com
:3872/emd/main/
Local Agent URL in NAT : https://mydb.ckpij9egh4g.us-west-2.rds.amazonaws.com
:3872/emd/main/
Repository URL
: https://omsserver.domain.com:4904/empbs/upload
Started at
: 2023-09-19 11:20:48
Started by user
: rdsdb
Operating System
: Linux version 4.1.12-124.77.2.el7uek.x86_64 (amd64)
Number of Targets
: 2
Last Reload
: (none)
Last successful upload : 2023-10-09 22:32:08
Last attempted upload : 2023-10-09 22:32:08
Total Megabytes of XML files uploaded so far : 26.03
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 53.44%
Collection Status : Collections
enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2023-10-09 22:32:55
Last successful heartbeat to OMS : 2023-10-09 22:32:55
Next scheduled heartbeat to OMS : 2023-10-09 22:33:56
---------------------------------------------------------------
Agent is Running and Ready
2023-10-09 22:33:23.487 UTC [INFO ] The task finished
successfully.
36 rows selected.
Refer
more :
x
