topic Re: Script help in Operating System - Linux

Script help

Prashant Zanwar_4 — Fri, 12 Aug 2005 15:34:35 GMT

Hi,
I want a script which will get for a pattern, and depending on Line number pattern, will display 4Lines above the line and 4Line Below that line. I am finding it challening!
Thanks in advance
Prashant

Re: Script help

Tom Schroll — Fri, 12 Aug 2005 15:42:26 GMT

Prashant,

Could you send an example of input and what you would like to see on output? How big is the input data file (under 2GB?) I'm thinking awk can do this using arrays. But I'd like an example so that it is clear what we are trying to do. Thanks!

-- Tom

Re: Script help

Prashant Zanwar_4 — Fri, 12 Aug 2005 15:48:15 GMT

I am trying to Trace oracle errors, Just want to check for particular ora error, few lines before that and few lines after it.
Thanks and regards
Prashant

Re: Script help

Sandman! — Fri, 12 Aug 2005 15:58:18 GMT

What would be a good example of the oracle error you are trying to extract from the file. A concrete example will help.

cheers!

Re: Script help

Prashant Zanwar_4 — Fri, 12 Aug 2005 16:00:17 GMT

Completed: drop rollback segment RB31
Fri Aug 12 05:34:56 2005
drop rollback segment RB32
Completed: drop rollback segment RB32
Fri Aug 12 05:36:08 2005
drop tablespace RBS
Fri Aug 12 05:36:36 2005
Errors in file /oracle/admin/COREPROD/bdump/coreprod_j002_7027.trc:
ORA-12012: error on auto execute of job 137728
ORA-01405: fetched column value is NULL
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5636
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6061
ORA-06512: at "SYS.DBMS_AQADM", line 895
ORA-06512: at line 1
Fri Aug 12 05:36:36 2005
Errors in file /oracle/admin/COREPROD/bdump/coreprod_j001_7025.trc:

Here are errors pasted.
While these errors can be many in file, if provision can be made to see from recent dates of 2-3 days will be great.
Thanks
Prashant

Re: Script help

Mel Burslan — Fri, 12 Aug 2005 16:02:37 GMT

FILE=filename.here
PATTERN="string_here"
for lineno in `grep -n $PATTERN $FILE|cut -d: -f1`
do
(( TOP=$lineno-5 ))
(( BOT=$lineno+5 ))
cat $FILE | sed -e "${BOT},\$d" | sed -e "1,${TOP}d"
echo "=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=" # block separator
done

this should do the trick.. even for multiple instances of the same string repeating in the source file.

HTH

Re: Script help

Sandman! — Fri, 12 Aug 2005 16:07:34 GMT

If you're trying to capture 4-5 lines above/below the "ORA-06512" errors that are popping up in your trace file then a short script like the one below will do what you are interested in accomplishing:

=============================================
# cat - <> /ORA-06512/-4,/ORA-06512/+4 p
> wq
> EOF
=============================================

cheers!!!

Re: Script help

Sandman! — Fri, 12 Aug 2005 16:34:05 GMT

Change the "wq" to "q" as you're not writing the output to a file.

Re: Script help

Prashant Zanwar_4 — Fri, 12 Aug 2005 18:40:18 GMT

Thanks you both, 1st soluion by Mel is working !
While I dont find 2nd solution from Sandman not working, basically whole file is scrolling..AM I doing anything wrong.
Prashant

Re: Script help

Sandman! — Sat, 13 Aug 2005 11:39:58 GMT

Prashant,

I tested this code on your trace file and it worked fine. But, I'm not sure why its not working on yours.

Try this one and replace string ORA-6512 with actual pattern you are searching for:

# ex -s <> /ORA-06512/-4,/ORA-06512/+4 p
> EOF

Re: Script help

Max Kublin — Wed, 17 Aug 2005 12:39:21 GMT

Hi,

please try the attached script.
It should perfectly match your needs.
Docu and help is included.

Max

Re: Script help

Stuart Browne — Thu, 18 Aug 2005 08:21:42 GMT

.. on a side note .. Have you thought of installing GNU's 'grep' ? It has the -A, -B and -C flags, for lines-after, lines-before, and lines-before-and-after..

unf.. ;)