Shell Programming and Scripting

Hi,

i have a file called alert_pindb.log i need to grep and count for all the lines starting with "ORA-" but i need to exclude the line which is having "ORA-00600
"

i am using following syntax to count the ORA- nos

"grep \"ORA-\" alert_pindb.log | wc -l";

since ORA- may be anything like ORA-00000...99999

i need all ORA- errors but i do not want ORA-00600 here i need to exclude ORA-00600 ;

how i can change the above syntax to get count of all ora errors excluding ORA-00600

Thanks

Prakash

A simple solution would be to pipe your first grep results to another grep command like this..

Code:

grep ORA- alert_pindb.log | grep -v "ORA-00600" |wc -l

Hope that helps.

thx for your suggestion

Thanks

Prakash

hi,

the above command which u suggested is giving count of 608 lines which this file is having:
grep ORA- alert_pindb.log | grep -v "ORA-00600" |wc -l

since in this file as of now ora-00600 lines are 0

my requirements is

count(wc-l) should not be the number of lines present in alert log file i want if any error loged in this file apart from ora-00600 it should show a count > 0

because i have perl script which shoot me message if it found count is > 0 and i want this script should shoot me message if it found ora errors apart from ORA-00600

Thanks

Prakash

hi,

i think this will works.
grep -v ORA-00600 alert_pindb.log | grep ORA- alert_pindb.log |wc -l

thanks

prakash

The above suggested command will search for the string ORA- excluding instances of "ORA-00600" and will count the total matched lines. Or you could ommit the "wc -l" command and used the "-c" switch of grep instead. So what is the problem?

Code:

count(wc-l) should not be the number of lines present in alert log file i want if any error loged in this file apart from ora-00600 it should show a count > 0

It is possible that your count will be equal to the number of lines of your log file IF all the lines contains the string "ORA-"..

Can you please elaborate? I am a bit confused with your last post.

this will give you erroneous output. you will be counting all instances of ORA- including ORA-00600. try appending a line with ORA-00600 in your logfile and run this command.