Does listener service require Oracle server to be installed?

Question

I have installed Oracle 8i Client version in my machine. I have created local service naming to. I am trying to connect the local service. I am getting below error,

The test did not succeed.
ORA-12541: TNS:no listener

There may be an error in the fields entered,
or the server may not be ready for a connection. 

Do I need server to be installed in my machine for the listener to be run in my machine?

Answer 1

• Where is the database server running?
• Did you create a listener on the local machine? If so, please post the listener.ora in addition to the tnsnames.ora file.

Normally, the listener would run on the database server. It is possible to run the listener on a machine other than the database server but that would not be a particularly common configuration. It would be much more common to run the database and the listener on your laptop.

It would be extremely unusual, though, to want to install any version of 8i today. 8.1.7 has been desupported for nearly a decade and isn't supported on any operating system that is vaguely near supported.

Answer 2

yes, the listener is part of the server, not the client. As you're trying to connect to a locally installed server (I guess) and that server doesn't exist (as you installed only the client) the client will respond that there is no listener (as the listener would be what's replying to the client, not the server directly).