SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 05:41 AM
| |||
| |||
 Re: Alert File Errors peter schreef: > Hello DBAs, > > Please tell me, which errors can come in Alert File ( daily problems ), > atleast ora-XXXX numbers excluding ora-1555 and ora-00600. Now, that would be nice one - excluding the most important errors Oracle can throw at you: "There's something awfully wrong here, so wrong, we have not yet invented an error message for it, let's call it 600" And of course the Error Messages and Codes Manual would help you out - you could have ordered a documentation kit with your V7.3 CD's... -- Regards, Frank van Bortel Top-posting is one way to shut me up...      |
|
02-25-2008, 05:41 AM
| |||
| |||
| Re: Alert File Errors peter wrote: > Hello DBAs, > > Please tell me, which errors can come in Alert File ( daily problems ), > atleast ora-XXXX numbers excluding ora-1555 and ora-00600. Or any site > where I can get alert file errors. > > Thank You The most usual are those space-related (1650, 1652-55, a few others in 16xx range and 323x range,) 7445 (unhandled exception, core dump), 1631 and 1632 (max # of extents reached...,) 12012 (job failed.) You will want to watch for SMON and PMON messages as well (these are usually critical and mean that the instance was aborted due to an unrecoverable or potentially damaging error.) I rarely seen other errors in alert file, though I'm being bothered with some obscure TNS error lately, which I currently attribute to mod_plsql connection pooling bug, but not completely sure about its origin still. Hth, Vladimir M. Zakharychev N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com |
|
02-25-2008, 05:42 AM
| ||||
| ||||
| Re: Alert File Errors I would just code to catch all ORA- errors and have them sent to someone for review as soon as they come in (either sent via email, pager, etc). Most ORA- errors should be reviewed for possible issues (some errors are more critical than others). If you are running RAC, you will also want to monitor the cluster manager services for errors as well. peter wrote: > Hello DBAs, > > Please tell me, which errors can come in Alert File ( daily problems ), > atleast ora-XXXX numbers excluding ora-1555 and ora-00600. Or any site > where I can get alert file errors. > > Thank You |
Linear Mode
