RE: OEM Grid Report Q - 10.2

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Mon, 24 Nov 2008 13:40:09 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F034@ADMINMAIL1.ui.uillinois.edu>


Hi Jessie,

You are definitely onto something, I changed the s.target_guid to s.target_type = 'oracle_database', and I'm at least getting some data. Thanks for the information, I'll be able to figure out the rest based on your info below.

Thanks! - Chris

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Monday, November 24, 2008 1:30 PM
To: oracle-l_at_freelists.org
Subject: Re: OEM Grid Report Q - 10.2

Chris,

If you look at the definition of the "Non-Default Initialization Parameters"
SQL in the report you copied, it's filtering on the user's DB selection.

Since you're looking for all DBs to be included, you could replace this:

s.target_guid = ??EMIP_BIND_TARGET_GUID??

with:

s.target_type = 'oracle_database'

...in your copy of the report. This most likely won't get you exactly what
you're looking for, but perhaps it's a step in the right direction.

GL!

Rich

> I'd like to create a report of all init parameters for every DB in
grid
> control. I've set up a group to include all databases for this
purpose.
>
> The report I've modified is 'Database Instance Overview', and I've set
> the target as the group. I'm getting this when running though:
>
> Error rendering element. Exception: ORA-20206: ORA-06512: at
> "SYSMAN.EMD_DATABASE", line 1165 ORA-01403: no data found ORA-06512:
at
> "SYSMAN.MGMT_DATABASE_OVERVIEW", line 80 ORA-06512: at line 2
>
> Web search is pretty slim for the above error. Any thoughts? Anyone
> have a different solution for grabbing the init's across the
enterprise?
> Ultimately want to compare dev/test/prod for each instance.
>
> Thanks- Chris
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 24 2008 - 13:40:09 CST

Original text of this message