Re: dba_registry info in OEM repository

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Tue, 11 Oct 2016 01:29:22 +0000
Message-ID: <D6879FEC-367F-4692-BB65-FAF1F4697E40_at_lfg.com>

Hi Pete,

The dba_registry table records the version and current status of installed components in the database (VALID/INVALID). We had issues with the July 2016 PSU for 11.2.0.4 that caused the JAVAVM component to become INVALID - a miss on our part during the patch application.

If we had the registry information for our entire enterprise of 200+ databases available within OEM, we'd be able to monitor this more efficiently. It might be viewable within the OEM interface once we select a target, but I was wondering if the agents send that data to the OMS so it's available in the repository.

Thanks,
Scott

On Oct 10, 2016, at 20:05, Peter Sharman <pete.sharman_at_oracle.com<mailto:pete.sharman_at_oracle.com>> wrote:

Scott

Must be my morning for saying I don’t know. :)

What sort of information are you after out of that view? I must say I haven’t looked at it to even know what’s there.

Pete
<image001.jpg>

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA Phone: +61262924095<tel:+61262924095> | | Mobile: +61414443449 Email: pete.sharman_at_oracle.com<mailto:pete.sharman_at_oracle.com> Twitter: _at_SharmanPete LinkedIn: au.linkedin.com/in/<http://au.linkedin.com/in/>petesharman Website: petewhodidnottweet.com<http://petewhodidnottweet.com>

---

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook

"Oh no, it's not, it's much harder than that!" Bruce Pihlamae, long term Oracle DBA

---

From: Deas, Scott [mailto:Scott.Deas_at_lfg.com] Sent: Tuesday, October 11, 2016 07:58 AM To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: dba_registry info in OEM repository

All,

We ran into some issues with patching this past weekend, and after working on a cluster with a dozen or so databases, I was wondering if the data in dba_registry is available anywhere in the OEM repository where we could see it (and monitor it) in a centralized fashion.

OEM is at version 12.1.0.5, repository is 12.1.0.2, all running on OEL (don’t think that matters).

Thanks,
Scott

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l






(image/jpeg attachment: image001.jpg)

Received on Tue Oct 11 2016 - 03:29:22 CEST