difference

thomasliju
thomasliju used Ask the Experts™
on
What is LOCAL_LISTENER and REMOTE_LISTENER  ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>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/initparams120.htm#REFRN10082
sorry yes, I was referring to where they are registered but wasn't clear:
 older installation use static registration handled by  listener.ora, newer installations (v11, possibly earlier) use dynamic registration and can  reference entries in tnsnames.ora
http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/

Author

Commented:
Thank you..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial