OraFAQ Forum: Server Administration » Alerts or Errors Stored in which table or vies?

Home » RDBMS Server » Server Administration » Alerts or Errors Stored in which table or vies? (oracle 9i,9.2.0.1,Redhad Advance Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alerts or Errors Stored in which table or vies? [message #332548]

Tue, 08 July 2008 23:32

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Hi Friends

i would like to know that in which table or view oracle stores its alert or errors which are shown in alert logfile. Actually i am planing to create a trigger/procedure which send alert mail to me whenever error accrues in database. it also send a mail whenever database startup or shutdown.

chintan patel

Report message to a moderator

Re: Alerts or Errors Stored in which table or vies? [message #332555 is a reply to message #332548]

Tue, 08 July 2008 23:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Nowhere
2/ You can use external table to reasd alert.log
3/ You can also use OEM which already has this feature

Regards
Michel

Report message to a moderator

Re: Alerts or Errors Stored in which table or vies? [message #333549 is a reply to message #332548]

Sat, 12 July 2008 09:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

along with michel suggestion.

I created trigger for database shutdown/startup
http://dbataj.blogspot.com/2007/09/sending-email-from-oracle-10g-server.html

Report message to a moderator

Previous Topic:	Available space question
Next Topic:	library cache ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 01:40:16 CST 2024