topic Re: Shell scripting question in Operating System - HP-UX

Shell scripting question

Ridzuan Zakaria — Thu, 15 Jul 2004 17:19:23 GMT

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

Re: Shell scripting question

Sundar_7 — Thu, 15 Jul 2004 17:39:25 GMT

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 :-)

Re: Shell scripting question

Abdul Rahiman — Thu, 15 Jul 2004 17:48:19 GMT

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.

Re: Shell scripting question

Ridzuan Zakaria — Thu, 15 Jul 2004 18:22:16 GMT

Thanks.