Shell scripting question

[Ridzuan Zakaria]

Hi,

Does anyone know how to get extract the following message from below log.

LLINE1 : CREATE OR REPLACE PACKAGE BODY dbms_repcat_utl wrapped
*
LINE2: ERROR at line 1:

LINE3: ORA-04031: unable to allocate 4160 bytes of shared memory ("shared
pool","unknown object","sga heap(1,0)","state objects")

If would like to grep any ORA-04031 error in LINE3 together with message from LINE1 (i.e CREATE OR REPLACE PACKAGE BODY dbms_repcat_utl wrapped)

How do I do that in Korn Shell? "grep ORA-04031" will only return LINE3.

Thanks in advance

[Sundar_7]

awk '$1 ~ /CREATE/ { LINE1=$0; getline; getline LINE3; if( LINE3 ~ /.*ORA-04031.*/) printf("%s\n%s\n",LINE1,LIN
E3) }'

Wait for sometime - I am sure people will come up with better scripts :-)

[Abdul Rahiman · Accepted solution]

Have a look at this thread.. similar discussion,
look especially the ggrep, greb and perl solutions..

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=630972

regds,
Abdul.

[Ridzuan Zakaria]

Thanks.