Re: NOWAIT exit from sqlplus when ORA-12545

From: mso <marguerite.sochacki_at_c-s.fr>
Date: 22 Aug 2006 01:02:18 -0700
Message-ID: <1156233738.057614.305670@m73g2000cwd.googlegroups.com>

Hi
thanks everybody for your participation. The solution given by someone is to use sqlplus with -L option. So it does only one connection.
It's exactly what i need.
Thanks a lot

mso

StefanKapitza a écrit :

> mso wrote:
> > Hi
> > (it's for: Windows NT/XP and Oracle 8.1.7.4)
> > --
> > 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

>

> You could use tnsping or ping for a servercheck and then evaluate
> %errorlevel%.

>

> If you want to use SQLPLUS then you can use the /nolog switch and do
> the connect in
> the sql Script. Maybe you could build some error Handling with the
> spool command
> and a dos FIND.
>
> regards
>
> s.kapitza
Received on Tue Aug 22 2006 - 03:02:18 CDT