RE: Cloud Control Issue

Cloud control is 13.5.0.10. The agent is 13.4.

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: Sweetser, Joe <jsweetser_at_icat.com> Sent: Tuesday, January 9, 2024 2:28 PM
To: dinch.osman_at_gmail.com; Scott Canaan <srcdco_at_rit.edu> Cc: oracle-l_at_freelists.org
Subject: RE: Cloud Control Issue

You didn’t mention the version involved, but Oracle Doc ID 2417792.1 has what looks like the same error message to me. Even down to “return value 57”…

-joe

Please note: I am currently working 3 days/week (Tues, Wed, Thurs). Expect delayed responses to emails outside of those days.

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Osman DINC Sent: Tuesday, January 9, 2024 12:25 PM To: srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: Cloud Control Issue

CAUTION: This email originated outside the company. Do not click links or open attachments unless you are expecting them from the sender.

Hi Scott,

There is a document in MOS that looks like it is related to this issue. Doc ID 1944859.1
EM 13c, 12c: Agent Crashes or Restarts with 'Out Of Memory Error' 'target.interaction.execution.SeverityLogWriter' Reported in Heapdump (Doc ID 1944859.1)

Hope it helps.
CAUSE A collection is generating a large number of alerts in a very short time span causing the out of memory error. In this case, it was found to be related to Database target collection:

oracle_database,ORCL,UserAudit,DB_User,1412689923926,Metric_Threshold_Alert,UNDEFINED,Discard State

SOLUTION The above metric collection causing the excessive number of alerts must be investigated at the target level.

As an immediate relief, the following workaround can be used:

1. Set the following parameter on the EM Agent: $/AGENT_INST/bin/emctl setproperty agent -allow_new -name _traceSeverityForTypes -value noTypes
2. Restart the agent:

$/AGENT_INST/bin/emctl stop agent
$/AGENT_INST/bin/emctl start agent

Regards,
Osman DİNÇ
InsaneDba
https://insanedba.blogspot.com/<https://urldefense.com/v3/__https:/insanedba.blogspot.com/__;!!O7V3aRRsHkZJLA!BWckmiZbCj_KJcgGGBFTs3RwdlXtThTdxgf9MluBn--OWgW8OhHVV1jtMh7oO7kuKCxrj-hQvkM3lJG7U2s$>

Scott Canaan <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>>, 9 Oca 2024 Sal, 22:16 tarihinde şunu yazdı: We are in the process of migrating our databases from Red Hat 7 to Red Hat 8. When the new VMs are set up, the cloud control agent runs fine. As soon as we configure the database and listener for the new server, it crashes. It will start, but won’t stay up. The only thing I can find in the log is:

Agent is going down due to an OutOfMemoryError
----- 2024-01-09 13:28:25,329::2923::Checking status of EMAgent : 1951180 -----

• 2024-01-09 13:28:25,329::2923::EMAgent exited at 2024-01-09 13:28:25,329 with return value 57. -----
• 2024-01-09 13:28:25,329::2923::EMAgent will be restarted because of an Out of Memory Exception. -----
• 2024-01-09 13:28:25,330::2923::EMAgent is Thrashing. Exiting loop. -----
• 2024-01-09 13:28:25,330::2923::Commiting Process death. -----
• 2024-01-09 13:28:25,330::2923::writeAbnormalExitTimestampToAgntStmp: exitCause=OOM : restartRequired=0 -----
• 2024-01-09 13:28:25,330::2923::Exited due to Thrash. -----

In working with the sys admin, he said that it’s our problem and has no idea where to look and which parameter needs to be changed, let alone what to change it to.

Where do we look to figure this out?

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659 CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

NOTE: Coverage cannot be bound or altered by sending an email. You must receive written confirmation from a representative of our firm to put coverage in force or make changes to an existing policy.

EMAIL DISCLAIMER: This e-mail, including any attachments that accompany it, may contain information that is confidential or privileged. This e-mail is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail and are not an intended recipient, any disclosure, distribution, copying or other use or retention of this email or information contained within it are prohibited. If you have received this email in error, please immediately reply to the sender via e-mail and also permanently delete all copies of the original message together with any of its attachments from your computer or device.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 09 2024 - 20:32:44 CET