RE: slightly ot: nohup disables echo?

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 26 Feb 2004 12:07:03 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1A81@xchgbrsm1.corp.espn.pvt>

we prefer to do something like ...

nohup /oracle/gather.sh > /oracle/gather.log 2>&1 &

Raj

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Barbara Baker Sent: Thursday, February 26, 2004 11:58 AM To: oracle-l_at_freelists.org
Subject: slightly ot: nohup disables echo?

Hi, list!
Solaris 9 Oracle 9.2.0.4
Is there something about nohupping a script that will cause "set echo" in sqlplus to not work?

I'm trying to load a bunch of tables, and I'd like to run them in background. When I run the script in sqlplus, I see all my output (including the time stamps, which I really need.)
When I run in background, the ".lis" file is missing the timestamps.

Am I missing something obvious?

Here's a quick kludge that should show what I'm going. Thanks for any help.
Barb

nohup /oracle/gather.sh 1> /oracle/gather.log &

=====> gather.sh:

#!/bin/ksh
#set the environment
. /oracle/set_ent9i.sh
sqlplus -s user/pwd << EOF
set echo on
spool gather_one_table.lis
select name from v\$database;
@gather_one_table.sql
exit
EOF =====>gather_one_table.sql:
SET SERVEROUTPUT ON SIZE 1000000
SET FEEDBACK 1
SET TIME ON
SET ECHO ON HOST date
SPOOL gather_one_table.lis

exec dbms_stats.gather_table_stats -

        ( ownname=> 'ADVDB',        -
          tabname => 'XMLS_HIERARCHY',    -
          cascade => TRUE          -
          );

HOST date
exit

=====> gather_one_table.lis output:

$> more gather_one_table.lis

• EXECUTE dbms_stats.gather_schema_stats PROCEDURE

PL/SQL procedure successfully completed.

---

Do you Yahoo!?
Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 26 2004 - 11:22:44 CST