I advise you read man test. It will help you a lot.
The error on line 8 is because your if statement is not valid.
You can't do the -2 inside the if statement. Also to check numbers you use -lt (less than). It's also explained in the man page. So you could do something like this:
Code:
v_primary = `expr $v_primary - 2`
if [ $v_standby -lt $v_primary ]
then
mailx -s "Standby lagging behind;" xyz@yahoo.com
fi
Expr is used to evaluate our values as expressions, so we can do some math with it. See man expr.
Now for the other error (sqlplus: not found.), you should be able to figure that out. It means your script can't find where sqlplus is. Locate the sqlplus binary on your system (use find or which) and add the full path in your script every time you call sqlplus). Good luck
Last edited by vimes; 10-24-2008 at 06:44 AM..
Reason: Code fix
I have a script that performs an oracle export:
<snip>
if
then
exp / full=y file=${exp_file} log=${exp_log} direct=y feedback=1000000 STATISTICS=NONE buffer=20000000
else
exp / full=n owner=${schema_name} file=${exp_file} log=${exp_log} direct=y feedback=1000000... (4 Replies)
Hi All,
I am using below shell script using SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view.If the STANDBY appears to be falling behind by - 2, then alert mail should be sent...
How could I achieve it with improving the below script.
#!/usr/bin/ksh
... (0 Replies)
Hi All,
AIX 5.3 64 bit:
I am using the below shell script the objective is:
Objective:
========
Use SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view. If the STANDBY appears to be falling behind,then send alert mail through the below shell script:
How... (0 Replies)
Hi All,
OS:AIX 5.3 64 bits
I would like the below script to send alert mail with the message - "Standby logs falling behind Primary" to xyz@yahoo.com
Script
=====
#!/usr/bin/ksh
#-----------------------------------------------------------------------------
# Use SQL*Plus to query... (1 Reply)
Hi,
I have ssh'd into a UNIX server at work from my linux desktop and executed a tar command to backup up some directories to a tape drive. I was wondering would the tar command still execute to completion if I closed my terminal console on my desktop that is connected to the server, would the... (1 Reply)
Hi !
How to export ENV variables, which remains set for all the shell
Example :-
Login :myID
Pwd : **** -> Here my ID .profile is executed. Let say I set MYENV variable
Kisses% rlogin ABC -l XXXGroupID -> I login into a remote Solaris Server ABC
password : **** -> "XXXGroupID's... (1 Reply)
guys,
I am new shelll scripting..
this a question on passt exam paper, I was trying to solve it , I can not.
the question is as follow?
a. Write a shell script to count the number of accounts which belong to particular primary group in a standard UNIX system which uses local... (1 Reply)
Hello all,
I want to display all the user logged last week and know the time tnat they are connected. I have been looking for a solution in the Forum, but I didn't find.
Thanks in advance (4 Replies)
Hello,
i have a network device that users connect to using ssh. I have a script that connects to the device and has to echo something to other connected people. How can this be established?
ssh user@device 'echo Hello > /dev/console' doesn't seem to do the trick. (2 Replies)
Hello,
I have a machine with Solaris 8, and it has multiple interfaces that are connected to the same network which means they all have metric 0 (1 hop) to the default gateway.
assume:
* e1000g0: 10.1.1.70
* e1000g2: 10.1.1.72
* e1000g4: 10.1.1.74
* e1000g5: 10.1.1.76
* gateway:... (11 Replies)
Discussion started by: aeg
11 Replies
LEARN ABOUT PLAN9
ssh-argv0
SSH-ARGV0(1) BSD General Commands Manual SSH-ARGV0(1)NAME
ssh-argv0 -- replaces the old ssh command-name as hostname handling
SYNOPSIS
hostname | user@hostname [-l login_name] [command]
hostname | user@hostname [-afgknqstvxACNTX1246] [-b bind_address] [-c cipher_spec] [-e escape_char] [-i identity_file] [-l login_name]
[-m mac_spec] [-o option] [-p port] [-F configfile] [-L port:host:hostport] [-R port:host:hostport] [-D port] [command]
DESCRIPTION
ssh-argv0 replaces the old ssh command-name as hostname handling. If you link to this script with a hostname then executing the link is
equivalent to having executed ssh with that hostname as an argument. All other arguments are passed to ssh and will be processed normally.
OPTIONS
See ssh(1).
FILES
See ssh(1).
AUTHORS
OpenSSH is a derivative of the original and free ssh 1.2.12 release by Tatu Ylonen. Aaron Campbell, Bob Beck, Markus Friedl, Niels Provos,
Theo de Raadt and Dug Song removed many bugs, re-added newer features and created OpenSSH. Markus Friedl contributed the support for SSH
protocol versions 1.5 and 2.0. Jonathan Amery wrote this ssh-argv0 script and the associated documentation.
SEE ALSO ssh(1)Debian Project September 7, 2001 Debian Project
10-24-2008
