Re: ORA-12541: TNS:no listener

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 Received on Fri Oct 08 2004 - 08:33:13 CDT