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: Raymond <daelen_at_wxs.nl>
Date: Wed, 6 Jul 2005 23:40:09 +0200
Message-ID: <42cc4fa1$0$2453$ba620dc5@text.nova.planet.nl>

"Dave" <x_at_x.com> wrote in message
news:NKEye.63723$G8.19876_at_text.news.blueyonder.co.uk...
>
> "Raymond" <daelen_at_wxs.nl> wrote in message
> news:42cb0556$0$17812$ba620dc5_at_text.nova.planet.nl...
> > 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
> >
> >
>
> tnsnames setup ok? firewall?
>
>

tnsnames seems OK to me (see response to Sybrand), firewall crossed my mind but changed IPtables to alow all trafiic through port 1521. Received on Wed Jul 06 2005 - 16:40:09 CDT

Original text of this message

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