You can't use 127.0.0.1 as the ip address. That's a loopback address that
the XP box will link to itself. Setup a 10.x or 192.168 address.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Raymond" <daelen_at_wxs.nl> wrote in message
news:42cc4f53$0$2453$ba620dc5_at_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 - 18:08:03 CDT
