Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Attempting to run an SQL Script in background (with nohup) in HP-UX is Failing...Basic Qs.

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

From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 11 May 2007 12:19:18 +0200
Message-ID: <6e9345580705110319m43bcf0b3xdd69c9572e1c2b77@mail.gmail.com>


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
Received on Fri May 11 2007 - 05:19:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US