Thread Tools Search this Thread
Top Forums Shell Programming and Scripting counter
# 1  
Old 10-28-2009

I need some help.
Shell script counter. i need to add condition to check if counter is more than 10 and longer than 3 hours? it runs every 5 mins. it only check count and send email right now.
it runs in cron as below
gregcount.ksh gregdb 10 > /tmp/gregcount.out 2> /tmp/gregcount.err

if [ $# -ne 2 ]
then echo "Usage: $0 DB MAX_ALLOWED "
CNT=`${ORACLE_HOME}/bin/sqlplus -s \/nolog << EOF | tail +1 2>/dev/null
set pages 0
set head off
set feedback off
set termout off
set verify off
set echo off
connect system/${SYS_PWD}@${DB}
select count(*) from greg.counter;
# echo $CNT

if [ $CNT -gt $MAX_ALLOWED ]
then mailx -s "too many ( ${CNT} ) in $1 !! " $MAIL_LIST < /dev/null
echo "All is well !! "

Last edited by pega; 10-28-2009 at 11:03 PM..
# 2  
Old 10-28-2009

I think I understand the part of your question about the count > 10, but not at all sure about the part "longer than 3 hours".

What does that mean?

(and what does tail +2 do, and why are you directing standard error from SQL Plus when it really doesn't matter (it doesn't write there!)?)

/home/oracle/tmp10 > cat Test
sqlplus -s scott/tiger << EOF 2> /dev/null
set pages 0
set head off
set feedback off
set termout off
set verify off
set echo off
  select something from somethere_that_doesnt_exist;

/home/oracle/tmp10 > ./Test
  select something from somethere_that_doesnt_exist
ERROR at line 1:
ORA-00942: table or view does not exist

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Do i miss counter or what

hello this script should show all users and space they used without problem : ls /home >> /root/users.txt cat /root/users.txt | while read line; do space=`du -s /home/$line` echo "$line space is $space" shift done but when i remove pipe ,script run without any output: ls /home... (4 Replies)
Discussion started by: nimafire
4 Replies

2. UNIX for Dummies Questions & Answers

Pegging counter

Hi Experts, I am in need for some help. My competence level on unix is not at all helping me to resolve this. Please help. My Input for a system command is as under: Counters are getting pegged each hour. I need to have a difference printed rather than pegged counter values. Counter... (2 Replies)
Discussion started by: vanand420
2 Replies

3. Shell Programming and Scripting

Record counter

For the following code SEQ=200 awk -v S="$SEQ" ' $0 ~ S { N++ print N } ' "$1"ascii >"$1"search N is printed 8002 times as it occurred 8002 times in file how I could print the counter one time only (20 Replies)
Discussion started by: khaled79
20 Replies

4. Shell Programming and Scripting

Help require with counter

I have this file 1801,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,VOE,,,,,,,,,,,,,,, 1802,A1,2012-12-16 15:59:59.995,id2_3,ab=,phoneX1-01,BL,,,,,,,,,,,,,,, 1803,A1,2012-12-16 15:59:59.995,id2_3,ab,phone300,BL,,,,,,,,,,,,,,, 1804,A1,2012-12-16... (4 Replies)
Discussion started by: nikhil jain
4 Replies

5. Shell Programming and Scripting


if ;then echo "mrnet greater 5000" gzip /var/log/mrnet.log mv /var/log/mrnet.log.gz /var/log/mrnet.log.1.gz if ];then i=1 let i++ mv /var/log/mrnet.log.1.gz /var/log/vieux-logs/mrnet.log.$i.gz else echo "theres no... (1 Reply)
Discussion started by: Froob
1 Replies

6. Shell Programming and Scripting

problem with counter

i having a file xxxxxxxxxxxxxxx1234 ...........value can be change xxxxxxxxxxxxxxx1235 xxxxxxxxxxxxxxxx1236 . . . . xxxxxxxxxxxxxxxxx1300 ...........value can be change i want to cut last four characters of first line and last line and find the missing pattern. output should... (4 Replies)
Discussion started by: sagar_1986
4 Replies

7. Shell Programming and Scripting

List Counter

cat sport_by_month Month : Jan sport :Football sport :Volleyball Month: Feb sport :BasketBall sport: Cricket sport: Fotball Month: Mar Month: APR sport : Bowling sport : Climbing I need your help to have a script that count the number of sports per month and sorted by mont with... (7 Replies)
Discussion started by: Sara_84
7 Replies

8. UNIX for Dummies Questions & Answers

histogram or counter

Dear all, I have numerous dat files (a.dat, b.dat...) containing 500 numeric values each. I would like to count them, based on their range and obtain a histogram or a counter. INPUT: a.dat 1.3 2.16 0.34 ...... b.dat 1.54 0.94 3.13 ..... ... (2 Replies)
Discussion started by: chen.xiao.po
2 Replies

9. Shell Programming and Scripting

grep and counter

Hi, I have such an example(ksh): name1=Example directory=/directory1/Example/directory2 match=$(grep -s '$name1' $directory | wc -l) echo $match But it replies to me: 0 What I expect from it, is to find $name1 in $directory and produce 1 for me as true, not false. (3 Replies)
Discussion started by: chish
3 Replies
Login or Register to Ask a Question