Thanks Bobby,
All of the tables/views mentioned happen to be empty in our environment. We do
have LCM licenses, so I’m not sure if there’s something we need to enable for
the agents to send data, but we aren’t seeing anything in the tables as of now.
I don’t see any documentation online nor notes on MOS about these objects, so
I’m not sure how we’d know how they’re intended to be used.
Thanks,
Scott
From: Bobby Curtis [mailto:curtisbl@xxxxxxxxx]
Sent: Tuesday, October 11, 2016 10:34 AM
To: Deas, Scott <Scott.Deas@xxxxxxx>
Cc: rjoralist3@xxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: dba_registry info in OEM repository
Has anyone looked at the SYSMAN.MGMT$OS_PATCH or MGMT$OS_PATCHSET views for
patches. For the registry question, I think you might be able to use
SYSMAN.MGMT$EM_LMS_DBA_REGISTRY view. I think that view requires Lifecycle
Management pack though.
Bobby
On Oct 11, 2016, at 10:17 AM, Deas, Scott
<Scott.Deas@xxxxxxx<mailto:Scott.Deas@xxxxxxx>> wrote:
Rich,
Agreed. I looked through the OEM documentation and scanned the data
dictionary, but I don’t see this info.
The metric extension would be useful once something goes invalid, but I’m still
hopeful that this is somewhere in the repository where we could query the
enterprise all at once, versus waiting for an event to trigger or checking a
target at a time.
Thanks,
Scott
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich J
Sent: Tuesday, October 11, 2016 9:14 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: dba_registry info in OEM repository
On 2016/10/10 20:29, Deas, Scott wrote:
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.
Not any help right now, but for the future, it sounds like a relatively easy
Metric Extension in EM12c would do the trick.
I just might be creating one of my own to catch DBs that haven't had their
catbundle run for example...
Rich
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.**
