Re: EM10gr2 Grid Control Reporting Question

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 4 Jun 2008 13:23:54 -0500 (CDT)
Message-ID: <50386.12.17.117.251.1212603834.squirrel@12.17.117.251>


I've gotten around this limitation by creating DB links from the repository DB to the target DBs. Of course all the proper performance and security checks pertinent to your environment need to be done, but it works for the very occasional reporting that I need to do through GC.

HTH! Rich

> Ahh, a topic near and dear to me :) Oracle EM reporting. The thing to note
> about reports is that you are logging into the OMS Repository, not the
> source database. Therefore, dba_audit_trail (if you had access to it) would
> be the local copy on your OMS Repository, not the target database. If there
> is an existing, canned report int he Report Repository, your best bet is to
> do a 'CREATE LIKE' and see what the source of the data is. It may be a SQL
> query or could be an included metric (I haven't checked). As of 10.2.0.3, I
> don't think reporting supported reports outside of the OMS Repository.
>
> --
> Bradd Piontek

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 04 2008 - 13:23:54 CDT

Original text of this message