Re: Controlling batch SQLPLUS

Ron,

You didn't specify the version. If it's 9i, then you could use the option LOGON to attempt logon only once.

sqlplus -LOGON user/pass_at_remotedb

If the connection is not successful for whatever reason, the prompt returns.

HTH. Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, April 17, 2003 10:42 AM

> When I try to run a sqlplus in batch against a remote database and the
> database is down or the password is incorrect, the batch script hangs for
a
> long time. Is there a parameter that can be set to limit or eliminate
this
> 'hang time'?
>
> Ron Smith
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited. Please let me know
> immediately by return e-mail if you have received this message by mistake,
> then delete the e-mail message. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).