Re: Intermittent Failure When Accessing DB Constantly?

On May 8, 5:52 pm, "lazyboy..._at_yahoo.com" <lazyboy..._at_yahoo.com> wrote:
> Thank you all for a quick response, and I like the idea of oracle
> error messages. The script will exist out when it can't retrieve the
> record in a table, and the record is always there. In other words, we
> don't have to run an insert query at all. So, does anyone know where
> the oracle error msg log file located? For instance, you run a select
> statement to display a unavailable field in a table, it'll error out
> on a terminal, but does it record it somewhere in a file as well? If
> it does, please let me know where it is & file name. I thought it's in
> one of those dump directories, but so far can't find it.

I think maybe you should talk to your oracle dba for this system. Oracle has an alert log but it "usually" contains fairly severe type errors in it or system shutdown restarts ... not often ( mileage will vary ) application related errors.

Do you use sqlplus to invoke the script? How do you run it exactly? What is the script coded in?

Usually if you are driving the script via cron or some scheduling type of software any oracle error messages ( if any ) that you encounter should be recorded and available somewhere. Yes sometimes you can get trace files *.trc in the dump directories ( usually udump ) ... but that's not exactly what we are looking for.

When you execute your script and it has a "problem" what does all the output look like?

When you execute your script and it runs "normally" what does the output look like?

What exactly does your script contain?

That's the type of info that people will need to help you further. Received on Tue May 08 2007 - 17:01:15 CDT