Shell Programming and Scripting

Hi All,

Does anyone have any shell script out there that looks into Oracle trace files generated in the bdump, cdump & udump directories & reports on the contents (errors) within these files.
Your help is highly appreciated.

Regards,

- divroro12 -

Can you explain your requirement a bit more.

As per my understanding u need to check the trace files for word "error" and print that line to console.

Am i correct?

Actually by "error" i mean the following entries: "Error", "WARN", "ORA" that are created within the trace files.
And yes, we need to check the trace files for these words & either send the output to another file or print to the console.

- divroro12 -

On our system we stop/start Oracle every day to allow for a backup.
This process generates one alert log and one ".trc" log for the start and another pair for the stop. By using a set of logs saved from a good day it is possible to use this list as a reference list of "normal" messages. The script needs to ignore lines which normally change such as datestamp lines, "mount id" lines and redo log switches.

It is then a simple task to extract any exception messages from current logs by eliminating "normal" messages. This method also spots when people change Oracle startup parameters.

Note: The absence of a log can be a sign of big trouble.

you can use grep

to show on console

Code:

/usr/xpg4/bin/grep -E 'Error|WARN|ORA' " YOUR PATH of trace files"

or redirect to a log file

Code:

/usr/xpg4/bin/grep -E 'Error|WARN|ORA'  "our ora path" >> ORAError.log

The problem with grep of the string "ORA" from these logs is that it occurs in normal day-to-day messages.