[OAUGNetDBA]-Re: SQL statement to get the applied patches list ?

[dave <david.best@gmail.com>]

I've experienced issues with OAM detecting whether or not a patch has
been applied.  Personally I use ad_bugs.

So one way would be to create a database link to the databases  and
query against that table.

Quick and dirty way I guess..

On Mon, Aug 18, 2008 at 4:27 AM, GUERIN Jean-Luc <GUERINJL@essilor.fr> wrote:
> Hello
>
> We would like to compare the fine patch level of different EBS 11i
> environments.
> We need the sql statement to perform it (including the ones applied as
> merged patches).
> One way would be to trap the SQL behind the report generated by OAM.
> Does someone know how to get it?
> Thank you in advance.
> Regards.
>
> Jean-Luc GUERIN
> ESSILOR INTERNATIONAL
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> Send administrative queries to  <OAUGNetDBA-request@oaug.com>
>
>

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>