Re: Unix script to monitor iostat on AIX 4.3.3

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 5 Sep 2003 00:13:38 +1000
Message-ID: <3f57489f$0$14558$afc38c87@news.optusnet.com.au>

"Sanji" <sanji_aqua_at_yahoo.com> wrote in message news:3329208.1062673680_at_dbforums.com...
>
> $ORACLE_HOME/bin/sqlplus internal <<EOF

IIRC, the "<<EOF" construct requires a line with "EOF" *starting in column 1* for it to be recognized as the terminator. You have it indented, below. That won't work.

>
> insert into stats\$iostat values
>
> (SYSDATE, 5, '$HDISK', $VMSTAT_IO_R,$VMSTAT_IO_W);
and again IIRC, the '$HDISK' might not work at all as the shell will ignore the variable inside single quotes and consider it as a simple string instead of expanding it. You may need \'$HDISK\' instead. Ie, escape the single quote.

>
> exit
>
> EOF

 ^^^^^^^

get rid of this indent. It should be just EOF HTH

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Thu Sep 04 2003 - 09:13:38 CDT