Re: My TNS listener stopped working

On Fri, 19 Apr 2002 17:59:40 +0000 (UTC), "Patrick Meyer" <buckeye234_at_excite.com> wrote:

<snip>
>As far
>as I know, this doesn't say anything about the state
>of the database, just that the listener is available and listening for
>the SID indicated in the TNS_NAMES.ora file.
>

<snip>

This is absolutely correct. A TNSPING only goes as far as the listener saying "yes, client, I hear you and if you had actually requesetd a connection I know what I'd do with it."

You can succesfully TNSPING for a non-existent database, as long as the listener has an entry for it.

FWIW.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)