Re: Listener problem

From: Dave <x_at_x.com>
Date: Sat, 13 Nov 2004 18:07:15 GMT
Message-ID: <n3sld.13990$up1.2041@text.news.blueyonder.co.uk>

"John Wood" <jwood_at_hotmail.com> wrote in message news:xWrld.97873$VA5.550_at_clgrps13...
> Hi there...
>
> I have installed an Oracle 9.2.0.2 Test Database in a window 2000
> professional workstation. I just set up the preloaded Oracle database
> from
> the disk. I have run through the Net Configuration and confirmed the
> Service name is properly defined in TNSNames.ora.
>
> I can run sqlplus into the database from the same workstation, but I
> cannot
> run sqlplus into it from another workstation. I received 'No Listener'
> error messages. I confirmed the Oracle database and TNSListener were
> running in the ControlPanel>Service.
>
> Please advise where else I have to check.
>
> Thanks.
>
> JW.
>
>

from a command prompt do

lsnrctl status

what do you get Received on Sat Nov 13 2004 - 12:07:15 CST