tnsping checks the listener
connect within sqlplus shows if the instance is running

(this was a rtfm question...)

hth

Rüdiger J. Schulz
www.sosys-berlin.de


Yves schrieb:

>On windows 2000 server.
>
>ORACLE 9ir2
>
>Both listener and database service are running.
>
>
>When we do a tnsping it says that the servive is running.
>
>When we try to connect using sqlplus it says that ORACLE Realm down.....
>
>What is tnsping trying to do?
>
> Merci / Thanks
> Yves Leonard,
> Chef de Projet / Project Leader,
> DDS / SDD,
> RH Coats, 13-I
> Téléphone / phone : 613-951-3233,
> couriel / email : yves.[Email address protected]
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>


Oracle LazyDBA home page