Re: NOWAIT exit from sqlplus when ORA-12545

Hi Brian
Yes J run it from *.bat which makes an upgrade of many databases in the night.
We would like it continues even if one machine is not connected. Actually in this case; the traitement is stopped.

J can't really download Expect: it's for our customer and we can't modify his env.

Thanks
mso

Brian Peasland a écrit :

> mso wrote:
> > Hi
> > (it's for: Windows NT/XP and Oracle 8.1.7.4)
>
> Oracle 8.1.7.4 is not supported on Windows XP, so you may have issues
> that you cannot resolve.
>
> > J have a problem when J run test.bat such as :
> > sqlplus infolig/edfinfo_at_POR1_SPARE @my_file.sql
> > if %errorlevel% NEQ 0 echo KO: %ERRORLEVEL% else echo OK
> > %ERRORLEVEL%
> > --
> > When my POR1_SPARE server is not accessible/not connected the test.bat
> > is waiting with ORA-12545.
> > --------------------------------------------------------------------------------------------------------------------------------
> >
> > D:\IL\BD_IL5\EvoPrisme\Upgrade>sqlplus infolig/edfinfo_at_POR1_SPARE
> > @my_file.sql
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Ve Aou 18 15:16:31 2006
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > ERROR:
> > ORA-12545: Connexion impossible car l'h¶te ou l'objet cible n'existe
> > pas
> >
> >
> > Entrez le nom utilisateur :
> > --------------------------------------------------------------------------------------------------------------------------------
> > Would it be possible to avoid it and exit the sqlplus immediately (is
> > it any SqlNet parameter) ?
> >
> > Thanks a lot
> >
> > mso
> >
>
> Are you calling this from a script? Some errors, like ORA-12154,
> ORA-12545, ORA-1017 pause and ask for a new username/password. To exit,
> you'll need to send a break, CTL-C. This is a perfect job for the Expect
> scripting language (http://expect.nist.gov). Have Expect launch SQL*Plus
> for you. Tell is to expect the above errors and send CTL-C to the
> spawned program. You also tell is to expect the "SQL>" prompt, in which
> case, you can then have it send a command to SQL*Plus for you...such as
> "@script_name" or "exit". Expect runs on multiple platforms including
> Windows.
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Fri Aug 18 2006 - 11:15:42 CDT