Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log file

Re: Alert log file

From: Robert Scheer <rbscheer_at_my-deja.com>
Date: 11 Oct 2006 09:53:50 -0700
Message-ID: <1160585630.707591.284030@h48g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US