Home » SQL & PL/SQL » SQL & PL/SQL » tnsnames.ora and listener.ora
tnsnames.ora and listener.ora [message #210027] Tue, 19 December 2006 00:43 Go to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
Could anyone tell me Difference between tnsnames.ora and listener.ora?

Thanx
Re: tnsnames.ora and listener.ora [message #210030 is a reply to message #210027] Tue, 19 December 2006 00:50 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
listener.ora
tnsnames.ora


MHE
Re: tnsnames.ora and listener.ora [message #210031 is a reply to message #210027] Tue, 19 December 2006 00:51 Go to previous messageGo to next message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member

Listener.ora file consists of the listener configurations like,

1.Listener's name
2.Protocol addresses that it is accepting connection requests on
3.Services it is listening
4.Control parameters


A tnsnames.ora file maps net service names to connect descriptors.

In simple words, tnsnames.ora file provides the ability to reference oracle databases by a simple alias.

see below link also

http://forums.oracle.com/forums/thread.jspa?messageID=916395&
Re: tnsnames.ora and listener.ora [message #210034 is a reply to message #210027] Tue, 19 December 2006 00:55 Go to previous message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
Thanks to all of u.
Previous Topic: Pivot query
Next Topic: Clearing Redo logs
Goto Forum:
  


Current Time: Fri Dec 09 15:54:07 CST 2016

Total time taken to generate the page: 0.50837 seconds