What is difference between SQLNET.ORA AND TNSNAMES.ORA AND LISTENER.ORA??

Oracle mainly designed for three tire architecture so

Listner.ora ---> it is to set & add Listners at Server side configuration

TNSNAMES.ORA ---> This must be confugred at client side environment. These values must match the Server side configuration deatils.

For eg. To check the given or Configured  TNSNAMES command is

at command prompt

in 10g :    tnsping listner_name_def_at_tnsname

in 8i    :     tnsping80 listener_name_def_at_tnsname

SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ONAMES...)

  1 User has rated as useful.

  

Login to rate this answer.

SQLNET.ORA :: It is the optional network configuration file.it contain network configuration details.
LISTINER.ORA : It is the listener file for creating at server side
TNSNAMES.ORA:client side configuration file.it was matched with listener file.it for remote access.