Re: Need help with "tnsping" to Oracle
Date: Thu, 25 Jul 2002 02:57:24 GMT
Message-ID: <oOJ%8.122840$Wt3.102403_at_rwcrnsc53>
TNSPING will only tell you if a Listener is up for a database.... not necessarily if a particular database is up. The best thing to do, from my perspective, is to connect to the actual database - or a simple select on a small table.
Alex Ivascu
"Dennis" <dennis-vb_at_writeme.com> wrote in message
news:30a87058.0207241846.18fdb639_at_posting.google.com...
> Hi there, i was wondering if someone can help me with this. In my VB
> application i wanted to check constantly if the Oracle is up or not,
> and i intend to do this using Shell "tnsping". But i'm not sure what
> would be the result from the "tnsping", and how to determine the
> oracle connectivity. Thanks very much.
>
> rgrds,
> Dennis
Received on Thu Jul 25 2002 - 04:57:24 CEST