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: TNS:no listener

Re: ORA-12541: TNS:no listener

From: Alan <alan_at_erols.com>
Date: Fri, 8 Oct 2004 15:49:50 -0400
Message-ID: <2so9b0F1naprmU1@uni-berlin.de>

"Someone" <abc_at_def.com> wrote in message news:u-idnYYeFfc4CvvcRVn-ig_at_golden.net...
> Gyruss suggested that:
> > Dear all,
> >
> > I have no trouble connecting to orcl on a windows 2000 box if I don't
> > specify a TNS connection string, whenever I do though, I get the error:
> >
> > ORA-12541: TNS:no listener
> >
> > The service is running and the database name is defined in tnsnames.ora.
> >
> > What gives?
> >
> > Cheers,
> >
> > David
>
> I was called in to resolve a similar problem when this error message
> popped up on a machine just yesterday; our application could not connect
> to a database though the Oracle client software installed on the
> machine. I double checked the Oracle client software and config;
> everything looked good. Even more baffling was the fact that SQL*Plus
> COULD connect, but tnsping received same no listener message.
>
> Nearly stumped I took a look at the service running under the hood of
> the windoze machine and found an unfamiliar service running. When I
> consulted our admin guy he informed me that the service was non other
> than ZoneAlarm. After I stopped the service everything was peachy; all
> could see the database.
>
> Nonetheless I uninstalled ZoneAlarm off the machine. ;)
>
> HTH
ZoneAlarm is a firewall. Is the machine protected? Received on Fri Oct 08 2004 - 14:49:50 CDT

Original text of this message

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