Orcale alert log
Chris
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
hpuxrac
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 from
http://tahiti.oracle.com or 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.
Mark D Powell
> On Mar 25, 7:24 am, Chris <christian.doll....@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
> 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 --
Banavara
> On Mar 25, 9:11 am, hpuxrac <johnbhur...@sbcglobal.net> wrote:
>
>
>
> > On Mar 25, 7:24 am, Chris <christian.doll....@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
> > 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 --
Prior to 11g... does this mean alert log is created in a different way
from 11g onwards?
-banavara
S. Anthony Sequeira
>
> Prior to 11g... does this mean alert log is created in a different way
> from 11g onwards?
Yes, an XML alert log is created for you. background_dump_dest is
deprecated. A text based file is still available in
$ADR_BASE/diag/rdbms/dbname/instance/trace though.
To view the XML log a new utility adrci, Automatic Diagnostic Repository
Command Interface, with a slightly primitive interface which is
reminiscent of SQL*PLus text version. This also has other diagnostic
capabilities.
I'm not sure about the wisdom/value of deprecating the text alert log,
but it looks like that's the way things are going.
--
S. Anthony Sequeira
++
Clarke's Conclusion:
Never let your sense of morals interfere with doing the right thing.
++
Steve Howard
wrote:
> I'm not sure about the wisdom/value of deprecating the text alert log,
> but it looks like that's the way things are going.
I agree with this. XML is supposed to be valuable when it will be
exchanged with other systems that need to understand the data in its
otherwise unstructured data format.
How often are you gong to exchange an oracle instance alert log with
anything other than oracle software (including a support analyst)?
Yeah, I think I'll ship my alert log to one our vendors, in case he
needs it along with our other EDI stuff :)
Sometimes I think I should learn to sign my name...
<?xml version="1.0"?>
<full_name>
<first_name>Steve</first_name>
<last_name>Howard</last_name>
</full_name>
Niall Litchfield
> I agree with this. XML is supposed to be valuable when it will be
> exchanged with other systems that need to understand the data in its
> otherwise unstructured data format.
>
> How often are you gong to exchange an oracle instance alert log with
> anything other than oracle software (including a support analyst)?
> Yeah, I think I'll ship my alert log to one our vendors, in case he
> needs it along with our other EDI stuff :)
I also agree with the sentiment, but point out that two cases where
you might are
1) security
2) IT Service Management (aka ITIL) which applies here.
:(
Niall
Ana C. Dent
news:0e3b3e3f-80c1-4bc9...@z38g2000hsc.googlegroups.com:
Yes in V11, it is an XML formatted file.
joel garry
> On Mar 25, 5:18 pm, "S. Anthony Sequeira" <t...@sequeira.org.uk>
> wrote:
>
> > I'm not sure about the wisdom/value of deprecating the text alert log,
> > but it looks like that's the way things are going.
>
> I agree with this. XML is supposed to be valuable when it will be
> exchanged with other systems that need to understand the data in its
> otherwise unstructured data format.
>
> How often are you gong to exchange an oracle instance alert log with
> anything other than oracle software (including a support analyst)?
> Yeah, I think I'll ship my alert log to one our vendors, in case he
> needs it along with our other EDI stuff :)
I initially agreed with this (as I am biased from having spent far too
much time programming where XML is beyond not appropriate, even just
plain silly), but after some small amount of thought, the Oracle
monitoring software is indeed a cross platform tool and this may be an
appropriate use.
>
> Sometimes I think I should learn to sign my name...
>
> <?xml version="1.0"?>
> <full_name>
> <first_name>Steve</first_name>
> <last_name>Howard</last_name>
> </full_name>
Aw, how about a viral XML sig <g,d&r>
jg
--
@home.com is bogus.
http://donxml.com/allthingstechie/archive/2004/10/21/1449.aspx
Mark D Powell
wrote:
Niall, how does the XML alert log fit in with ITIL, which if I can
remember my CBT course work stands for something like Information
Technology Infrastructure Library.
Jim Smith
<daab5f9f-d0e6-4fe0...@d21g2000prf.googlegroups.com>,
joel garry <joel-...@home.com> writes
>>
>> How often are you gong to exchange an oracle instance alert log with
>> anything other than oracle software (including a support analyst)?
>> Yeah, I think I'll ship my alert log to one our vendors, in case he
>> needs it along with our other EDI stuff :)
>
>I initially agreed with this (as I am biased from having spent far too
>much time programming where XML is beyond not appropriate, even just
>plain silly), but after some small amount of thought, the Oracle
>monitoring software is indeed a cross platform tool and this may be an
>appropriate use.
>
But its not even valid xml. It is just a bunch of lines formatted with
tags. There is no overall document tag.
Of course you can't have an overall document tag in a file which is
constantly growing without a lot of rewriting the file.
--
Jim Smith