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: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 06 Jul 2005 19:51:53 +0200
Message-ID: <dah5cr$ntt$2@news2.zwoll1.ov.home.nl>


Raymond 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
>
>

configure your local tnsnames to run without listener, example at http://vanbortel.blogspot.com/2005/05/watch-out.html

-- 
Regards,
Frank van Bortel
Received on Wed Jul 06 2005 - 12:51:53 CDT

Original text of this message

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