Sponsored Content
Top Forums Shell Programming and Scripting tail -XXX with grep doesn't work in while loop Post 302410616 by sidobre on Tuesday 6th of April 2010 11:09:28 AM
Old 04-06-2010
Hi Panyam,

Yes I've echoed MSG and return $? fro grep. Below, the result execution on debug mode :
Code:
#!/bin/sh -xv
#***********************************************************
# recherche alerte ORA-600 et autres erreurs ORA-
# la liste des ORA- est dans parm_alert_log.ora
#***********************************************************
export ORA_ADMIN=/oracle/home/admin
+ export ORA_ADMIN=/oracle/home/admin
+ ORA_ADMIN=/oracle/home/admin
export ORACLE_SID=GESDOS
+ export ORACLE_SID=GESDOS
+ ORACLE_SID=GESDOS
#for MSG in `cat ${ORA_ADMIN}/param_alert_log.ora`
cat ${ORA_ADMIN}/param_alert_log.ora | while read MSG
do
  echo $MSG
  echo "tail -400 ${ORA_ADMIN}/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.log \| grep $MSG"
  tail -400 ${ORA_ADMIN}/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.log | grep $MSG >> /tmp/ora600_${ORACLE_SID}.ora
  echo "Return val grep : $?"
done
+ cat /oracle/home/admin/param_alert_log.ora
+ read MSG
+ echo $'ORA-00600\r'
ORA-00600
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00600
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00600
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-00600\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-1631\r'
ORA-1631
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1631
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1631
+ grep $'ORA-1631\r'
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-1650\r'
ORA-1650
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1650
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1650
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-1650\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-1652\r'
ORA-1652
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1652
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1652
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-1652\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-1653\r'
ORA-1653
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1653
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1653
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-1653\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-00447\r'
ORA-00447
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00447
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00447
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-00447\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-00603\r'
ORA-00603
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00603
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-00603
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-00603\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-01092\r'
ORA-01092
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-01092
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-01092
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-01092\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-02050\r'
ORA-02050
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-02050
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-02050
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-02050\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-1535\r'
ORA-1535
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1535
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-1535
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-1535\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG
+ echo $'ORA-02236\r'
ORA-02236
' echo 'tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-02236
tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log \| grep ORA-02236
+ tail -400 /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
+ grep $'ORA-02236\r'
+ echo 'Return val grep : 1'
Return val grep : 1
+ read MSG

#*************************************************************
# si erreur, envoi email . . . .
#*************************************************************
check_stat=`cat /tmp/ora600_${ORACLE_SID}.ora|wc -l`;
cat /tmp/ora600_${ORACLE_SID}.ora|wc -l
++ cat /tmp/ora600_GESDOS.ora
++ wc -l
+ check_stat=0
oracle_num=`expr $check_stat`
expr $check_stat
++ expr 0
+ oracle_num=0
if [ $oracle_num -ne 0 ]
then
   newm=`diff /tmp/ora600_${ORACLE_SID}.ora /tmp/ora600_${ORACLE_SID}.old|wc -l`
   chgflg=`expr $newm`
   if [ $chgflg -ne 0 ]
   then
      #*************************************************************
      # si erreur , envoi mail
      #*************************************************************
      #cat /tmp/ora600_${ORACLE_SID}.ora | mailx -s "$ORACLE_SID : alerte(s) ORA- detectee(s)" admin@site.fr
      echo "envoi mail"
   fi
fi
+ '[' 0 -ne 0 ']'

cp /tmp/ora600_${ORACLE_SID}.ora /tmp/ora600_${ORACLE_SID}.old
+ cp /tmp/ora600_GESDOS.ora /tmp/ora600_GESDOS.old
# rm -f /tmp/ora600_${ORACLE_SID}.ora

My alert log for debugging is :
Code:
cat /oracle/home/admin/GESDOS/bdump/alert_GESDOS.log
ORA-00600 : #### test error ####
ORA-1631 : #### test2 ####

Thanks

Last edited by sidobre; 04-06-2010 at 12:14 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep doesn't work within shell script?

I am trying to run the following code from a script file but it complains that syntax of (both instances of) grep is wrong. When I copy and paste it to the terminal, it is OK. Any idea what the problem might be? set i = `grep -c #define flags.h` while ($i>20) @ i-- my func (`cat... (4 Replies)
Discussion started by: barisgultekin
4 Replies

2. UNIX for Dummies Questions & Answers

Why script For...Loop doesn't work. Seek help

I have written a script to run on UNIX server. When I tested, it always hanged on after "date +"%D %T: XXXXXX script started." part. Then it wouldn't go further. UNIX server gave me one error message. I used the same code in another script. It works fine. I think the major problem may be in... (3 Replies)
Discussion started by: duke0001
3 Replies

3. Solaris

grep -e doesn't work on solaris

grep -e doesn't work in Soalris. Same script with grep -e worked on AIX/HP/LINUX.. I would like to search a list of patterns on "log.txt" like ... grep -e FATAL -e ERROR log.txt I get the error message as grep: illegal option -- e Usage: grep -hblcnsviw pattern file . . . (3 Replies)
Discussion started by: jmkraja
3 Replies

4. Shell Programming and Scripting

for loop doesn't work

I have a script which uses below for loop: for (( i = 0 ; i <= 5; i++ )) do echo "Welcome $i times" done But when I run the script, it gives error message: Syntex Error : Bad for loop variable Can anyone guide to run it? Thanks in advance. (10 Replies)
Discussion started by: naw_deepak
10 Replies

5. UNIX for Dummies Questions & Answers

For some reason, my grep doesn't work as expected

I am trying to find only those entries where 7018 and another number appear in the end of the line. 7018 2828 1423 2351 7018 2828 14887 2828 7018 1222 123 7018 1487 I am looking for a way to generate only the last two lines. I was trying to do just "grep '7018{1,5}" but it does not... (5 Replies)
Discussion started by: Legend986
5 Replies

6. Shell Programming and Scripting

two grep in one script doesn't work?

Hi there, the following script doesn't work. the first part works, then the second 'grep' fails with ': not found'. However, if I take out the second part (starting with the grep command) and put in a seperate script, it works. everyone know what's wrong here? no two 'grep' in one script, that... (2 Replies)
Discussion started by: monkey77
2 Replies

7. Shell Programming and Scripting

Script doesn't work in loop but does if not

I have a script that only works if I remove it from the looping scenario. #!/bin/bash # Set the field seperator to a newline ##IFS=" ##" # Loop through the file ##for line in `cat nlist.txt`;do # put the line into a variable. ##dbuser=$line echo "copying plugin..." ... (6 Replies)
Discussion started by: bugeye
6 Replies

8. Shell Programming and Scripting

pipe to grep doesn't work in bash script

Hi, I'm trying to write a script that checks gvfs to see if a mount exists so I can run it from network-manager's status hooks. I thought I'd pipe the output of gvfs-mount -l to grep for the particular mounts I care about. When I do this in a bash script: cmnd="gvfs-mount -l | grep -i... (4 Replies)
Discussion started by: kcstrom
4 Replies

9. Shell Programming and Scripting

Why doesn't "grep -w" ALWAYS work?

Working with IP addresses is a pain... Here's my problem: I'm putting some interface information to a file: 3.185.201.2 | Tu1102 152.162.54.130 | Gi0/2.36 3.185.226.2 | Gi0/1 3.185.0.82 | Tu1 ... (12 Replies)
Discussion started by: turk22
12 Replies

10. Shell Programming and Scripting

Grep doesn't work when assigning to variable

Hello, First of all, I'd like to say hello to all members of forum. Can You please help me with the matter described below? I am trying to fetch a data from the file to variable, I am doing this using below script: returned=`tail -50 SapLogs.log | grep -i -E "Error|"` echo $returned ... (2 Replies)
Discussion started by: jedzio
2 Replies
All times are GMT -4. The time now is 09:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy