Re: Listener problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sat, 13 Nov 2004 20:51:23 +0100
Message-ID: <47jcp0p41br1dlmae171l341sbm684tfnk@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 - 13:51:23 CST