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

What you can do is

alter system set events '<Oracle error number> trace name errorstack level 1';

that will dump a tracefile whenever the error is encountered.

But note that sometimes turning it off doesn't work for certain sessions, so they may keep writing tracefiles.

Stefan

On Wed, Apr 30, 2008 at 6:44 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:

> 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
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l