Re: Orcale alert log
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 26 Mar 2008 01:30:45 GMT
Message-ID: <9HhGj.12188$6J3.243@newsfe13.phx>
>> 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.comoreven 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 --
Date: Wed, 26 Mar 2008 01:30:45 GMT
Message-ID: <9HhGj.12188$6J3.243@newsfe13.phx>
Banavara <rbanavara_at_gmail.com> wrote in
news:0e3b3e3f-80c1-4bc9-b9ee-f38349bba982_at_z38g2000hsc.googlegroups.com:
> On Mar 25, 10:23 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>> 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.comoreven 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 --
> > Prior to 11g... does this mean alert log is created in a different way > from 11g onwards? > > -banavara >
Yes in V11, it is an XML formatted file. Received on Tue Mar 25 2008 - 20:30:45 CDT