Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 12541: no listener
"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 addressReceived on Sun Feb 02 2003 - 16:29:52 CST