Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9.2 Log Miner Scripts?
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3fae9164$0$3790$afc38c87_at_news.optusnet.com.au>...
> "Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
> news:qbfsqv0t5ds657rojd7lj42vfgbqljdhpo_at_4ax.com...
> > On Fri, 7 Nov 2003 09:43:39 +1100, "Howard J. Rogers"
> > <hjr_at_dizwell.com> wrote:
> >
> > >Yes you can. It was a new feature introduced in 9i, and is in fact the
> > >default way of working for the GUI Log Miner Viewer in OEM.
> > >
> > >Regards
> > >HJR
> >
> > So why did I receive error messages about not having a catalog file
> > using exactly this tool?
>
> I don't know. If you go into the Log Miner Viewer, then one of the buttons
> on the top let's you specify where you want to 'load' the dictionary from.
> There are three choices: the online data dictionary, ye olde static
> dictionary file, or from within a redo log (because another new feature is
> that you can build the static dictionary file into an online log and thus
> get it archived within the thing its destined to be used to analyze). A
> fresh OEM installation has the 'use online catalog' option selected by
> default.
>
> Is it possible you or a colleague modified that choice at some point in the
> past, and the preference gets saved?
>
> Or is it possible that you were using the viewer to analyze another
> database's logs, in which case the online catalog is not the one you need to
> perform the analysis?
>
> I don't know why you received your error, but the functionality is
> definitely there, all the same.
>
> Regards
> HJR
Unfortunately this is simply not true, at least not for Oracle
Logminer viewer 9.2.0.1.0. The choices and buttons you describe are
simply not there.
You can use Set dictionary at which point you are forced to specify a
file name. The data dictionary can not be used at all.
So this might apply only when you are using the newest upgrade/patch,
and it starts to concern/annoy me a bit upgrades are being released
with the speed of the light and functionality is ever being added.
Needless to say, we can't afford to install a patch/upgrade on all
systems every few months. We rolled out OEM9i on all systems only 2
months ago.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Mon Nov 10 2003 - 09:37:14 CST