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: ORA 12541: no listener

Re: ORA 12541: no listener

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 2 Feb 2003 23:29:52 +0100
Message-ID: <v3r71msfshu2d3@corp.supernews.com>

"Marc Dietz" <MarcDietz_at_web.de> wrote in message news:3e3d9564$0$29810$9b622d9e_at_news.freenet.de...
> Hello,
>
> this may a trivial question for the advanced user, but to the beginner
it's
> seems to be confusing to find the right answer. So here we are:
>
> lately I've installed Ora 8.1.7. PE on my local machine, using Win2000.
>
> Each time I try to connect to the databases via SQL Worksheet or any of
the
> other given tools it works only fine if I'm on the internet. If not the
> connection will be refused with a simple message "ORA 12541 TMS: no
> listener".
>
> What is reason for this behavior? Do I need a local DNS?
>
> I've tried to configure a listener via NET8 but i didn't work.
>
> Can anybody give me a short help how to get the listener work local
without
> steady connection to the internet?
>
> Thanks in advance!
>
> Marc
>
> ________________________
> May the bash be with you!

You need to use the machine name as the nodename in host= or you need to setup localhost
as follows

127.0.0.1 localhost

in \winnt\system32\drivers\etc\hosts

and use host=localhost in listener.ora and tnsnames.ora

and of course issue lsnrctl start

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sun Feb 02 2003 - 16:29:52 CST

Original text of this message

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