Home » RDBMS Server » Server Administration » Alerts or Errors Stored in which table or vies? (oracle 9i,9.2.0.1,Redhad Advance Server)
Alerts or Errors Stored in which table or vies? [message #332548] Tue, 08 July 2008 23:32 Go to next message
chintan.patel
Messages: 140
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
Re: Alerts or Errors Stored in which table or vies? [message #332555 is a reply to message #332548] Tue, 08 July 2008 23:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Alerts or Errors Stored in which table or vies? [message #333549 is a reply to message #332548] Sat, 12 July 2008 09:43 Go to previous message
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
Previous Topic: Available space question
Next Topic: library cache ?
Goto Forum:
  


Current Time: Sat Dec 10 03:28:08 CST 2016

Total time taken to generate the page: 0.09204 seconds