<div>
Listeners receive incoming client requests and manage the &nbsp;traffic to the database they are services that monitor network ports<br />
<br />
Local listeners run on the same machine as the current instance and remote listeners run a different machine.<br />
<br />
they are configured in tsnames.ora
</div>


Listeners receive incoming client requests and manage the  traffic to the database they are services that monitor network ports

Local listeners run on the same machine as the current instance and remote listeners run a different machine.

they are configured in tsnames.ora

<div>
&gt;&gt;they are configured in tsnames.ora <br />
<br />
Do you mean listener.ora? &nbsp;tnsnames.ora is a client side configuration file.<br />
<br />
<br />
As far as the question remigrant is correct.<br />
<br />
Both of them are well described in the online docs:<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams211.htm#REFRN10183" rel="ugc">http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams211.htm#REFRN10183</a><br />
<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams120.htm#REFRN10082" rel="ugc">http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams120.htm#REFRN10082</a>
</div>


>>they are configured in tsnames.ora

Do you mean listener.ora?  tnsnames.ora is a client side configuration file.


As far as the question remigrant is correct.

Both of them are well described in the online docs:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams211.htm#REFRN10183 [http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams211.htm#REFRN10183]

http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams120.htm#REFRN10082 [http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams120.htm#REFRN10082]

<div>
<div class="content wysiwyg-content">
What is LOCAL_LISTENER and REMOTE_LISTENER &nbsp;?
</div>
</div>


What is LOCAL_LISTENER and REMOTE_LISTENER  ?

difference

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.