I checked the listener.ora, and updated accordingly.
It works now. Thanks for all the info.
JW.
"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:47jcp0p41br1dlmae171l341sbm684tfnk_at_4ax.com...
> On Sat, 13 Nov 2004 17:57:49 GMT, "John Wood" <jwood_at_hotmail.com>
> wrote:
>
>>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.
>>
>
>
> The error typically occurs
> when
> - the host = in listener.ora and tnsnames.ora do not match
> - the port numbers in tnsnames.ora and listener.ora do not match
> - the sid used in tnsnames.ora doesn't match the sid in listener.ora
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Nov 13 2004 - 23:52:51 CST
