Showing posts with label AWS. Show all posts
Showing posts with label AWS. Show all posts

Monday, October 9, 2023

Check oracle OEM agent from AWS RDS database

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 :

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Options.OEMAgent.html#Oracle.Options.OEMAgent.limitations

 

x

Auto Scroll Stop Scroll