RE: init.ora parameter to log errors to the alert log

Also, I think Brandon answered your question, but on a related note, dbms_system.ksdwrt can be used to write to the alert log or trace file, explicitly. It, along with some other alert log writing functionality, is documented here: http://www.psoug.org/reference/dbms_system.html

-Mark

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Wednesday, April 30, 2008 12:45 PM To: oracle-l_at_freelists.org
Subject: init.ora parameter to log errors to the alert log

List,

Years ago I found a tip, you could add an entry in the init.ora file for a specific Oracle error that wouldn't normally get logged. Then when a user session encountered that error, the error would get logged in the alert log. Does anyone recall that?

Thanks,
Dennis Williams

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 30 2008 - 12:48:24 CDT