EM 13c: Delay in OEM Mail Alert Notifications After Event is Generated
(Doc ID 3071420.1)
Last updated on FEBRUARY 22, 2025
Applies to:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Enterprise Manager Cloud Control (OEM) is delivering mail notifications after delay of few hours.
- The events are getting generated for all metrics as expected, but once the event is generated, its not picked by notification sub-system on time.
- For example, the below alerts is received on mailbox at 11 PM, but the event was created in OEM at 6 PM.
Target type=Host
Target name=<Target Name>
Categories=Capacity
Message=Swap Utilization is 86.012%, crossed warning (75) or critical (80) threshold.
Severity=Critical
Event reported time=Jan 22, 2025 11:04:25 PM EST
$ <EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms_pbs.log
2025-01-13 01:04:57,819 [GCLoader[severity] - https://<Host>:3872/emd/main/] ERROR gcloader.AlertsApi logp.251 - AlertsApi:load: Failed to insert severity: java.sql.SQLException: ORA-01654: unable to extend index SYSMAN.EM_VIOLATIONS_PK by 8192 in tablespace MGMT_TABLESPACE
ORA-06512: at line 13
ORA-06512: at line 7
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105) ~[ojdbc8dms.jar:19.3.0.0.0]
2025-01-13 01:04:57,821 [GCLoader[severity] - https://<Host>:3872/emd/main/] ERROR gcloader.DataLoader logp.251 - LOADER ERROR: Failed to upload alert from agent https://<Host>:3872/emd/main/ [uploadType severity, tracking key 73563.1736738203200] :
oracle.sysman.core.pbs.gcloader.ReceiveException: ERROR-800|ORA-01654: unable to extend index SYSMAN.EM_VIOLATIONS_PK by 8192 in tablespace MGMT_TABLESPACE
ORA-06512: at line 13
ORA-06512: at line 7
at oracle.sysman.core.pbs.gcloader.DataLoader.loadAlertsImpl(DataLoader.java:1628) ~[emCorePBS.jar:?]
at oracle.sysman.core.pbs.gcloader.XMLDocumentDataParser.endElement(XMLDocumentDataParser.java:434) ~[emCorePBS.jar:?]
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |