Re: Auditing policies

EdStevens wrote:
> I know that OEM 10 has some very good reports on violations of
> recommeded policies, but the on-screen presentation does not seem to
> lend itself to producing printed reports. I'm playing around with a
> sql script (and maybe a shell and dos command scripts where necessary)
> to allowe me to approach a new system and pop out a single policy audit
> report.
>
> Examining the doco on each policy, then writing up the necessary
> commands to audit said policy --even with a lot of boilerplate code --
> is getting pretty cumbersom. Yet within Grid I've not been able to
> locate the acutal queries it uses to test each policy. Is there
> something in there I'm missing that would either produce the full
> report or at least show me the 'test code' I'd need to put in my own
> scripts?

You could always put a 10046 trace on to determine what code is being executed. However, this should be documented somewhere in OEM. You could submit a service request with your question and get oracle to point out exactly how this works ... assuming you are willing to wait for an answer.

Emailing Pete Finnigan also might be worth consideration. Received on Wed Dec 27 2006 - 12:21:54 CST