Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS no listener Oracle10g redhat es
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 DBAReceived on Tue Jul 05 2005 - 17:32:03 CDT