Re: TNS no listener Oracle10g redhat es

From: Raymond <daelen_at_wxs.nl>
Date: Wed, 6 Jul 2005 23:38:50 +0200
Message-ID: <42cc4f53$0$2453$ba620dc5@text.nova.planet.nl>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tg2mc1hkefolcgamffeae2pc79j3sv5i5q_at_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

Thanks, for the tip, but still not working The entry in tnsnames.ora (on linux) for host name matches the host name in the listener file, and also matches the machines host name (ic matches the output of uname -a), also the portnumber are always 1521! (btw the names in tnsnames on windows also matche!).

Another thing that puzzles me, if I do lsnrctl status i get:

(DESCRIPTION = ...(HOST = 127.0.0.1)(PORT=1521)
(DESCRIPTION = ...(HOST = 127.0.0.1)(PORT=8080)(presentattion = ...
(DESCRIPTION = ...(HOST = 127.0.0.1)(PORT=2100)(presentattion = ...

and a little bit down :
instance vino (my sid) status READY
So apparently (?) wrong ip adres linked to host by the listener?!?

When asking for status immediately after strating the listener I get service SQLExtProc, and only after a while does the service vino appear!

I tried replacing the hostname with the IP adress (on linux box), but then i got another message: ora-12505 listener does not known of sid. (on windows). In this case the lsnrctl status gave: HOST=pomerol !!! But no lines referring to my sid!

Finally I tried replacing sidname = PLSExtProc for sidname = vino in the listener.ora, but this resukted in another error message ... admin net8 error. SO changed it back.

Any advice ?
What's wrong?

TIA Raymond Received on Wed Jul 06 2005 - 16:38:50 CDT