Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

difference

What is LOCAL_LISTENER and REMOTE_LISTENER  ?
0
thomasliju
Asked:
thomasliju
  • 2
1 Solution
 
regmigrantCommented:
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
0
 
slightwv (䄆 Netminder) 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
0
 
regmigrantCommented:
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/
0
 
thomaslijuAuthor Commented:
Thank you..
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now