Re: Orcale alert log

On Mar 25, 9:11 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 25, 7:24 am, Chris <christian.doll...._at_googlemail.com> wrote:
>
> > Hello,
>
> > currently I am testing to parse the oracle alert log for all ora-<any
> > number> errors. I just want to check if my monitoring rules for the
> > alert log are working as expected.
> > For this need I have an empty oracle database. The challenge is, I am
> > not an dba, I am responsible for ITSM, this means I have no knowledge
> > about oracle.
>
> > Has anyone of you an idea what I could do to create some ora errors
> > without destroying the whole application?
>
> > thanks
>
> > Chris
>
> Perhaps you might consider doing some testing of a file that you
> create and populate with various ORA- errors.  This is much less
> dangerous than trying to actually cause oracle and application
> problems in a real running database.
>
> In other words, you could get someone to send you an oracle alert log
> and use an editor such as notepad or textpad or vi and put in various
> errors.  Where can you find the text of errors?  Well if you google on
> things like ORA- that's one way or look at oracle documentation fromhttp://tahiti.oracle.comor even search this newsgroup you can find
> lots of examples.
>
> Newer versions of oracle have some pretty good built in automation
> where these errors can be found from oracle provided tools that
> includes alerting and email capabilities but yes many sites have their
> own home grown monitoring solutions.  If you do a little more google
> around you can find some examples of what people have already put
> together as packaged solutions to do just what you are asking for
> instead of trying to re-invent the wheel.

Chris, I think HP has given you some pretty good advice.

Prior to 11g the alert log is just a text file so you can develop your code against any dummied up text file you create. Once you think you have your script ready you could ask some individuals to send you sections of altert logs that have errors in them to test with.

HTH -- Mark D Powell -- Received on Tue Mar 25 2008 - 09:23:36 CDT