Re: init.ora parameter to log errors to the alert log
Date: Wed, 30 Apr 2008 19:41:45 +0200
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.
On Wed, Apr 30, 2008 at 6:44 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:
> 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?
> 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-lReceived on Wed Apr 30 2008 - 12:41:45 CDT