Re: NOWAIT exit from sqlplus when ORA-12545

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