Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS no listener Oracle10g redhat es

Re: TNS no listener Oracle10g redhat es

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Jul 2005 00:32:03 +0200
Message-ID: <tg2mc1hkefolcgamffeae2pc79j3sv5i5q@4ax.com>


On Wed, 6 Jul 2005 00:10:50 +0200, "Raymond" <daelen_at_wxs.nl> wrote:

>hello,
>
>I'm running Oracle 10g on redhat es3 and want to access the database from my
>windows XP (no sp2) machine on which the 10g client software has been
>installed.
>However, starting sqlplus (or other tools) I get the TNS:no listerner error.
>On the redhat machine i can startup sqlplus and log on using
>scott/tiger_at_sid, so the listerner is running correctly (lsnrctl status also
>give a messag einicating it is running), datbase is open mounted etc. I
>cannot log on to the databse from the xp client machine.
>I can ping the machine, but tnsping fails (no listener message)!
>
>What to do next to figure out the problems?
>TIA
>
>Raymond
>

Either the host = definition in tnsnames.ora doesn't match the one in listener.ora, or the port numbers do not match. The error message states Oracle can't find a listener at the specified host and port.

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Jul 05 2005 - 17:32:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US