Re: Attempting to run an SQL Script in background (with nohup) in HP-UX is Failing...Basic Qs.

sure

put sqlplus system/manager @f11.sql to a shell script and nohup shellscript

thanks

--
LSC


On 5/11/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:


>

>  Folks

>

>

>

> Attempting to run an SQL Script in background (with nohup) in HP-UX is

> Failing

>

>

>

> *Details:-*

>

>

>

> *SQL Script Runs without nohup*

>

>

>

> *$ sqlplus system/manager @f11.sql*

>

>

>

> SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 11 14:45:09 2007

>

>

>

> Copyright (c) 1982, 2005, Oracle.  All rights reserved.

>

>

>

> Connected to:

>

> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

> Production

>

> With the Partitioning, OLAP and Data Mining options

>

>

>

> SQL>

>

> SQL> spool f11

>

> SQL>

>

> SQL> select count(*) from sys.dba_users;

>

>

>

>   COUNT(*)

>

> ----------

>

>         28

>

>

>

> SQL>

>

> SQL> exit;

>

>

>

> *Attempting to Run with nohup Fails *

>

>

>

> *$ nohup sqlplus system/manager @f11.sql &*

>

>

>

> Sending output to nohup.out

>

>

>

> [2] + Stopped (tty output)     nohup sqlplus system/manager @f11.sql &

>

>

>

> $ cat nohup.out

>

>

>

> SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 11 14:38:21 2007

>

>

>

> Copyright (c) 1982, 2005, Oracle.  All rights reserved.

>

>

>

> $ uname -a

>

> HP-UX hpport3 B.11.23 U ia64 1312688625 unlimited-user license

>

> Oracle 10gR2

>

>

>

> *NOTE – Running with nohup (the Same Script) on Solaris 10 works normally.

> *

>

>

>

> *Qs. Advice pls on how to run an SQL Script in background with nohup on

> HP-UX?*

>

>

>

> Thanks indeed

>

>

>  **************** CAUTION - Disclaimer *****************

> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended

> solely for the use of the addressee(s). If you are not the intended

> recipient, please notify the sender by e-mail and delete the original

> message. Further, you are not to copy, disclose, or distribute this e-mail

> or its contents to any other person and any such actions are unlawful. This

> e-mail may contain viruses. Infosys has taken every reasonable precaution to

> minimize this risk, but is not liable for any damage you may sustain as a

> result of any virus in this e-mail. You should carry out your own virus

> checks before opening the e-mail or attachment. Infosys reserves the right

> to monitor and review the content of all messages sent to or from this

> e-mail address. Messages sent to or from this e-mail address may be stored

> on the Infosys e-mail system.

> ***INFOSYS******** End of Disclaimer ********INFOSYS***

>


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