Re: oiconnect problem

From: John Theunis <john.theunis_at_advalvas.be>
Date: Sun, 10 Jun 2001 01:14:32 +0200
Message-ID: <9fuaht$q4e$1@news.worldonline.be>

hi,

if you are running the script on the same server as the db; try 'sqlplus internal @scriptname'

by
john

"Kim Connell, Client/Server DBA" <mouse_kc_at_hotmail.com> wrote in message news:5e998809.0106081036.59ffede4_at_posting.google.com...
> Hi all,
>
> I was creating a script to run a space management report on our oracle
> database
> instances one after the other. The problem is that if there is
> anything incorrect in the tnsnames.ora file or the sys password has
> changed the SQLPLUS interactive prompt comes up and causes problems.
> I want to have the connect string tested first, so that this does not
> happen, but every connect string I tried with ioconnect gives me a
> return code of 0, even if I can't connect to SQlPLUS using that
> string.
>
> example:
> > ioconnect sys/password_at_data.world
> > echo $?
> > 0
>
> Any ideas? Am I using ioconnect incorrectly? I am using Oracle 805
> on a SunOS 5.6 platform.
Received on Sat Jun 09 2001 - 18:14:32 CDT