Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log file
Hi Frank,
yes, it has been working for months. The problem is that when something goes wrong I can't see any log with information about it. Beyond the log files, are there any system tables I can look at?
Show Parameter shows me the path configured at Init.ora.
Thanks,
Robert Scheer
frank.van.bortel_at_gmail.com wrote:
> Robert Scheer schreef:
>
> > Hi.
> >
> > I am trying to find the error log files from Oracle, but all my folders
> > are empty. As an example, my BDUMP folder is empty, though I have the
> > BACKGROUND_DUMP_DEST parameter correctly defined. In order to get these
>
> Did you check what the instance actually uses? Show parameter
> background_dump
> will tell you that
>
> > log files working, do I need to set the SQL_TRACE parameter to True?
> > Now this parameter is set to False.
>
> Fail to see the connection with the above
>
> >
> > My main problem is that I need to log the activity of a job. When there
> > is an error during the execution, the job is automatically set to
> > broken but I can't find the error that caused the break anywhere.
> >
>
> Does it ever execute correctly?
Received on Wed Oct 11 2006 - 11:53:50 CDT