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

It Worked as advised LSC. Thanks so much  

Cheers  

From: LS Cheng [mailto:exriscer_at_gmail.com] Sent: Friday, May 11, 2007 3:49 PM
To: VIVEK_SHARMA
Cc: oracle-l_at_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_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> 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