RE: Attempting to run an SQL Script in backgrou...

It Worked as advised LSC. Thanks so much

Cheers

From: LS Cheng [mailto:exriscer@gmail.com]
Sent: Friday, May 11, 2007 3:49 PM
To: VIVEK_SHARMA
Cc: oracle-l@freelists.org
Subject: 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@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

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(*)

----------

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

$ 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***

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

VIVEK_SHARMA

2007-05-11