Shell Programming and Scripting

Hi All,

OS:AIX 5.3 L

My shell script using ssh remains connected at primary site and ssh doesn't get disconnected.What should be typed and where in the shell script below to do it.

Shell script
========

#!/usr/bin/ksh

v_standby=`sqlplus -s /nolog <<END
@standby.sql
END`
echo $v_standby

ssh abc@hostname.domain
v_primary=`sqlplus -s /nolog <<END
@primary.sql
END`
echo $v_primary
if [ $v_standby < $v_primary - 2 ]
then
mailx -s "Standby lagging behind;" xyz@yahoo.com
fi


primary.sql
===========


set lines 500 pages 500
set verify off
set head off
connect / as sysdba
select /*+ rule */ max(h.sequence#) logseq_on_primary
from v$log_history h,
v$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';
exit;


standby.sql
===========

set lines 500 pages 500
set verify off
set head off
connect / as sysdba
select /*+ rule */ max(h.sequence#) logseq_on_standby
from v$log_history h,
v$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';
EXIT;

Hello. What are you trying to do exactly? If there's an enter after your ssh statement, then it's normal it stays connected:

Code:

ssh abc@hostname.domain

That just makes a connection to hostname.domain and leaves the session open. The syntax to execute a command remotely is:

Code:

ssh user@hostname command

I'm not 100% sure what you are trying to do, but you probably want:

Code:

#!/usr/bin/ksh

v_standby=`echo @primary.sql | sqlplus -s /nolog`
echo $v_standby

v_primary=`ssh abc@hostname.domain "echo @primary.sql | sqlplus -s /nolog"`
echo $v_primary
if [ $v_standby < $v_primary - 2 ]
then
mailx -s "Standby lagging behind;" xyz@yahoo.com
fi

But then the file primary.sql will need to exist on the primary server.

Hi vimes,

I am getting this error while running the script:

498
ksh: sqlplus: not found.

./stdby_check1.sh[8]: -: 0403-012 A test command parameter is not valid.

Now what should be looked into it for the fix..

-Amit

Hello,

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

it is long time ago when i was forced to use aix .. bash has these days option -s that allows you to send you code from stdin. that can be used to keep you code on computer A while it is executed on B.
example:
echo "/usr/bin/date" | ssh user@remote "/bin/bash -s"

now replace "echo date" with cat <<EOF my complicated suff and you can keep you code on one computer alone.

Hi All,

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 could I connect to the primary database in the below shell script using SSH?

#-----------------------------------------------------------------------------
# Use SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view. If the STANDBY appears to be falling behind, send alert mail..
#-----------------------------------------------------------------------------
_OutFile=/tmp/stdby_chk_$$.out
sqlplus -s /nolog << __EOF__ > ${_OutFile} 2>&1
whenever oserror exit 99
connect / as sysdba
set verify off

whenever sqlerror exit 6
col logseq_on_standby new_value V_STDBY_LOGSEQ
select /*+ rule */ max(h.sequence#) logseq_on_standby
from v\$log_history h,
v\$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';

col filecnt new_value V_STDBY_FILECNT
select count(*) filecnt
from v\$datafile;

whenever sqlerror exit 7
connect ${_PriUnPwd}

whenever sqlerror exit 8
col logseq_on_primary new_value V_PRIMARY_LOGSEQ
select /*+ rule */ max(h.sequence#) logseq_on_primary
from sys.v_\$log_history h,
sys.v_\$parameter p
where h.thread# = to_number(decode(p.value,'0',1,p.value))
and p.name = 'thread';

col filecnt new_value V_PRIMARY_FILECNT
select count(*) filecnt
from v\$datafile;

whenever sqlerror exit 9
begin
if &&V_STDBY_LOGSEQ < &&V_PRIMARY_LOGSEQ - 2 then
--
if &&V_PRIMARY_FILECNT > &&V_STDBY_FILECNT then
--
raise_application_error(-20001,
'${_StdbyOraSid} is falling behind; datafile(s) were added to PRIMARY');
--
elsif &&V_PRIMARY_FILECNT < &&V_STDBY_FILECNT then
--
raise_application_error(-20002,
'${_StdbyOraSid} is falling behind; datafile(s) were dropped from PRIMARY');
--
else
--
raise_application_error(-20000,
'${_StdbyOraSid} is falling behind.');
--
end if;
--
end if;
end;
/
exit success
__EOF__


Anyone could help would be appreciated!!

Thanks for your time!

Regards,