Wednesday, May 27, 2009

ORACLE - Use of tnsnames.ora and listener.ora files

LISTENER.ORA
This file contains configuration for the server side.It contains details like on which port, which protocol etc the server should listen for connection requests from clients. This file is found in ORACLE_HOME/network/admin directory.

TNSNAMES.ORA
The file contains configuration for client side. It can be found in the ORACLE_HOME/network/admin . This file will also be present on the server if client is also on the same machine as server. This file needs to be configured for all clients with the IP address and port of the server so that clients can communicate with the server.

I will come up with the configuration of these files shortly for using a gateway.

1 comment: