Re: Problems starting the tns listener of the oracle server

From: <xsun1913_at_my-dejanews.com>
Date: Fri, 20 Nov 1998 16:39:34 GMT
Message-ID: <734602$rrp$1@nnrp1.dejanews.com>

In article <7343k9$phq$1_at_nnrp1.dejanews.com>, goku143_at_my-dejanews.com wrote:
> Im having problems starting the TNS listener of the oracle server. Currently
> Im using Client SQL*NET to access the server but unfortunately the client
> displays a message that there is no listener. Anybody who could help me with
> this matter?
>
> Samuel Cua
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Hi, Samuel,

On the database server, do a "lsnrctl status" to display the status of the SQL*Net listener. Do a "lsnrctl start" to start the listener. On a NT box, you can go to the control panel -> service to look at or start the listener. You can start the listener from the DOS prompt as well. On your client machine, Do a "tnsping" to make sure your application is able to talk to the listener.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 10:39:34 CST