The TNSPING utility will only check whether there is an active Listener for
the SID. It does NOT check whether the database is actually active.
Pavel Polcar wrote in message <01bd6f4b$bdbb4900$47c3657e_at_polcar_nt4006>...
>Hi,
>I think you have to distinguish two things: one is to check if the instance
>is alive and kicking, this can be done with the TNSPING program like this:
> TNSPING <sid>
>(the name TNSPING may be different, check your ORACLE_HOME/bin directory);
>the second is the matter of valid user and password which I believe cannot
>be checked without attempting to connect.
>
>HtH
>--
>Pavel Polcar
>
>Freddy Knoll <freddy-knoll_at_software-kompagniet.com> wrote in article
><353F35C3.1C6D4A67_at_software-kompagniet.com>...
>> Is it possible to test a connect string user/password_at_instance without
>> actually doing the connect ?
>>
>> Regards,
>> Freddy Knoll
>>
Received on Tue Apr 28 1998 - 09:38:31 CDT
