Re: ** UNIX : set echo on in shell

vi mike.sql
<here is mike.sql>
select table_name from all_tables where table_name like '%TRANS'; <write quit>
vi mike.ksh
<create script> (this is my script)
echo "I want to list my environment so that tee can record it, not really pertinent"
echo "Now I am going to execute a sqlplus session" sqlplus /nolog <<EOF
connect / as sysdba
start mike.sql
exit
EOF
echo "now I am going to finish up"
exit 0

Now execute

./mike.ksh | tee mike.tee

<Output>

I want to list my environment so that tee can record it, not really pertinent
Now I am going to execute a sqlplus session

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Mar 3 05:50:22 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> SQL> SQL> SQL> Connected.
SQL> SQL> select table_name from all_tables where table_name like '%TRANS';

TABLE_NAME

TMO_GPRS_TRANS
TMO_VOICE_TRANS
TMO_SMS_TRANS

SQL> Disconnected from Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
now I am going to finish up

"Hope this helps"

A Joshi wrote:
> Mike,
> Thanks. Can you give example for tee.
> Thanks Howard, Bill, Dan, Mindagaus, Dave
>
> I tried
>
> set -x
> sqlplus ... 1>$OUTFIL
> 2>&1".
> set +x
>
> but somehow the log does not have the sqlplus command. The log has
> rest of the output. I can see the commands being displayed on the
> screen. I am doing :
>
> set -x
>
> sqlplus -s $user_at_db1 <mailto:$user_at_db1> @sql1.sql <.pw > $OUTFILE 2>&1
> sqlplus -s $user_at_db2 <mailto:$user_at_db2> @sql1.sql <.pw >> $OUTFILE 2>&1
> set +x
> Thanks

>

>


>     From: Mike Haddon <m.haddon_at_tx.rr.com>

>     Subject: Re: ** UNIX : set echo on in shell

>     To: oracle-l_at_freelists.org

>     Date: Sunday, March 1, 2009, 10:53 PM

>


>     if your looking for output to both stdout and a logfile either script or tee

>


>     script will put everything into a logfile and tee will split stdout to a

>     logfile as well

>


>     I.E - <shell command> | tee <file_name>

>     > Another option is simply "ksh -x sqlplus ... 1>$OUTFIL

>     2>&1".

>     > ---------------------------------------------------------------------

>     > Hi,

>     >    I am looking for a shell equivalent of  set echo on. set -x works and

>     gives the output on the screen. I am looking for a way so that it also goes to

>     the LOGIFLE. So I can get the command being executed in the log. For example  if

>     I have  :

>     > set -x sqlplus .... > $OUTFIL ... set +x

>     > 

>     > Then I want the output to go to log file. It displays on the screen but

>     does not go to log. From the log it is difficult to know which sqlplus had the

>     error. I tried to put a echo before the sqlplus to know it but i have to update

>     it each time so looking for a better way. Zoran and Frank helped out dba village

>     and I have made progress to this point. Could not find much on net. Thanks

>     >   

>


>     --

>     http://www.freelists.org/webpage/oracle-l

>
>


>               

>
>



--
http://www.freelists.org/webpage/oracle-l