If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Configuring Listener.ora and Tnsnames.ora

Can someone give me the idiot's guide to these files? I'm not clear on their use and what needs to be configured in them. Do I simply list all the db's on the server in these two files? Or do I need to list db's on external servers? Or both? What processes use them? Or simply point me to some decent doc on the subject.

Re: Configuring Listener.ora and Tnsnames.ora

Hi,
This is how listener.ora and tnsnames.ora work.

Pre assumption : Client and Sever are on different PCs
When u try to connect through SQL Plus(scott/tiger@connectstring) what Oracle does is is read the tnsnames.ora file which is located in the client machine in Orahome/bin/network/admin/tnsnames.ora.The tnsnames.ora file lists the name of the connect strings where the client has the capability to connect to.When it finds a match it reads the name of the server(where it should connect to),the protocol it should use(TCP) and the port on which a listener is listening.(default 1521).When it finds a match it goes to the relevant server and knocks on the port 1521 where the listener is waiting to hear in coming calls.Now the listener checks it own files(listener.ora which is located in the server itself) and matches it with the incoming call request.If it matches u are given an entery and a session is created....

Cheers,
Pinaki

Originally posted by jayharper
Can someone give me the idiot's guide to these files? I'm not clear on their use and what needs to be configured in them. Do I simply list all the db's on the server in these two files? Or do I need to list db's on external servers? Or both? What processes use them? Or simply point me to some decent doc on the subject.