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:47:57 +0200
Message-ID: <42cc5173$0$8786$ba620dc5@text.nova.planet.nl>

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns968AC01DA1C78SunnySD_at_68.6.19.6...
> "Raymond" <daelen_at_wxs.nl> wrote in
> 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
> >
> >
>
> Another possibility is that SQLNET.ORA contents may be coming into play;
> such as "authentication" or "domain" lines.

Hmm, not much in my sqlnet.ora
just one line, something like:

     names.directory path (tnsnames, ..)

What do you refer to?

Raymond Received on Wed Jul 06 2005 - 16:47:57 CDT

Original text of this message

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