paparao

• Oct 23rd, 2006

 

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

Patrick McShea

• Nov 15th, 2006

 

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...)

Sriniv@s..

• Jun 8th, 2012

 

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.