Re: Problems Connecting With TOra 1.2.3

From: Marek <MarkusJ23nospam_at_wp.pl>
Date: Wed, 26 Jun 2002 22:00:31 +0000 (UTC)
Message-ID: <Xns923A12AFA2E3MarkusJ23wppl@153.19.0.141>

Robert Tilley <tilleyrw_at_cfl.rr.com> wrote in news:W5qS8.58793$0g1.1352838_at_twister.tampabay.rr.com:

> I've completely installed Oracle 8i on my Debian Linux box. However,
> trying to connect to my database with TOra 1.2.3 results in an "ORA-12541:
> TNS: No Listener" error.
>
> Can a more experienced user help me to learn what this means and how to
> solve it?

Robert,

In order to connect Oracle server from another machine you have to launch TNS Listener on the server. Possible cases:

you didn't run it at all: visit your $ORACLE_HOME/bin directory and run lsnrctl program with option "start"
you perrform start database and listener during machine startup but listener started before database was available: you need to make sure listener always starts after database is available.
you have some network problems on the client machine - perhaps firewall blocking communication on port 1521 ?

Marek Received on Wed Jun 26 2002 - 17:00:31 CDT